首页 > Linux操作系统 > Linux操作系统 > ORA-12545 问题

ORA-12545 问题

原创 Linux操作系统 作者:gaopengtttt 时间:2013-10-15 15:39:26 0 删除 编辑

Client Connection to RAC Intermittently Fails-ORA-12545 TNS: Host or Object Does not Exist (Doc ID 364855.1)

Log in with privileges to the instance and issue the following commands so that LOCAL_LISTENER is set correctly:


alter system set LOCAL_LISTENER="(address=(protocol=tcp)(port=1521)(host=)) scope=both sid='INSTANCE_NAME1';

Do the same for the 2nd instance where host is set to the and the sid is set to the 2nd instance name.

alter system set LOCAL_LISTENER="(address=(protocol=tcp)(port=1521)(host=)) scope=both sid='INSTANCE_NAME2'; 

Now the correct address using the VIP hostname will be registered against the listeners in the cluster.

The client should be able to resolve all forms of the VIP host via their /etc/hosts file.  i.e. short name and fully qualified.

Clients Failing to Connect Due to Intermittent ORA-12545 in RAC Environment (Doc ID 291175.1)

Edit the /etc/hosts file or winnt/system32/drivers/etc/hosts file.  Add a mapping for whatever hostname is not being resolved.  For example:   myhost

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

下一篇: 外键加索引问题
请登录后发表评论 登录
wxh gp_22389860 <<深入理解MySQL主从原理专栏>> 发布 可加WX了解


  • 博文量
  • 访问量