更改資料庫埠號

zhangsharp20發表於2017-05-09
資料庫
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章