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)
7 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
Thank you.After doing steps you have given it is working fine.
Thank you.After doing steps you have given it is working fine.
Thank you.After doing steps you have given it is working fine.
Post a Comment