thesuhu

Oracle Ubah Port

Sep 27th, 2021
870
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # VIEW listening status
  2. lsnrctl status
  3.  
  4. # STOP listening
  5. lsnrctl STOP
  6.  
  7. # MODIFY PROFILE, Since we are going TO change the DEFAULT port NUMBER FROM 1521 TO 9999, we need TO find 1521 AND change it TO 9999
  8. vi $ORACLE_HOME/network/admin/listener.ora
  9.  
  10. # LOG IN AND VIEW the local “listener parameter
  11. sqlplus / AS sysdba
  12. > show parameter local_listener
  13.  
  14. # MODIFY the local listener parameter, Host name OR IP after host
  15. > ALTER SYSTEM SET local_listener="(address = (protocol = tcp)(host = 192.168.100.201)(port = 9999))";
  16. > show parameter local_listener
  17.  
  18. # START listening
  19. lsnrctl START
  20.  
  21. # VIEW status
  22. netstat -an|grep 9999
  23. lsnrctl status
  24.  
  25. # OPEN firewall port
  26.  
RAW Paste Data