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]

Re: Newbie question on ORA-12560

I wrote in message news:<57666134. 0311011011.2272 cbe2@posting.go ogle.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.c om/groups?q=ORA-12560+debugging &hl=en&lr=&ie=U TF-8&safe=on&selm= vGCV9.318%24I9. 21410908%40news svr15.news.prod igy.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.