rac集群修改listener 监听端口

1.监听文件备份(两节点都做)

节点一：

su - grid

cd $ORACLE_HOME/network/admin

cp listener.ora listener_20181214_1.bak

节点二：

su - grid

cd $ORACLE_HOME/network/admin

cp listener.ora listener_20181214_2.bak

2.查看监听端口

srvctl config listener

srvctl config scan_listener

3.修改集群监听

srvctl modify listener -l listener -p "TCP:11521"

4.修改scan_listener端口

srvctl modify scan_listener -p 11521

5.修改local_listener和remote_listener

su - oracle

export ORACLE_SID=nosql1

sqlplus / as sysdba

create pfile='/tmp/nosql1_pfile_20181214.ora' from spfile;

alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.102.84)(PORT=11521))))' scope=both sid='nosql1';

alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.1.102.85)(PORT=11521))))' scope=both sid='nosql2';

alter system set remote_listener='nosqlnew-scan:11521' scope=both;

6.关闭监听

srvctl stop listener

srvctl stop scan_listener

7.开启监听

srvctl start listener

srvctl start scan_listener

8.确认效果

srvctl config listener

srvctl config scan_listener