Solution ORA-01033 ORACLE initialization or shutdown in progress

Solution:1

ORA-01033: ORACLE initialization or shutdown in progress See additional clues exist with alert_SID.log for this error .Cause: An attempt was made to log on while Oracle is being started up or shutdown.Action: Wait a few minutes. Then retry the operation. But if it show the same error then follow it :-)went to prompt and typed

sqlplus /nolog

tried to connect using sys, got the same error

fired

connect / as sysdba

fired

shutdown

got

ORA-01109: database not openDatabase dismounted.ORACLE instance shut down.

fired

startup

got

ORACLE instance started.Total System Global Area 276371980 bytesFixed Size 453132 bytesVariable Size 117440512 bytesDatabase Buffers 157286400 bytesRedo Buffers 1191936 bytesDatabase mounted.ORA-01113: file 30 needs media recoveryORA-01110: data file 30: 'E:ORACLEORADATAINDEX5_1T.ORA'

fire  SQL>alter database recover datafile 30;

got

ERROR at line 1:ORA-00283: recovery session canceled due to errorsORA-01114: IO error writing block to file 30 (block # 1)ORA-01110: data file 30: 'E:ORACLEORADATAINDEX5_1T.ORA'ORA-27091: skgfqio: unable to queue I/OORA-27041: unable to open fileOSD-04002: unable to open fileO/S-Error: (OS 5) Access is denied.

E:ORACLEORADATAINDEX5_1T.ORA file was readonly. Unchecked it.

fired

alter database recover datafile 30;

shutdown

startup

Database mounted and opened successfully!- I was not able to log in so I used :> sqlplus /nolog

And after that, I used these commands :

SQL> connect / as sysdba

SQL> shutdown abort

SQL> alter database mount;

SQL> alter database open resetlogs;

And all works !!

Solution: 2

 Open Dos command Promptc:> sqlplus /nolog

SQL> connect sys/manager as sysdba

SQL> shutdown immediate;Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 161966464 bytesFixed Size 887988 bytesVariable Size 135750508 bytesDatabase Buffers 25165824 bytesRedo Buffers 262144 bytesDatabase mounted.

ORA-01157: cannot identify/lock data file 6 - see DBWR trace fileORA-01110: data file 6: 'E:\oracle\product\10.2.0\oradata\orcl\UNDOTBS01.DBF'

I realized what happened and how this happened. It's all my fault. During a clean-up effort this file was accidentally deleted.

so i did the folowing:Mount the database and drop the datafile usingalter database datafile '<<file_name>>' offline drop;

and then open the database

alter database open;

First, I saw what tablespace I have in my database:select segment_name, tablespace_name, initial_extent,statusfrom dba_rollback_segs;

Second, I created the corrupted file:create undo tablespace UNDO1 datafile 'E:\oracle\product\10.2.0\oradata\orcl/undo01.dbf' size 10M;

Third, I alter the systems tablespace, as follows:ALTER SYSTEM SET UNDO_TABLESPACE = undotbs_02;

And then everything was ok

Solution 3:

SQL> startup mount;

ORACLE instance started.

Total System Global Area  167772160 bytes

Fixed Size                  1288340 bytes

Variable Size             104859500 bytes

Database Buffers           54525952 bytes

Redo Buffers                7098368 bytes

Database mounted.

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 852956 generated at 09/13/2010 08:58:26 needed for thread 1

ORA-00289: suggestion :

D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\T\ARCHIVELOG\2010_09_13\O1_MF_1_9_%U_.ARC

ORA-00280: change 852956 for thread 1 is in sequence #9

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

D:\oracle\product\10.2.0\oradata\T\REDO01.LOG

ORA-00310: archived log contains sequence 8; sequence 9 required

ORA-00334: archived log: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\T\REDO01.LOG'

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\T\SYSTEM01.DBF'

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 852956 generated at 09/13/2010 08:58:26 needed for thread 1

ORA-00289: suggestion :

D:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\T\ARCHIVELOG\2010_09_13\O1_MF_1_9_%U_.ARC

ORA-00280: change 852956 for thread 1 is in sequence #9

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

D:\oracle\product\10.2.0\oradata\T\REDO02.LOG

Log applied.

Media recovery complete.

SQL> alter database open;

alter database open

*ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;

Database altered.

SQL> :-)