Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to trace this error?
The instance is still alive and nobody shut it down. I'm running a test
application in the instance. I guess that's the problem. Strange thing is
that it seems ok if I keep working on it, but after an idle time, whatever I
will do it tells the error and I have to reconnect. So I have to trace it.
Thanks.
"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:o14M9.5901$jM5.16645_at_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 - 14:05:47 CST