Re: Contradictory messages in svrmgr

I have experienced this problem many times. It's cause and it's solution are very simple (fortunately).

On solaris(unix), Oracle grabs both shared memory and semaphores when it starts up. When it shuts down under ideal circumstances it releases these OS resources. When it shuts down under less than ideal circumstances it does not(sometimes).

The fix is to manually release these OS resources, then start the instance. First, shutdown abort the instance to make sure it is truely as down as it can get.

Then execute the command(from unix) ipcs -a

This will show you what the id is of the semaphores and shared memory segments in use. Look for the ones owned by Oracle and write down the number associated with them.

Next run ipcrm -m with the number associated with the shared memory segment as the argument to release it.(ipcrm -m 12345) Next run ipcrm -s with the number associated with the semaphores as the argument to release it.(ipcrm -s 54321)

Then start the database.

After doing this the database *will* start normally.

--
Dave A


"Friedhelm Raab" <raab_at_bootes.imib.rwth-aachen.de> wrote in message
news:39E448D5.182B69FB_at_bootes.imib.rwth-aachen.de...


> Hello,

>

> after a crash of a database (Oracle 8.1.5, Solaris 2.6) I tried to

> restart the database via svrmgrl.

> With 'startup open' I got: 'ORA-01081: cannot start already-running

> ORACLE - shut it down first',

> with 'shutdown immediate': 'ORA-01034: ORACLE not available'.

> How can I deal with this problem without rebooting the server ?

>

> Thanks

>   Friedhelm

>

> --------------------------------------------------------------------------

 ----


> Friedhelm Raab EMail: raab_at_bootes.imib.rwth-aachen.de

> --------------------------------------------------------------------------

----