RE: User disconnects (ora-0311) and tracing

Barb,

Some things to check:

(a) Swap area becoming full - if this is pointing to /tmp, this could result in erratic problems.
(b) What does 'vmstat' state in terms of memory usage/mem free/swap IO? (c) File table/process table overflows - this is usually seen in retrospect from 'sar' output

Strange things have been known to happen - typically resulting in ORA-0311 - when some OS limit is reached. I would look at the OS and network rather than at Oracle at this point of time. You should then search Metalink for a combination of 8.0.5 and ORA-0311.

10046 is nothing but SQL_TRACE - level 12 will really eat up 'udump' space. You will need to set this in the init.ora and bounce the db.

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Listen to great commercial-free christian music 24x7 at www.klove.com

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: Baker, Barbara [mailto:bakerb_at_rockymountainnews.com]
> Sent: Tuesday, November 13, 2001 11:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: User disconnects (ora-0311) and tracing
>
>
> Sun Solaris 2.6; Oracle 8.0.5
>
> We've been fighting a problem for several days. It's getting
> worse. And
> it's causing MAJOR heartburn. (How bad is it? It's SO bad
> that the vice
> president has been assigned the task of following IS staff
> members around to
> see what we're doing and reporting back on our progress to
> the president.
> It's real embarrassing for him when I go to the bathroom.)
>
> Of the 70 to 80 users we have connected to Oracle, several
> (usually around
> 12 to 15) users are disconnected from the database all at
> once with an "end
> of file on communication channel". Other users remain on.
> Not always the
> same users disconnected. No commonality that we can find.
>
> There's nothing in the alert log, and there are no trace
> files created.
> Oracle knows nothing about the disconnected users -- they
> remain connected
> to the database from the server side 'till pmon comes along
> to clean them
> up.
>
> FINALLY, my question. Oracle has suggested that we turn on
> trace event
> 10046. I confess I've never done this before. In svrmgrl, I
> issue the
> command oradebug setorapid nnnnn, then oradebug event 10046 trace name
> context forever, level 12. This worked 1 time for 1 user.
> It created a
> trace file in the udump directory. However, I'd like to set
> this event on
> for several users. The command executes without error, but
> no add'l trace
> files are created.
>
> What am I missing? Can I only do this for 1 user? Does it
> have something
> to do with running MTS? I tried using the setorapid (pid)
> instead of the
> setospid (spid), but it made no difference.
>
> Any ideas?
> Thanks for any help.
>
> Barb "The chipmunk" dba
>
> P.S. Yes, we do have both our SA's and network folks looking at the
> problem, as well as several consultants. Everyone is clueless.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Baker, Barbara
> INET: bakerb_at_rockymountainnews.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  INET: john.kanagaraj_at_hds.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).