ORACLE_HOME + ORACLE_SID together uniquely identify an instance. Anjo.
"Vergara, Michael (TEM)" wrote: > I've seen this happen in the following circumstance: > > Log in as oracle owner. svrmgrl -> startup -> exit. > Log out. The instance is running. > > Now log in as another user who is a member of the dba > group. svrmgrl -> startup -> exit. Do a ps -ef. > You will see two instances running. > > Been there. Oops'ed this! > > Mike > > -----Original Message----- > Sent: Tuesday, April 30, 2002 2:48 PM > To: Multiple recipients of list ORACLE-L > > Hello Folks, > > I was teaching DBA stuff to a newbie, and I had him play with an Oracle > 7.3.4 instance on an old HP box. I was teaching him about oradebug, ipcs > and how to associate shared memory segments with an Oracle Instance. After > some time, he came back and said there were 2 Oracle instances with the > same name running. > > I did a ps -ef|grep pmon and was indeed surprised to find two process with > the same SID running. An ipcs showed two Oracle Id's. I connected to the > instance, and shut it down. It now showed only one pmon process, which I > was not able to connect to, and had to kill all the background process. He > does not remember the exact sequence of steps that he did. I tried to > retrace the steps from whatever he said, but to no avail. I brought up the > instance, did an ipcsrm, and tried to bring up another instance, all to > nothing. 7.3.4 is the only Oracle version installed on this box. Any > thoughts on this? I am curious to know. > > Raj > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > 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: Vergara, Michael (TEM) > 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: Anjo Kolk 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).
