Newbie question on ORA-12560

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 Received on Sat Nov 01 2003 - 19:11:56 CET