同事在做new build, 参数没有修改完整,安装结束之后,发现scan port还是默认的1521。
检查和修改过程如下:
SQL> show parameter listener
可以看到
remote_listener string sssss-scan:1521
在grid下:
srvctl status listener
srvctl config listener
srvctl status scan_listener
srvctl config scan_listener
lsnrctl status LISTENER_SCAN1
lsnrctl status LISTENER_SCAN2
lsnrctl status LISTENER_SCAN3
修改:
srvctl modify scan_listener -p TCP:1111
srvctl stop listener
srvctl start listener
srvctl stop scan_listener
srvctl start scan_listener
修改数据库参数:
SQL> alter system set remote_listener='ssss-scan:1111' sid='*';
srvctl stop database -d ssss -o immediate
srvctl start database -d ssss
结束。
参考URL:
http://asanga-pradeep.blogspot.com/2013/01/changing-listener-and-scan-listener.html
http://balakumarnair.wordpress.com/2011/02/05/modify-add-scan-ip-listeners/
http://www.stojanveselinovski.com/blog/2014/05/12/modify-scan-listener-and-add-more-ports/