ORA-01033: Oracle initialization or shutdown in progress

580 pts.
Tags:
ORA-01033
Oracle 9i
Oracle 9i error messages
SYSDBA
most of our databases are on Oracle 9i. Suddenly i'm not able to start oracle or use any application that uses oracle, though all related services are working. i'm getting the error : ora-01033 oracle initialization or shutdown in progress i tryed to connect as sysdba but the user i've been given the password has not this priviledge and no one knows the sysdba user or password. Please Help
ASKED: March 18, 2009  9:49 AM
UPDATED: March 20, 2009  10:40 AM

Answer Wiki

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

This could 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: 1  Reply

 
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
  • Sous
    thank you for your reply, it seams hardware failure. thanks again
    580 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