Loading

修改监听端口号

一、修改DB侦听端口

1、修改前检查

grid@gsrzrac01:/home/grid>srvctl config listener
Name: LISTENER
Type: Database Listener
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1521
Listener is enabled.
Listener is individually enabled on nodes: 
Listener is individually disabled on nodes: 

2、仅在一个主机上执行

grid@gsrzrac01:/home/grid> srvctl modify listener -l LISTENER -p "TCP:1685"

3、仅在一个主机上执行

grid@gsrzrac01:/home/grid>srvctl modify scan_listener -p 1685

4、修改LOCAL_LISTENER仅仅在一个主机上执行

alter system set local_listener = '(ADDRESS = (PROTOCOL = TCP)(HOST = 135.148.42.11)(PORT = 1685))' scope=both sid='rac1'; 
alter system set local_listener = '(ADDRESS = (PROTOCOL = TCP)(HOST = 135.148.42.12)(PORT = 1685))' scope=both sid='rac2'; 
alter system set local_listener = '(ADDRESS = (PROTOCOL = TCP)(HOST = 135.148.42.13)(PORT = 1685))' scope=both sid='rac3'; 

4、修改remote_listener

alter system set remote_listener='gsrzrac-scan:1685' scope=both; 

5、在第一个节点关闭本地侦听

[grid@hosta ~]$ srvctl stop listener -l LISTENER -n 主机名

修改第一个节点的$GRID_HOME/network/admin/listener.ora文件,将1521改为1528

6、启动第一个节点本地监听

[grid@hosta admin]$ srvctl start listener -l LISTENER -n 主机名
lsnrctl stop

7、在第二个节点上进行相同操作

[grid@hostb ~]$ srvctl stop listener -l LISTENER -n 主机名

修改listener.ora文件,之后启动侦听

[grid@hostb admin]$ srvctl start listener -l LISTENER -n 主机名

8、确认修改效果

[grid@hostb admin]$ srvctl config listener 
Name: LISTENER 
Network: 1, Owner: grid 
Home: <CRS home> 
End points: TCP:1528

二、修改ASM侦听端口号

1、修改ASM LOCAL_LISTENER仅仅在一个主机上执行

sqlplus / as sysasm;
alter system set local_listener = '(ADDRESS = (PROTOCOL = TCP)(HOST = 135.148.42.11)(PORT = 1685))' scope=both sid='asm1'; 
alter system set local_listener = '(ADDRESS = (PROTOCOL = TCP)(HOST = 135.148.42.12)(PORT = 1685))' scope=both sid='asm2'; 
alter system set local_listener = '(ADDRESS = (PROTOCOL = TCP)(HOST = 135.148.42.13)(PORT = 1685))' scope=both sid='asm3';
posted @ 2019-12-31 16:47  开花的马铃薯  阅读(799)  评论(0编辑  收藏  举报