ORACLE11GR2 RAC cannot connect using scan IP (ORA-12545)

ORACLE11GR2 RAC cannot connect to the database using scan IP, error ORA-12545: Connection failed because the target host or object does not exist

Phenomenon:

The Windows Client Sqlplus tool uses scan IP to not connect, and the error is as follows:

C:windowssystem32> Sqlplus SONG/123456@10.10.23.3:11521/ORCL

Sql*plus:release 11.2.0.1.0 Production on Thu May 17 12:35:28 2012

Copyright (c) 1982, Oracle. All rights reserved.
ERROR:
ORA-12545: Connection failed because the target host or object does not exist

1, check the status of the components:

Switch to Grid user, execute command crs_stat-t, view status

2, check the status of the listener:

Switch to Grid user, execute command lsnrctl status, view listener status for single instance

Perform lsnrctl status Listener_scan1 to view scan listening status

If the above is found to be normal, then we will find the answer on the Metalink

Reason:

Metalink Description: Client is able to resolve all fully qualified Domain name (FQDN) SCAN and VIP name but don't short ones (without D Omain 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 PA Rameter Local_listener to short node VIP name while the database is created.

So as long as the database instance parameter local_listener the host to the VIP IP address can be

Switch to Oracle user, execute Sqlplus '/as SYSDBA ' Open database

code is as follows

copy code

#查看本机的local The _listener parameter sql> show parameter local_listener; NAME TYPE VALUE ———————————— ——— – —————————— Local_listener string description= (address_list= (AD dress= (PROTOCOL=TCP) (HOST=RAC3 -vip) (port=1521))) #修改所有节点上的local_listener取值, here my Scanip set in the hosts domain name is rac-cluster, the address is 10.10.23.3,port 11521 sql> alter system Set local_listener= ' (Description= (address_list= (address= (protocol=tcp) (Host=rac-cluster) (PORT=11521))) ' Scope= both; System altered. #手工强制将数据库实例注册到监听 Sql> alter system register; System altered.

then use the Windows Client connection successfully:

C:userswjw>sqlplus SYSTEM/QWEASD@192.168.2.200:1521/ORCL

Sql*plus:release 11.2.0.1.0 Production on Thu May 17 13:14:39 2012

Copyright (c) 1982, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition release 11.2.0.1.0-production
With the partitioning, real application clusters, Automatic Storage Management, OLAP,
Data Mining and real application testing options