更改数据库端口号

最新推荐文章于 2023-12-26 07:43:49 发布

crcz16618

最新推荐文章于 2023-12-26 07:43:49 发布

阅读量1.5k

点赞数

文章标签：数据库网络 java

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/