Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: A really strange one..
I have seen something similar when the database is started up with the wrong oracle home. For example after an upgrade and someone is using an old script pointing to the old oracle home.. But in that case you just set you env to the old and shut it down... Usually its in nomount I believe..
-----Original Message-----
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>
To: andrew.kerber_at_gmail.com <andrew.kerber_at_gmail.com>
CC: oracle-l <oracle-l_at_freelists.org>
Sent: Wed Sep 26 13:33:47 2007
Subject: Re: A really strange one..
Was it on AIX?
We have seen similar strange things there. I don't remember all the details, but at one point there were no background processes, yet we could still logon using sqlplus! Couldn't do anything, but it said we were connected.
When we tried to startup the database, it also told us that it was already running.
Keith
> 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.'
>
-- http://www.freelists.org/webpage/oracle-l This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you. -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 26 2007 - 13:16:24 CDT