Oracle initialization or shutdown in progress solution this year has been testing server migration issues, constantly creating tablespaces, creating databases, and creating users. After that, I thought that creating so many things would take up too much disk space. I thought about deleting them. So we ran the dbca command to delete all useless databases, after deleting all the dbf and dmp files, you will find that the service cannot be started. The connection will prompt oracle initialization or shutdown in progress. Later, you will find that, it turns out that these dbf and dmp cannot be deleted because they are not deleted. (at that time, we obviously found that some of them are not allowed to be deleted. I still deliberately stopped the oracle service and deleted it ), eventually, the database instance cannot be started. My solution is as follows: Microsoft Windows [version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. c: \ Documents ents and Settings \ Administrator> sqlplus/nolog SQL * Plus: Release 10.2.0.1.0-Production on Friday March 4 18:40:13 2011 Copyright (c) 1982,200 5, Oracle. all rights reserved. SQL> connect system/hope; ERROR: ORA-01033: ORACLE initialization or shutdown in progress [This is the ERROR] [solution] SQL> connect sys/hope as sysdba is connected. SQL> shutdown normal ORA-01109: the database has not opened the detached database. The ORACLE routine has been disabled. SQL> start mount SP2-0310: Unable to open file "mount. SQL" SQL> startup mount ORACLE routine started. Total System Global Area 612368384 bytes Fixed Size 1332348 bytes Variable Size 183151492 bytes Database Buffers 423624704 bytes Redo Buffers 4259840 bytes Database load is complete. SQL> alter database open; alter database open * 1st Line Error: ORA-01157: unable to identify/lock Data File 5-see DBWR trace file ORA-01110: Data File 5: 'C: \ TYKM. DBF 'SQL> alter database datafile 5 offline drop; [5 is Data File 5] The database has been changed. SQL> alter database open; [We keep repeating this statement until no error is prompted.] The database has been changed. SQL> shutdown normal database has been disabled. The database has been detached. The ORACLE routine has been disabled. The SQL> startup ORACLE routine has been started. Total System Global Area 612368384 bytes Fixed Size 1332348 bytes Variable Size 187345796 bytes Database Buffers 419430400 bytes Redo Buffers 4259840 bytes Database load is complete. The database has been opened.