• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2073
  • Last Modified:

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.
0
sapnam
Asked:
sapnam
  • 5
  • 5
1 Solution
 
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
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
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
 
sapnamAuthor Commented:
Thank you , angelIII, the problem is solved
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now