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 >>> [EMAIL PROTECTED] 12/10/01 02:27PM >>> Hi Jeff, 1. the previous killed instance that still holds a shared memory segment ? 2. unappropriatedly large parameters of shared_pool and/or db_block_buffers ? Regards, Ed > ORA-27123: unable to attach to shared memory segment > SVR4 Error: 12: Not enough space > > Any ideas? -- 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). -- 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).