How to change listener ports after cluster setup

The document describes the steps required for modifying listener port numbers after cluster setup.

• How to change SCAN listener port number
• How to change local listener port number

How to change SCAN listener port number

1. On the first node only, modify SCAN listener port number in CRS:

# su - grid
$ srvctl modify scan_listener -p <new_scan_listener_port>
$ srvctl stop scan_listener
$ srvctl start scan_listener

2. On each database node, update the following entry in /etc/flashgrid-scan.cfg (as root):

From: scan_port: 1521

To: scan_port: <new_scan_listener_port>

3. On each database node, restart Flashgrid SCAN Proxy service, and make sure that it is running successfully:

# systemctl restart flashgrid-scan-proxy.service
# systemctl status flashgrid-scan-proxy.service

How to change local listener port number

1. On each database node, modify port for NodeFQDN entry in <DATABASE_HOME>/network/admin/tnsnames.ora (as oracle):

DONOTDELETE,NODEFQDN = (ADDRESS = (PROTOCOL = TCP)(Host = <database node hostname>)(Port = <new_local_listener_port>))

2. On the first node only, modify local listener port number in CRS:

# su - grid
$ srvctl modify listener -p <new_local_listener_port>
$ srvctl stop listener
$ srvctl start listener

3. On each database node, update /etc/sysconfig/iptables (as root):

• Remove immutable flag from iptables file:

  # chattr -i /etc/sysconfig/iptables

• Modify value in /etc/sysconfig/iptables:

  From: --dport 1522

  To: --dport <new_local_listener_port>

• Add immutable flag to iptables file:

  # chattr +i /etc/sysconfig/iptables

4. On each database node, restart iptables:

# systemctl restart iptables.service

5. If you have already created database(s), connect to each database and run:

# su - oracle
$ sqlplus / as sysdba
SQL> alter system set local_listener='NODEFQDN';