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.
LVL 8
sapnamAsked:
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.
0
 
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.
0
 
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.
0
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 ?
0
 
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?
0
 
sapnamAuthor Commented:
I had istalled Personal Oracle 9i and used the database created as part of the installation process.
0
 
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
0
 
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 ?
0
 
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,
0

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
0
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.