Re: Database down

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

>>> ed_at_mb.ru 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: 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).