Oracle Modify Listener Port Tutorial

Oracle default Listener Port 1521, a common scanner is usually detected by the 1521 port is open to detect the presence of Oracle services, if the modification of the default listening port to some extent can improve the security of the database and host.

For example, here we change to 2521 as an example.

1. View the current listening status

Lsnrctl status

2. Stop Monitoring

Lsnrctl stop

3. Modify the Listening profile

VI $ORACLE _home/network/admin/listener.ora

Modify the listening port 1521 to 2521

4. Modify the connection configuration file

VI $ORACLE _home/network/admin/tnsnames.ora

Change the connection port 1521 to 2521

5. Login database View Local_listener parameters

Sqlplus/As sysdbashow parameter Local_listener

If the port is not previously modified with the default configuration, the parameter value should be null at this time

6. Modify the Local_listener parameter

Alter system set local_listener="(address = (PROTOCOL = TCP) (HOST = 192.168.220.128) (PORT = 2521)" ;

7. Review the Local_listener parameters again

Show Parameter Local_listener

8. Restart Monitoring

Lsnrctl start

9. Check that the listening status is normal

grep 2521 lsnrctl statustnsping ORCL

Reference:

Http://www.jb51.net/article/102627.htm

http://blog.csdn.net/xaobai2010/article/details/7287604

Oracle Modify Listener Port Tutorial