Re: Database down

Jeff,

I had a similar situation last week. I would like to know what patch are talking about and what's your version of Oracle?

Regards,
Ed

> I discovered the trace file after restarting Oracle - so that
> process ID is no longer out there. I've also discovered that there
> is a specific patch for this problem, which appears not to have been
> applied. I will move forward with this, but would like to provide
> management with an explanation as to why we had problems now, after
> so many days of uptime.
>
> Thanks for your help.
>
> Jeff
>
> >>> MohanR_at_STARS-SMI.com 12/10/01 03:35PM >>>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeff Wiegard
> INET: JWIEGARD_at_ngwmail.des.state.mn.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Edward Shevtsov
  INET: ed_at_mb.ru

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