i just upgrade my 2 nodes cluster from 10.2.0.4 to 11R2 under window 2003.
My cluster and my database startup without problem.
The only problem, i'm not able to open a sqlplus with / as sysdba.
If i connect with a listener (alias in the tnsname) i can access to my database.
In local mode it is not possible (It's like i can not use my sqlplus in local mode anymore).
I have this message
ORA-12557: TNS:protocol adapter not loadable
in my file sqlnet.ora i still have the option AUTHENTICATION_SERVICES= (NTS)
and my sqlplus associated to new directory (11gR2). If i do a tnsping, i can see the new directory is use.
I think i'm to deep in the problem and i can not see the solution, i need someone else vision
What can be my problem?
After upgrade you have now (at least temporarily) 2 ORACLE_HOMEs. ORA-12557 occurs when version of executable and default ORACLE_HOME aren't the same, i.e. you invoke 10g sqlplus in 11g ORACLE_HOME or vice versa.
Make sure you use 11g sqlplus and 11g ORACLE_HOME (OUI ==> installed products ==> environment, move %ORACLE_HOME% to the top).