This discussion is archived
1 Reply Latest reply: Apr 23, 2010 12:47 AM by 19426 RSS

sqlplus / as sysdba do not work anymore after upgrade to 11R2

727753 Newbie
Currently Being Moderated
Hi,

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

ERROR:
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?

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points