| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Database down
Well, I think the issue is two-fold.
PMON unable to acquire latch 80002060
modify parameter values
possible holder pid = 58 ospid=29937
2001.12.09.15.27.43.000
I'm reviewing the settings in /etc/system. It is my belief that the additional application server pushed Oracle over some threshhold set in /etc/system.
We are not running multi-threaded server, and we now have three application servers.
2. The issue with the patch has to do with my inability to restart the damn server due to an 'ORA-27123: unable to attach to shared memory segment'. I've asked our UNIX admin to verify we have the following patch:
PATCH 105181-07
We are running 8.0.6 on Solaris 2.6. There are some issues
with the sgadef.dbf file upon shutdown. This is only supposed to
occur on a shutdown abort, but I've seen it occur on a shutdown
immediate. I do not know if this patch specifically addresses the
lingering sgadef.dbf file.
Jeff
>>> ed_at_mb.ru 12/11/01 12:10AM >>>
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
>
-- 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). -- 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).Received on Tue Dec 11 2001 - 14:08:22 CST
 |
 |