ora-01033 oracle initialization or shutdown in progress

5 pts.
Tags:
ORA-01033
Oracle error messages
ora-01033 oracle initialization or shutdown in progress what is solution

Answer Wiki

Thanks. We'll let you know when a new response is added.

In normal situations, you just need to wait until the initialization process ends.

But this could also happen if something fails during the database initialization process, for example, corrupted log files or disk errors.

Try running this at the server:

<pre>sqlplus /nolog
SQL> conn / as sysdba
SQL> shutdown immediate
SQL> startup</pre>

You will probably get errors here, which wil tell you what the problem is.

If you can’t run the above, look for information in the alert log, which should be located in:

..\oracle\admin\<instancename>\bdump\

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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
  • Inprise
    Hi, As mentioned by Carlos is correct way Other would if session showing Shutdown in process Then can check n pmon,whether the instance is running idle way,then can kill that process id and again startup in new session I faced similar problem and it worked. Regards Inprise
    610 pointsBadges:
    report
  • alhomede123
    hi help pleas how recover data of oradate file

    10 pointsBadges:
    report
  • TomLiotta
    ...how recover data of oradate file
    .
    This doesn't seem related to this question thread. If you need help, please open your own question. Describe your problem so we know how to help.
    .
    Tom
    125,585 pointsBadges:
    report

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following