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
Hi
I am not sure if I have understood ur problem
but can u please try this
1. cd $ORACLE_HOME/dbs
2. ls -alt lk*.ora
3. 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
a. standby or
b. 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: [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: Sujatha Madan
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).
