Ask the Expert

ORA-01089 when opening the database

We are encountering ths problem:
DATABASE

    Requires Free Membership to View

OPEN: error when opening database:
ORA-01089: immediate 
 shutdown in progress - no operations are permitted.
Can you tell us in what situations do we get this error?

Your database is trying to shut down. When it is trying to shut down, no one is allowed to log in. To find out why your database is trying to shut down, you'll have to look in your database's alert log file for clues.

Sometimes, the database won't shut down no matter how long you wait. So you'll have to force it down and then restart it. The following commands in SQL*Plus should do the trick:

connect / as sysdba
shutdown abort
startup
You should now be able to connect to your database.


This was first published in July 2004

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.