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: '
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=
Monday, October 29, 2007
ORACLE: ORA-01033 error
Subscribe to:
Post Comments (Atom)
4 comments:
thanks,after doing all these commands.i got succeded.thanks again.
pooja
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], [], [], [], [], [], [], []
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'
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
Post a Comment