Ask the Expert

Cause of ORA-1089 error

I'm getting the ORA-01089 error and the system is allowing me to connect to the database as sysdba using SQL*Plus. I must say that I'm novice when it comes to Oracle. Any suggestions?

    Requires Free Membership to View

The ORA-1089 error is telling you that someone attempted to perform a SHUTDOWN of the database. No new transactions can be started. If this condition persists for a long period of time, sign on to the database as SYSDBA and issue the following:

SHUTDOWN ABORT
STARTUP

This will force the database to shut down immediately and then start it back up. Transactions can now take place.

This was first published in April 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: