| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: db won't mount
Well, I got the answer. It's amazing what changing a couple of words in a Metalink search will do. (by the way has anyone noticed Metalink hasn't been down for a while. Maybe they changed to NT). It was the uptime > 248 days problem. (truss ttimes time true showed negative numbers. See Note:130423.1).
Thanks.
Henry
-----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).
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). Received on Wed Jun 27 2001 - 17:16:50 CDT
 |
 |