Re: ORA-12560: TNS: Protocol Adapter Error

Hi vipin_shar, thanks for writing this:
>
> Hi dbuckingham,
>
> I am also facing the similar problem. I have 2 instances of 9i on same
> server. I am able to connect with one of them and connecting to other
> instance gives me ORA-12560. tnsping is successful in both the cases.
> only connection to sqlplus is giving problem. I saw that your problem
> got resolved, so can you please help me to troubleshoot the problem.
> Kindly let me know the steps you took to solve the issue.
>
> Thanks
> vipin
>
> --
> Posted via http://dbforums.com
>

I notice that you got this error when trying to connect to a local db. I ran into the same problem once, trying to login to sqlplus to start my database ... and scratched my head, trying to figure out what was wrong with the Oracle network (since that's what the error message seems to indicate). Checked all the network files and they seemed okay. Ran thru all the lsnrctl and tnsping checks.

Finally on a whim, I displayed the current environment variables. Well, ORACLE_HOME wasn't set ... so I set it ... and the error went away. Who would have thought that not having oracle_home set would cause a network protocol adapter error? The bequeath protocol, eh?

-- 
[:%s/Karsten Farrell/Oracle DBA/g]