客户的RAC的一个节点挂了之后,手工重启,所有资源都恢复正常,本地同网络连接正常,但是下面的其它网络客户端连接scanIP报错
ORA-12545: 因目标主机或对象不存在, 连接失败
C:\Users\Administrator>sqlplus system/manager@172.16.80.24/dbserver
SQL*Plus: Release 10.2.0.1.0 - Production on 星期五 8月 14 23:57:53 2020
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12545: 因目标主机或对象不存在, 连接失败
这里的原因是节点的LOCAL_LISTENER参数不知道被谁设置为了空.在RAC中,每个节点的LOCAL_LISTENER参数必须指定本节点的vip,remote_listener必须指向scanIP.
MOS的相关文档如下:
ORA-12545 or ORA-12537 While Connecting to RAC Through SCAN name (Doc ID 970619.1) | To Bottom |
In this Document
APPLIES TO:Oracle Database Configuration Assistant - Version 11.2.0.1 and laterOracle Net Services - Version 11.2.0.4 to 11.2.0.4 [Release 11.2] Information in this document applies to any platform. ***Checked for relevance on 11-Mar-2013*** SYMPTOMSError ORA-12545 or ORA-12537 reported while trying to connect to 11gR2 Real Application Cluster (RAC) database through SCAN name CHANGES
CAUSEClient is able to resolve all Fully Qualified Domain Name (FQDN) SCAN and VIP name but not short ones(without domain name) as its in different domain; even though FQDN names were specified during Grid Infrastructure setup, due to bug 9150053 by default DBCA set database parameter local_listener to short node VIP name while database is created. ping -c 1 <node1>.oracle.com SOLUTIONbug 9150053 will be fixed in 11.2.0.2 and above, though easy workaround is available:
grep <scan> /etc/hosts
grep search /etc/resolv.conf
Network Connection => Property for Public Network => Internet Protocol (TCP/IP) => Advanced => DNS => Append these DNS suffices (in order)
Scalability RAC CommunityTo discuss this topic further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the My Oracle Support Scalability RAC Community. REFERENCESBUG:9150053 - ORA-12545 REPORTED WHILE CONNECTING TO 11.2 SCAN ON CLIENT NOTE:975457.1 - How to Troubleshoot Connectivity Issue with 11gR2 SCAN Name NOTE:364855.1 - Client Connection to RAC Intermittently Fails-ORA-12545 TNS: Host or Object Does not Exist NOTE:553328.1 - Troubleshooting Guide for ORA-12545 / TNS-12545 Connect failed because target host or object does not exist NOTE:291175.1 - Clients Failing to Connect Due to Intermittent ORA-12545 in RAC Environment |
|
Didn't find what you are looking for?Ask in Community...