ORA-00119: invalid specification for system parameter REMOTE_LISTENER ORA-00132:

节点一启动报错

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/