节点一启动报错
SQL> startup
ORA-00119: invalid specification for system parameter REMOTE_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENERS_ORA10G'
tnsping LISTENERS_ORA10G 也不能解析
认真对比两个节点之间的listener.ora tnsnames.ora 发现节点一的tnsnames.ora
少了一个配置
LISTENERS_ORA10G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rp4440a_vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rp4440b_vip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ora10g)
)
)
添加上以后再次startup成功
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16719800/viewspace-712193/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16719800/viewspace-712193/