Database wont start

[theworm]

We several customers with there database not starting. We have it running via services. The services start fine, but the database refuses to start. If forces you to goto svrmgrl and type startup. For some reason after you reboot the server the db won't start. We have looked at the oracle_sid_autostart, that appears to be fine. Also on another site I was told to look at the pfile settings, Thats good also. This is 8.1.7 running on 2000. If you have any suggestions on what I can look at, it will help.
Thanks
again

[Sharma]

Do you see any message related to this in alert.log file?

[theworm]

Here is the last entry from the alert log. There was nothing in the trc files.


PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Tue Nov 19 10:28:42 2002
alter database mount
Tue Nov 19 10:28:49 2002
Successful mount of redo thread 1, with mount id 1391710625.
Tue Nov 19 10:28:49 2002
Database mounted in Exclusive Mode.
Completed: alter database mount
Tue Nov 19 10:28:49 2002
alter database open
Beginning crash recovery of 1 threads
Tue Nov 19 10:28:49 2002
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1813 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\FC\REDO01.LOG
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1814 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\FC\REDO02.LOG
Tue Nov 19 10:28:50 2002
Thread recovery: finish rolling forward thread 1
Thread recovery: 411 data blocks read, 296 data blocks written, 5493 redo blocks read
Crash recovery completed successfully
Tue Nov 19 10:28:50 2002
Thread 1 advanced to log sequence 1815
Thread 1 opened at log sequence 1815
Current log# 3 seq# 1815 mem# 0: D:\ORACLE\ORADATA\FC\REDO03.LOG
Successful open of redo thread 1.
Tue Nov 19 10:28:51 2002
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Nov 19 10:28:52 2002
Completed: alter database open

[stecal]

Originally posted by theworm
Also on another site I was told to look at the pfile settings, Thats good also.

What a waste of time that was! What would the pfile have to do with the database being able to start after reboot? You already know it will start manually, so that implies your init.ora file is fine. Oracle reads the init.ora file, not the OS. What was good about that advice?

Services>Control Panel> OracleServiceSID Startup mode is set to automatic? Did you use oradim with startmode auto? Try dropping the service and recreating it?

What is oracle_sid_autostart?

[jperusco]

Had this problem last week on one of our NT Servers.

First Check for the oradim.log file on the machine. This will give you some idea of what the problem is.

If you get a message saying...

Wed Nov 13 19:24:35 2002
ORA-01078: failure in processing system parameters

It will mean...
1) An init.ora parameters is invalid or
2) it cannot find the init.ora file.

1) Unfortunately on NT it will not tell you what parameter is invalid
so you have to manually go through the init.ora file and make sure all parameters are correct.

2) Check the NT Registry Under your Oracle_Home.

Make sure that the Value for the ORA__PFILE is set to the
exact location of the pfile.

I accidentally mis-spelled the name of my pfile and got this error.

HTH
Cheers
John

[stecal]

Originally posted by theworm
If forces you to goto svrmgrl and type startup.

It started up, the init.ora file is fine.

[theworm]

What is oracle_sid_autostart?

I assume that this is a setting in the reg, with a value of True/False. It is under the software\oracle\home folder of the reg.