• 对11gR2 rac修改默认的监听端口
  • 一、修改SCAN listener port
    • 1.修改SCAN listener port
    • 2.重启SCAN listener生效新端口
    • 3.确认更改
  • 二、修改Listener Ports
    • 1.修改端口
    • 2.手工修改LOCAL_LISTENER
    • 3.重新启动监听程序
    • 4.检查监听配置
  • 参考

对11gR2 rac修改默认的监听端口

对11gR2 rac修改默认的监听端口分为两步：

1. 修改scan listener的端口
2. 修改本地listener的端口

一、修改SCAN listener port

1.修改SCAN listener port

[grid@tyqxdb1 ~]$ $GRID_HOME/bin/srvctl modify scan_listener -p 11521 

[oracle@tyqxdb1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 22 09:30:46 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 1g Enterprise Edition Release 11.2.0.4.0 - 4bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options

SQL> show parameter listener
NAME TYPE VALUE
listener_networks                    string
local_listener                       string       (ADDRESS=(PROTOCOL=TCP)(HOST= 10.238.205.192)(PORT=1521))
remote_listener                      string      tyqxdb-scan:1521

SQL>  alter system set remote_listener='tyqxdb-scan:11521' scope=both;
System altered.

SQL> show parameter listener
NAME TYPE VALUE
listener_networks                    string
local_listener                       string       (ADDRESS=(PROTOCOL=TCP)(HOST= 10.238.205.192)(PORT=1521))
remote_listener                      string      tyqxdb-scan:11521
SQL>

2.重启SCAN listener生效新端口

[grid@tyqxdb1 ~]$ $GRID_HOME/bin/srvctl stop scan_listener
[grid@tyqxdb1 ~]$ $GRID_HOME/bin/srvctl start scan_listener

3.确认更改

[grid@tyqxdb1 ~]$ $GRID_HOME/bin/srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:11521

二、修改Listener Ports

1.修改端口

获取监听信息

[grid@tyqxdb1 ~]$ srvctl config listener
Name: LISTENER Network: 1, Owner: grid Home: <CRS home>
End points: TCP:1521

修改端口

[grid@tyqxdb1 ~]$ srvctl modify listener -l LISTENER -p "TCP:11521"

2.手工修改LOCAL_LISTENER

[oracle@tyqxdb1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Nov 22 14:11:00 2018 Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.238.205.192)(PORT=11521))))' scope=both sid='tyqxdb1';

System altered.

SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.238.205.194)(PORT=11521))))' scope=both sid='tyqxdb2';

System altered.

SQL> show parameter listener

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
                                                 DRESS=(PROTOCOL=TCP)(HOST=10.238.205.192)(PORT=11521))))
remote_listener string tyqxdb-scan:11521

在节点2上做同样的操作，需要注意的是节点2的local_listene要配置节点的VIP

3.重新启动监听程序

节点1:
[grid@tyqxdb1 admin]$ srvctl stop listener
[grid@tyqxdb1 admin]$ srvctl start listener

节点2:
[grid@tyqxdb1 admin]$ srvctl stop listener
[grid@tyqxdb1 admin]$ srvctl start listener

4.检查监听配置

节点1:
[oracle@tyqxdb1 ~]$ srvctl config Listener
Name: LISTENER Network: 1, Owner: grid Home: <CRS home>
End points: TCP:11521

节点2:
[oracle@tyqxdb2 ~]$ srvctl config Listener
Name: LISTENER Network: 2, Owner: grid Home: <CRS home>
End points: TCP:11521

参考

• How to Modify SCAN Setting or SCAN Listener Port after Installation (文档 ID 972500.1)
• Changing Listener Ports On RAC/EXADATA (文档 ID 1473035.1)