[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1651
  • Last Modified:

ora-01033 oracle initialization or shutdown in progress

My oracle 10g was running successfully on vista. But suddenly it has start giving me error:"ora-01033 oracle initialization or shutdown in progress". Guide me what to do to solve this problem. Due to this I am not able to connect to any schema/user.
0
hsperhar
Asked:
hsperhar
  • 5
  • 4
1 Solution
 
sdstuberCommented:
go to command line as a user that is a member of the oradba group and shutdown the database and then restart it

sqlplus / as sysdba
SQL> shutdown immediate
SQL> startup


or, what might be easier, go to control panel and restart the service
0
 
hsperharAuthor Commented:
This I have done many times, even have restarted my computer also. But this is not solving the problem.
Below is the output of your suggested steps:
/*********************************************************
Enter user-name: / as sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  452984832 bytes
Fixed Size                  1291120 bytes
Variable Size             436210832 bytes
Database Buffers            8388608 bytes
Redo Buffers                7094272 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
***************************************************************************/
Please let me know if you need any further information in this regard.
0
 
hsperharAuthor Commented:
Even if I try to start the OracleOraHome92TNSListener Service then it also gives a error on windows: "Error 1053:The service did not response to start or control request is in timely fashion."
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
sdstuberCommented:
is this a development/test database or production?

that is, is it important to recover the database, or just get it running?

do you have a good backup and archive logs to recover?
0
 
hsperharAuthor Commented:
Oh, This is in my personnel computer.I have some good data in the database which I do not want to loose.I want to get my tables and want to see db running again.
It sounds like you have a plan.
0
 
sdstuberCommented:
are you running in archive log mode?  do you have the logs so you can recover?

if so, try to recover your database

instead of "startup"  do "startup mount"
and then try to recover your database. walking through a recovery is outside the scope of this forum.

once you've recovered, or if you aren't in archive log mode you can try to open your database.

first, try to open with noresetlogs


"alter database open noresetlogs"

if that fails, you can try to open with resetlogs,  note, doing so will, as the name implies, "reset" your logs meaning you may lose some transactions.
so, don't do this until you've exhausted your recovery options.

"alter database open resetlogs"




0
 
sdstuberCommented:
also note, at only 20 points, your question isn't likely to attract a lot of attention.  Points are intended to represent the "importance" of the question to you.
if you don't value the question highly then there isn't much incentive for the other volunteers to pay much heed.
And of course, for point hunters, 20 points likely isn't worth the effort.

good luck!
0
 
hsperharAuthor Commented:
While executing about commands, I'm getting following result:
/*************************************
SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01588: must use RESETLOGS option for database open

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\HSP\SOFTWARE\INSTALLED\ORADATA\CHGREQ\SYSTEM01.DBF'
****************************************/
What do you suggest?
0
 
sdstuberCommented:
you need to recover your system datafile before you can open.

unfortunately, performing a recovery is outside the scope of this forum.

I recommend contacting your local dba and getting assistance restoring from your backup and applying your archive logs.

if you don't have archive logs hopefully you at least have a recent cold backup.  if you don't have that, you're probably looking at starting over.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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