Error due to moving or deleting DBF file:
ora-01033:oracle initialization or shutdown in progressCause: Generally, this type of failure is usually caused by moving files that affect the inability of an IO operation due to corruption of the database log file. Oracle will recognize that the database has not been loaded and is causing the error to occur. Fault characteristics: Using command line sqlplus or PL/SQL Developer cannot open the database. However, you can use the SYS user to log in to the system workaround as SYSDBA: 1. Execute cmd 2 at ' start ' and ' run '. Input: Sqlplus "/As SYSDBA" should be prompted similar to the following information: sql*plus:release 9.2.0.1.0-production on Wednesday July 19 17:07:45 2017 copyright (c) 1982, 2002, Oracle Corporation. all rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0-productionwith The partitioning, OLAP and Or Acle Data Mining optionsjserver Release 9.2.0.1.0-production 3. Input: Shutdown immediate should be prompted similar to the following information: ora-01109: Database is not open database has been unloaded. 4. Input:startup should prompt similar to the following information: ora-01157: Unable to identify/lock data file 15-see DBWR trace file ora-01110: Data file: ' D:\ Test\my_index1_1.dbf ' 5. According to the 4th step information input: ALTER DATABASE datafile ' F:\app\zang\oradata\orcl\TS3. DBF ' offline drop should be prompted with information similar to the following: the database has changed. 6. Repeat steps 3rd, 4, 5, until the 4th step no longer appears ORA-01157, ORA-01110 error message, that is OK.
Error--ora-01033:oracle initialization or shutdown in progress
due to deletion of DBF file
