Re: db won't mount

Please check for space ,specially where your log files are. Most possible file system containing your alert log has no space left... Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Wed, 27 Jun 2001 13:54:07 -0800

I've got a cute one here. I saw something like this years ago, but I can't remember what I did. The database is running Oracle 8.0.6 on Solaris 2.6. I was just brought into this problem, so I don't know too much about the database. It is shutdown nightly for a cold backup, and by the looks of things it never started up again after yesterday's shutdown. After that, numerous attempts at shutdown/startup appear in the alert.log and rdbms/audit. These are the facts as I know them:

I did a shutdown abort succsessfully.
Startup nomount worked.
Alter database mount sits forever. (right now it has been sitting for 3 hours. Looking at the alert logs, it sat for about 12 hours between last nights attempt to startup and the first shutdown run today). The whole database appears to be 600M (unless some files are hidden in funny spots). No errors in the alert.log, no trace files, no core dumps, nothing in cdump, udump, bdump, $ORACLE_HOME/rdbms/log
CPU time for the background processes is 0. It is 1 second for the svrmgrl process. No change over the last 3 hours. fuser shows the control files opened by ckpt and svrmgrl process, but the data and log files are not opened.
The alert log shows the shutdown prior to the problem being a shutdown immediate so no recovery or rollbacks should have been necessary.

Has anyone seen this before? Thanks.

Henry

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Henry Poras
   INET: Henry.Poras_at_ctp.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).

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mohammad Rafiq
  INET: rafiq9857_at_hotmail.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).