Oracle 11gR2 RAC – How to change SCAN port

To change the SCAN port, one can use following command as grid owner

$ srvctl modify scan_listener -p 1523

1) Check if the changed port is reflected

$ srvctl config scan_listener

SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1523
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1523
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1523

2) Restart CRS stack / SCAN resources

3) One will also have to change the remote_listener values. So as oracle database owner

$ sqlplus / as sysdba
SQL> alter system set remote_listener=’myscan.mydomain.com:1523′ scope=both;

4) Change the necessary files in $ORACLE_HOME/network/admin on server & client

Advertisements
This entry was posted in Oracle Real Application Cluster and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s