以下更改监听默认端口只针对11gR2 grid rac环境
1: srvctl config listener
如要改成1529
2:srvctl modify listener -l LISTENER -p "TCP:<new-listener-port>"
srvctl modify listener -l LISTENER -p "TCP:1529"
3:确认是否修改成功
srvctl config listener
4:修改数据库和asm实例 local_listener参数
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<Host-name>)(PORT=<new-port-number>))))' scope=both sid='[<your-chosen-instance> | * ] '
--注意asm实例也要修改,否则有可能监听不到asm实例
1: srvctl config listener
如要改成1529
2:srvctl modify listener -l LISTENER -p "TCP:<new-listener-port>"
srvctl modify listener -l LISTENER -p "TCP:1529"
3:确认是否修改成功
srvctl config listener
4:修改数据库和asm实例 local_listener参数
alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<Host-name>)(PORT=<new-port-number>))))' scope=both sid='[<your-chosen-instance> | * ] '
--注意asm实例也要修改,否则有可能监听不到asm实例
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-1792351/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7199859/viewspace-1792351/