RE: Database down

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Mon, 10 Dec 2001 13:49:05 -0800
Message-ID: <F001.003D94F9.20011210133521@fatcity.com>

I don't suppose you've run ps -ef | grep 29937 yet, just out of curiousity, have you?

-----Original Message-----

Just to follow up. I have the database backup. I am afraid however, that the problem is still floating around.

Briefly, here is what occured:

I restarted Oracle because our application was unable to connect. I could connect through svrmgrl, but a 'select sysdate from dual' just hung. So I brought the database down, and recieved the memory segment error.

So we were having problems while the database was up. Here is a trace file dump that may be linked to the problem:

PMON unable to acquire latch 80002060 modify parameter values possible holder pid = 58 ospid=29937

2001.12.09.15.27.43.000

We added a third application server last week. Could that somehow be the source of these problems? This application has been running problem free for over 100 days.

Thanks for your input

Jeff

--

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

Author: Mohan, Ross
INET: MohanR_at_STARS-SMI.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). Received on Mon Dec 10 2001 - 15:49:05 CST