Oracle modifies the listening port number 1521

In Oracle, the default listener port number is 1521, once someone scans the port number will know that this server is an Oracle database server, there is a great security risk, here, teach you how to modify the Oracle default port number is 9999:

1. Viewing the Listening status

$ lsnrctl Status

2. Stop Monitoring
$ lsnrctl Stop

3. Modify the configuration file
$ VI $ORACLE _home/network/admin/listener.ora
1521----->9999

4. Log in and view Local_listener parameters
$ sqlplus/as SYSDBA
> Show Parameter Local_listener
(This value should be empty at this time)

5. Modify Local_listener Parameters
> Alter system set local_listener= "(address = (protocol = TCP) (host = 192.168.100.201) (port = 9999))";
#host后面加的主机名称或者IP

6. View Local_listener Parameters
> Show Parameter Local_listener

7. Start monitoring
$ lsnrctl Start

8. View status
$ netstat-an|grep 9999
$ LSNRCTL Status

9, firewall port open
$ su-root
#/sbin/iptables-i input-p TCP--dport 9999-j ACCEPT

#/etc/rc.d/init.d/iptables Save

This Oracle's listening port number has changed from 1521 to 9999.

Oracle modifies the listening port number 1521