ora-01033 oracle initialization or shutdown in progress
Ora_bieApr 25 2009 — edited Apr 26 2009I am getting above mentioned error while connecting to my oracle database. To resolve this problem, till time, I have done below given effort:
/*********************************************************
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
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'
*************************************************************/
Please help in fixing this up.