RE: RE: Unix Oracle Processes

Hi,

Thanks. I think that is exactly what happened. Someone has tried to shutdown and startup the database logged in as the root user. It screwed things up a bit ... but now they seem fine.

Cheers,

Sujatha

-----Original Message-----
Sent: Tuesday, 27 November 2001 9:25 AM
To: Multiple recipients of list ORACLE-L

Sujatha:

I've seen this happen before under these circumstances: 1) The DB is up and running, started by the Oracle owner. 2) A UNIX user who is a member of the DBA group starts svrmgrl

   and tries to start the same instance. Now suddenly there are two    sets of processes for that instance. One is the real database    instance and the other is in some unknown wierd state, and the DBA is    confused.

This is all the more reason to keep the members of the DBA group to a minimum.

HTH,
Mike

---
===========================================================================
Michael P. Vergara
Oracle DBA
Guidant Corporation
(909) 914-2304


-----Original Message-----
Sent: Monday, November 26, 2001 1:40 PM
To: Multiple recipients of list ORACLE-L


Hi,

Thanks for your help. I solved the problem. For some insane and unknown
reason all the oracle processes (ie smon, pmon lgwr etc) were stuck!

I restarted the server and it worked fine. I don't know why they were stuck!


-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 

Author: Vergara, Michael (TEM)
  INET: mvergara_at_guidant.com

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: Sujatha Madan
  INET: Sujatha.Madan_at_cmc.cwo.net.au

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).