Oracle Ubah Port

# VIEW listening status
lsnrctl status

# STOP listening
lsnrctl STOP

# 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
vi $ORACLE_HOME/network/admin/listener.ora

# LOG IN AND VIEW the local “listener parameter
sqlplus / AS sysdba
> show parameter local_listener

# MODIFY the local listener parameter, Host name OR IP after host
> ALTER SYSTEM SET local_listener="(address = (protocol = tcp)(host = 192.168.100.201)(port = 9999))";
> show parameter local_listener

# START listening
lsnrctl START

# VIEW status
netstat -an|grep 9999
lsnrctl status

# OPEN firewall port