ORA-01033 Oracle Initialization or shutdown in progress

I have Personal Oracle 9i installed on a machine and an application which runs on the same. This was working fine for past 2 years.  Now , when I want to run the application, I am getting the message ORA-01033 Oracle initialization or shutdown in progress.  The help says - Try operation after some time.  But I have waited all day and the message is still the same.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
you have to check on oracle side, try to connect directly on the oracle database.
I assume that the database has gone down (or someone has issued the shutdown statement), and it has not yet gone through.
if you have a DBA, ask him.
if you are the "DBA", connect locally on the database server using sql*plus:

cmd> sqlplus "/ as sysdba"
sql> shutdown abort
sql> startup

and the database should be up again.
sapnamAuthor Commented:
Thanks for the help.I tried what you stated.
 The shutdown went through.  
Then for startup, I am getting the following errors

 ORA-01172 recovery of thread 1 stuck at block 283386 of file 2.
ORA-01151 : use media recovery to recover block, restore backup if needed.

  I would like to add that this is a test database so the data is not that important.  But, I need to get the database started for my development work.

Please advise.
Guy Hengel [angelIII / a3]Billing EngineerCommented:
so that explains what "happened": your database went down because of physical damage.
you now need to recover, either using archive log files (if the db is in archivelog mode), or restore a full backup.
what backups do you have?
if you have none, you have to recreate the db.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

sapnamAuthor Commented:
Thanks for your help.  Can you tell me How can I re-create the database ?  Should I close this thread by accepting your answer and post a new question for that ?
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>Can you tell me How can I re-create the database ?
in short, you delete all the database-related files, and create a new database.
I assume that you know how you created that database?
sapnamAuthor Commented:
I had istalled Personal Oracle 9i and used the database created as part of the installation process.
Guy Hengel [angelIII / a3]Billing EngineerCommented:
ok, check out the tool Database Assistant (should be in the oracle menus).
in the binary folder, check out dbca.exe
sapnamAuthor Commented:
I have a dbca.bat in my bin folder.  When I ran it, it gave me the Database Configuration Assistant.  Here i get option to Delete and create database.  So, should I first delete the database including database files and create a new database.  Will there be any options/parameters to be specified ?
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, you found the correct tool.

>will there be any options/parameters to be specified ?
yes, the same as when you installed oracle when it asked about creating a database,

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sapnamAuthor Commented:
Thank you , angelIII, the problem is solved
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.