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 > > >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
