更改数据库端口号
srvctl config listener
srvctl modify listener -l LISTENER -p "TCP:11521"
grid用户
oracle用户
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.123)(PORT=11521))' scope=both sid='test1';
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.122)(PORT=11521))' scope=both sid='test2';
alter system set remote_listener='scanip:11521' scope=both;
srvctl config scan_listener
srvctl config listener
srvctl modify listener -l LISTENER -p "TCP:11521"
grid用户
修改下列文件endpoints_listener.ora
vi /u01/app/11.2.0/grid/network/admin/endpoints_listener.ora
LISTENER_ORA5=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ora5-vip)(PORT=11521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.121)(PORT=11521)(IP=FIRST)))) # line added by Agent
更改初始化参数
sqlplus / as sysasm
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.123)(PORT=11521))' sid='+ASM1';
修改下列文件endpoints_listener.ora
vi /u01/app/11.2.0/grid/network/admin/endpoints_listener.ora
LISTENER_ORA5=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ora5-vip)(PORT=11521))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.121)(PORT=11521)(IP=FIRST)))) # line added by Agent
更改初始化参数
sqlplus / as sysasm
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.123)(PORT=11521))' sid='+ASM1';
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.122)(PORT=11521))' sid='+ASM2';oracle用户
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.123)(PORT=11521))' scope=both sid='test1';
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.162.122)(PORT=11521))' scope=both sid='test2';
alter system set remote_listener='scanip:11521' scope=both;
srvctl config scan_listener
srvctl config listener
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29802484/viewspace-2138747/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
