Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to trace this error?

Re: How to trace this error?

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 19 Dec 2002 07:21:30 +1100
Message-ID: <0E4M9.5907$jM5.17033@newsfeeds.bigpond.com>


What's your sqlnet.ora look like?

HJR "Terry Mu" <terry_mu_at_yahoo.com> wrote in message news:vy4M9.6147$opk.5684_at_news02.bloor.is.net.cable.rogers.com...
> 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:21:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US