RE: db won't mount

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Wed, 27 Jun 2001 14:42:52 -0700
Message-ID: <F001.0033AF31.20010627145005@fatcity.com>

What are the last few lines in the alert log? ( as you try to open it)
is there a process that is taking alot of CPU?
what are the mtime, ctime, and atime of the SGA shmmem segs? Appropriate?

-----Original Message-----
Sent: Wednesday, June 27, 2001 5:54 PM
To: Multiple recipients of list ORACLE-L

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

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

Author: Mohan, Ross
INET: MohanR_at_STARS-SMI.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------