Re: How to trace this error?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 19 Dec 2002 06:40:18 +1100
Message-ID: <o14M9.5901$jM5.16645@newsfeeds.bigpond.com>

Nothing to do with your specific question, but that error is usually par for the course when you're connected to an instance in one session, and the DBA does a shutdown abort of that instance somewhere else (or if the instance otherwise dies, blows up, starts pining for the fjords etc).

Your session throws a wobbly next time you try and do anything, because it expects to still be connected, but discovers to its horror that it's had the carpet pulled out from underneath its feet.

If, having received that error, you can immediate issue a new 'connect user/password', then find out if the instance died (or was killed). Only if that's not the issue would I start worrying about why your client suddenly loses touch with the instance (which is essentially the problem here).

Regards
HJR "Terry Mu" <terry_mu_at_yahoo.com> wrote in message news:804M9.1002$yW.392_at_news04.bloor.is.net.cable.rogers.com...
> I got this error in my session frequently,
>
> ORA-12571: TNS:packet writer failur
>
> oerr tells me to enable trace. How to do that and what to trace?
>
> Thanks
>
>
Received on Wed Dec 18 2002 - 13:40:18 CST