Shulou(Shulou.com)06/01 Report--

The default listening port number for ORACLE is 1521, and changing the default port number helps to increase the security of the ORACLE database server. Here, we change the port number of oracle from port 1521 to 9999

1. Check the monitoring status

$lsnrctl status

You can see that the listener port number is 1521 at this time.

2. Stop monitoring

$lsnrctl stop

3. Modify the configuration file

$vi $ORACLE_HOME/network/admin/listener.ora

Since we are changing the default port number from 1521 to 9999, we need to find 1521 and change it to 9999

4. Log in and view the local_listener parameters

$sqlplus / as sysdba > show parameter local_listener

Because the default value was used at the beginning, the VALUE is now empty.

5. Modify local_listener parameters

# Host name or IP added after host

> alter system set local_listener= "(address = (protocol = tcp) (host = 192.168.100.201) (port = 9999)"

6. View local_listener parameters

> show parameter local_listener

At this time, you can see the value.

7. Start monitoring

$lsnrctl start

8. Check the status

$netstat-an | grep 9999

9. Firewall port is open

$su-root# / sbin/iptables-I INPUT-p tcp-- dport 9999-j ACCEPT # / etc/rc.d/init.d/iptables save

At this time, the default port number has been changed from 1521 to 9999, and the oracle cannot be connected using port 1521.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.