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

Hybrid View

  1. #1
    Join Date
    Mar 2003

    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
    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
    NJ, USA
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.