A really strange one..
- From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Sep 2007 10:36:18 -0500
Ok, I just ran into a strange one this morning. US central time that is.
We are moving our clustered databases to new servers, and we put one
database onto the new hardware for initial testing. We restored from a
backup, and got both instances running. Today when I did a
ps -ef | grep pmon
I saw two pmon processes going for the single instance. I have no idea what
could have caused that. So I set my oracle_sid, path, oracle_Home and
shutdown the instance. What do you know, there was still one pmon process
running. I did a kill -9 on that one.
Then I go to start the instance again. And I get this error: ORA 01081
"cannot start already-running ORACLE - shut it down first"
I did a ps -ef | grep oracle, didnt get anything (except my user process of
course).
I finally googled and found one possibility, a locked shared memory segment.
Sure enough
ipcs -a | grep dba
returned a large segment of memory that was still locked. So I ran this
(found on the same site) and released it:
ipcs -a | grep dba | perl -ane 'system "ipcrm -$F[0] $F[1]"'
My question is, has anyone seen this before, or know what causes it?
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
