今天遇到ORA-12545问题一直以为设置了LOCAL_LISTENER参数就没有问题，但是今天能遇的问题是设置了LOCAL_LISTENER没有问题，但是还是报错，这种情况下在客户端HOSTS中把RAC的HOSTS下面的内容复制上去，让他能够解析

ORACLE 官方：

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:

1.1.1.103 myhost.oracle.com myhost

ITPub博客

ORA-12545 问题

最新文章