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博客 ” ,链接:http://blog.itpub.net/29802484/viewspace-2138747/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29802484/viewspace-2138747/