DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01033 Oracle initialization or shutdown in progress

  1. #1
    Join Date
    Mar 2003
    Posts
    1

    Question ORA-01033 Oracle initialization or shutdown in progress

    I installed Oracle 8i in Windows 2000 advanced server box for testing purpose. Yesterday I restarted the server and got this error message: ORA-01033 Oracle initialization or shutdown in progress. I can not start DBA studio and SQLplus. The error message is the following:

    SVRMGR> connect sys as sysdba
    Password:
    Connected.
    SVRMGR> shutdown
    ORA-01109: database not open
    Database dismounted.
    ORACLE instance shut down.
    SVRMGR> startup
    ORACLE instance started.
    Total System Global Area 98674716 bytes
    Fixed Size 75804 bytes
    Variable Size 77733888 bytes
    Database Buffers 20787200 bytes
    Redo Buffers 77824 bytes
    Database mounted.
    ORA-16014: log 1 sequence# 4216 not archived, no available destinations
    ORA-00312: online log 1 thread 1: 'E:\ORACLE\ORADATA\TESTDB2\REDO01.LOG'

    Could anyone tell me how to fix this problem? Many thanks.

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    1) Check is parameter LOG_ARCHIVE_DEST in init.ora correct
    if it correct then
    2) check avaible disk space in LOG_ARCHIVE_DEST directory. It has to be more then redo log file.

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