ORA-01033 shutdown in progress
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-01033 shutdown in progress

  1. #1
    Join Date
    Feb 2001
    Posts
    23
    me again

    anybody tell why i get this error message
    >ORACLE INITIALIZATION/SHUTDOWN IN PROGRESS<
    HOW CAN I FIX THIS.....HELP PLEASE

    THANKS

  2. #2
    Join Date
    Oct 2000
    Posts
    449
    probably you are trying to logon to sql before the db is not completely shutdown.. it could still have the SGA hanging..
    if db is cleanly shutdown , you will get ORACLE NOT AVAILABLE.. So, log inot svrmgr and shutdown the db cleanly.. You should see "Instance shutdown".. If immediate or normal doesnot work use "Abort"..

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Always check your alert logs at $ORACLE_BASE/admin/sid/bdump/alert_sid.log for the details.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Jun 2000
    Location
    Toronto, ON, Canada
    Posts
    50
    You probably issued 'shutdown normal' and still have open connections to the db. In this case the database cannot be shutted down until you don't close all connections. Also, no user is able to connect to the database, because the shutdown process started, so that's why you get the message. Connect as internal and check v$session view to see which are the connections hanging. Then you can kill them and the database will shut down

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