Database wont start
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Database wont start

  1. #1
    Join Date
    Jan 2002
    Posts
    38

    Database wont start

    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

  2. #2
    Join Date
    Nov 2000
    Posts
    224
    Do you see any message related to this in alert.log file?

  3. #3
    Join Date
    Jan 2002
    Posts
    38
    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

  4. #4
    Join Date
    May 2002
    Posts
    2,645

    Re: Database wont start

    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?

  5. #5
    Join Date
    May 2002
    Location
    England
    Posts
    78
    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

  6. #6
    Join Date
    May 2002
    Posts
    2,645

    Re: Database wont start

    Originally posted by theworm
    If forces you to goto svrmgrl and type startup.
    It started up, the init.ora file is fine.

  7. #7
    Join Date
    Jan 2002
    Posts
    38
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width