如果使用scan-ip远程连接出现“ORA-12545: 因目标主机或对象不存在, 连接失败”,则执行如下:
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.136)(PORT=1521))' scope=both sid=orcl1;
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.137)(PORT=1521))' scope=both sid=orcl2;
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.136)(PORT=1521))' scope=both sid=orcl1;
alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.137)(PORT=1521))' scope=both sid=orcl2;
或者su - grid
lsnrctl status LISTENER_SCAN1
lsnrctl start LISTENER_SCAN1
如果没有grid用户,则切换到oracle用户,然后
export ORACLE_HOME=/u01/app/11.2.0/grid
export ORACLE_SID=+ASM1
lsnrctl status LISTENER_SCAN1
lsnrctl start LISTENER_SCAN1
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10995764/viewspace-2137716/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10995764/viewspace-2137716/