ORA-12545 error during Oracle 11gR2 RAC connection

Just installed Oracle 11gR2 RAC cluster

Three nodes

After creating a database, everything is normal.

Then I installed an oracle client, and the ORA-12545 appeared during the link.

Then the baidu is simple. Some people say it is the 11gR1 bug. Modify the instance listening configuration.

Someone else said that the 11gR1 bug requires alter system register; (register the listener)

I can see that my instance and listener are correct.

The entire error analysis process is recorded below

First view ~ /. Bash_profile

Export ORACLE_SID = + ASM1
# Export ORACLE_HOME =/oracle/11.2.0/dbhome
Export GRID_HOME =/grid/11.2.0/crs
Export ORACLE_HOME =/grid/11.2.0/crs

These three parameters are shown above, and the actual installation host of my oracle is in/oracle/11.2.0/dbhome.

The SID of the database I created is aaa.

So I need to manually set the two variables as follows (on rac1, a node ):

Export ORACLE_SID = aaa
Export ORACLE_HOME =/oracle/11.2.0/dbhome

Then you can connect to sqlp/as sysdba.

SQL> show parameter db_name;

NAME TYPE VALUE
-----------------------------------------------------------------------------
Db_name string aaa
SQL> show parameter instance_name; // Instance name

NAME TYPE VALUE
-----------------------------------------------------------------------------
Instance_name string aaa1
SQL> show parameter listener; // view the listener

NAME TYPE VALUE
-----------------------------------------------------------------------------
Listener_networks string
Local_listener string (DESCRIPTION = (ADDRESS_LIST = (AD
DRESS = (PROTOCOL = TCP) (HOST = vip1
) (PORT = 1521) // check that vip1: 1521 is listened to here.
Remote_listener string cluster.rac.com: 1521 // remote listens to scan 1521

 

The local_listener listens on port vip1: 1521, And the vip resolution of my node is written in hosts. The client cannot find vipn resolution, causing the following error to occur for each link:

[Oracle @ SEM admin] $ sqlplus system/aaa @ aaa

SQL * Plus: Release 11.2.0.1.0 Production on Thursday August 8 21:01:11 2013

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

ERROR:
ORA-12545: the connection failed because the target host or object does not exist

Recommended reading:

 

Key Points of migrating 11G data to 10g platform through expdp & impdp

 

Oracle Data Pump examples and some precautions (expdp/impdp)

 

Oracle datapump expdp/impdp hang

 

Expdp/impdp for Oracle 10g to 11g data migration