Monday, October 29, 2007

ORACLE: ORA-01033 error

I am back as I promised, this time I will try to explain how to resolve ORA-01033: (I will be assuming that some how a data file was corrupted)

Login as sys

ORA-01033: ORACLE initialization or shutdown in progress

C:\>sqlplus

SQL*Plus: Release 9.2.0.1.0 - Production on Mon Oct 29 11:15:18 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name: sys as sysdba
Enter password :[password]


Shutdown Database

SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.


Startup Database (force)

SQL> startup force;
ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 116 - see DBWR trace file
ORA-01110: data file 116: 'data file name that is corrupted'


Drop the Corrupted Data file

SQL>alter database data file ‘data file name that is corrupted’ offline drop;
Database altered.

After dropping the corrupted file or files, it should be back to normal now just alter db open.

SQL> alter database open;
Database altered.


This is one of the scenarios that could prompt the ORA-01033: ORACLE initialization or shutdown in progress. Hope this helps you guys=ELK=

7 comments:

pooja said...

thanks,after doing all these commands.i got succeded.thanks again.

pooja

HarisH said...

SQL> startup force
ORACLE instance started.

Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 310378960 bytes
Database Buffers 218103808 bytes
Redo Buffers 5804032 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[109], [4978], [4981], [], [], [], [], [], [], []

aeriusma said...

what should i do for this error?...plz help...

ERROR at line 1:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 70116 change 17179869187 time 07/14/2011
10:11:51
ORA-00312: online log 3 thread 1:
'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG'

Oscar said...

Friends I hope you can help me. When I do "startup force" at the end of the script says
ORA-00600: codigo de error interno, argumentos:[kcrf_resilver_log_1],[0x7ff49c56728],[2],[],[],[],[],[],[],[],[],[]
I dont'know what to do, it's coming me mad. Thanks

Krish said...

Thank you.After doing steps you have given it is working fine.

Krish said...

Thank you.After doing steps you have given it is working fine.

Krish said...

Thank you.After doing steps you have given it is working fine.