Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Oracle Exadata Hardware - Version 11.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Goal
How do you change the default port 1521 to another port for a RAC configuration?
Solution
To get the current settings of your listener on RAC issue the following command:
> srvctl config listener
The output should be similar to the following
Name: LISTENER
Network: 1, Owner: oracle
Home: <CRS home>
End points: TCP:1521
Points to bear in mind:
+ The ILOM server is independent of the listener and will require no changes. (Exadata)
+ Cell Servers do not have Oracle Listeners on them and will also require no changes (Exadata)
+ At some point you have to restart the listener on each node. Depending on how your services are set up you may 'drive' traffic to one node if there are many connections. For this reason these changes should be done during a quiet time.
Steps to achieve the changes
(1) Amend the ports used with a command similar to the following
> srvctl modify listener -l LISTENER -p "TCP:<new-listener-port>"
This changes the entry in OCR, so that a listener restart will pick up the new values. Existing connections will remain connected.
(2) Modify the scan listener if applicable with
> srvctl modify scan_listener -p <new-scan-port>
(3) LOCAL_LISTENER should be changed manually
An example would be
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<Host-name>)(PORT=<new-port-number>))))' scope=both sid='[<your-chosen-instance> | * ] '
(4) Make similar changes to the REMOTE_LISTENER
(5) endpoints_listener.ora and local_listener.ora for each SID are only changed after the listener is stopped and restarted.
(6) Check the configuration afterwards with "srvctl config Listener".
