Re: sqlplus hanging on exit

Louis,

Yep, old bug. :)

I seem to recall that removing the files is enough; best check on MetaLink though.

Do you have access? I can find it for you tomorrow if you don't. ( gotta get to bed now, the eyelids won't stay up :)

Jared

On Wed, 21 Mar 2001, Louis Avrami wrote:

> Jared,
>
> Thanks for the reply.
>
> I'm embarrassed to say that the cause of the problem was Oracle Trace. The
> solution was to set EPC_DISABLE=TRUE in the environment and listener.ora, and
> stop and restart the database.
>
> I remember doing this a couple of years ago, when Oracle Trace was first
> enabled by default.
>
> Apparently one of my predecessors didn't set EPC_DISABLED anywhere, but simply
> removed the .dat log files under $ORACLE_HOME/otrace/admin. Does this mean
> that the trace overhead is still part of the Oracle processes, but just can't
> find the log files to write out to?
>
> Lou Avrami
>
>
> jkstill_at_cybcon.com wrote:
>
> > You may want to check v$session_wait while the session
> > is exiting and see if it's waiting on a resource in the
> > the database.
> >
> > If that doesn't reveal anything, you may want to try
> > truss on the server process and see what is going on there.
> > ( assuming you aren't using MTS )
> >
> > Jared
> >
> > On Fri, 16 Mar 2001, Louis Avrami wrote:
> >
> > > Hello all,
> > >
> > > I recently had to migrate a legacy database to a Sun 420 running Solaris
> > > 2.8, latest recommended patches. I installed RDBMS 7.3.4.5, created a
> > > database and imported the data successfully.
> > >
> > > I have actually had to do this on several different servers (we're
> > > finally scheduled to upgrade to RDBMS 8.1.7 next month). All have gone
> > > well with the exception of one server.
> > >
> > > The symptoms of the problem seem to occur when trying to exit a
> > > connection to this particular database. The exiting process seems to
> > > hang for an unusually long period of time. For example, from the
> > > command line, if I use sqlplus to connect to the database, the
> > > connection starts up almost instananeously. SQL statements execute
> > > quickly, with no apparent problems. However, when I try to exit, the
> > > sqlplus session seems to just hang:
> > ...
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).