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: Terry Mu <terry_mu_at_yahoo.com>
Date: Wed, 18 Dec 2002 20:36:18 GMT
Message-ID: <6%4M9.6712$F2h1.2265@news01.bloor.is.net.cable.rogers.com>


NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) the application run on the same machine with Oracle server.

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:0E4M9.5907$jM5.17033_at_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:36:18 CST

Original text of this message

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