The document describes the steps required for modifying listener port numbers after cluster setup.
How to change SCAN listener port number
- 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
- 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>
- 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
- 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>))
- 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
- 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
- On each database node, restart iptables:
# systemctl restart iptables.service
- 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';