Re: Prod problem, please help!!!

If your database is in archivelog mode,is your archive_log_dest full? This will stop the database dead until you remedy the situation.

Just my $0.02,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, April 30, 2002 3:21 PM

> I have opened a TAR with Oracle and am waiting a resolution. In the
meantime,
> I am wondering if anybody else has any ideas while I wait.
>
> Specifics:
> IBM AIX 4.3
> Rdms 8.1.7.3
> Database ~75g
> OLTP database with approximately 500 dedicated connections and 500
shared connections with Oracle's MTS.
>
> Problem:
> The database hangs, and no user is able to connect to the instance, except
locally through srvmgrl. Even within svrmgrl, we are unable to select anything from
> the
> database without the query hanging. However, we can abort the instance
(shutdown abort) and start it up again just fine. This has happened on 4-22, 4-29 &
> 4-30 in the
> early afternoon. Usually, this is also our peak busy rate for the week.
We are executing MTS for 4 applications, all other applications connect through
> dedicated server.
> The alert log contains a message unable to start a shared server process.
This week it was #41 and last week it was #25. Normally, we do not exceed 5 shared
> servers. Another thing I noticed is that there is no time allocated to
any of the newly created shared servers. It is as if, it can not process any work
> through existing shared
> servers and decides to allocate another one, until finally it freezes. I
am not sure if this is a MTS problem because I would suspect that I should be able
> to establish
> a dedicated server connection. And I can not. I think that this is just
a symptom of the underlying problem. It would appear to me that we are running out
> of a resource,
> however our sysadms do not see any resource problems. Does anybody have
any ideas how to debug this? Thanks
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tracy Rahmlow
> INET: tracy.rahmlow_at_aexp.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: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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).