Newbie question on ORA-12560

[Swapnajit Mittra]

Hello,

Sorry if this is an rudimentary question. I checked the
newsgroup archive but did not get an answer that matched
closely with my situation. I am very new to Oracle9i so
please bear with me.

Yes, I am getting the dreaded ORA-12560 error while trying
to log onto sql*plus in Oracle 9i on Win2k.

ORA-12560: TNS: protocol adapter error.

The problem is that it all works for few days without any
problem. Then all on a sudden apparently for no reason
(no new software loaded etc.) I seem to get this error.

Earlier, I have re-installed the whole thing but I am sure
gurus over here must have some better strategy.

I saw mention of stack tracing (?) etc, I will be happy to
provide the stack trace if somebody can tell me how to do
it.

Thanks,
- M

[Swapnajit Mittra]

I wrote in message news:<57**************************@posting.google. com>...

Hello,

Sorry if this is an rudimentary question. I checked the
newsgroup archive but did not get an answer that matched
closely with my situation. I am very new to Oracle9i so
please bear with me.

Yes, I am getting the dreaded ORA-12560 error while trying
to log onto sql*plus in Oracle 9i on Win2k.

ORA-12560: TNS: protocol adapter error.

OK, I have solved my problem and thought I would let others
know if anybody faces the same problem.

Basically, I followed the steps given in:

<URL: http://groups.google.com/groups?q=ORA-12560+debugging&hl=en&lr=&ie=UTF-8&safe=on&selm=vGCV9.318%24I9.21410908%40newssvr15 .news.prodigy.com&rnum=1>

For some reason, I could not log in as system/manager, but then
the regular login started working (which was all that I wanted).

Thanks to the original poster of the above.
- Swapnajit.