oracle12c修改监听端口,11G RAC修改监听端口

Changing Listener Ports On RAC/EXADATA (文档 ID 1473035.1) 转到底部

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later

Oracle Exadata Hardware - Version 11.2.0.1 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: 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:”

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 (3) LOCAL_LISTENER should be changed manually

An example would be

SQL> alter system set local_listener=’(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=))))’ scope=both sid=’[| * ] ’

(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”.