RE: RE: Unix Oracle Processes

From: Sujatha Madan <Sujatha.Madan_at_cmc.cwo.net.au>
Date: Mon, 26 Nov 2001 14:05:59 -0800
Message-ID: <F001.003CD298.20011126134020@fatcity.com>

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!

Regards,

Sujatha

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

I am not sure if I have understood ur problem but can u please try this

cd $ORACLE_HOME/dbs
ls -alt lk*.ora
if there is any file by the name lk<db_name>.ora where db_name is the database name and NOT SID then try removing this file and starting up the database again.

do this ONLY if this database is NOT

standby or
Oracle parallel sever ( init.ora does NOT have any parallel server parameters!)

--

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

Author: Cyril Thankappan
INET: cyril_thank_at_rediffmail.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
--------------------------------------------------------------------