Link to home
Start Free TrialLog in
Avatar of hsperhar
hsperharFlag for United States of America

asked on

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.
Avatar of Sean Stuber
Sean Stuber

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
Avatar of hsperhar

ASKER

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.
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."
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?
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.
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"




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!
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?
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial