Hi vipin_shar, thanks for writing this:I notice that you got this error when trying to connect to a local db. I>
> 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.
> Posted via [url]http://dbforums.com[/url]
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]