Jump to Navigation

231 - ORA-01033 when you login

When you try to login, you are getting the following error :

 ORA-01033: ORACLE initialization or shutdown in progress

It seems like one of the dbf files is broken or unreadable at this moment. You should check the recovery file.

SQL> select t.name tablespace_name, d.name file_name, r.* from v$recover_file r,v$datafile d,v$tablespace t where r.file# = d.file# and d.ts# = t.ts#;

view - v$recover_file :
This view displays the status of files needing media recovery.

ERROR at line 1:
ORA-01122: database file 43 failed verification check
ORA-01110: data file 43:
'/d03/DATA/oracle/PROD/db/apps_st/data/a_txn_data11.dbf'
ORA-01251: Unknown File Header Version read for file number 43

You need to store a file from a backup. Then shutdown & restart oracle database.

tar -zxvf oracle-data-11g-08-21-11.tar.gz d01/DATA/oracle/PROD/db/apps_st/data/a_txn_data11.dbf

 

 

Oracle:


Main menu 2

Story | by Dr. Radut