Oracle ora-01033:oracle initialization or shutdown in progress error resolution

You've been testing your server's migration issues, creating table spaces, creating databases, and creating users. Later feel to create so many things too occupy disk space, thought to delete it, so, we executed the DBCA command, will not use the database removed all the DBF and DMP files are deleted, and then found that the service can not be started, the connection will prompt Oracle initialization or shutdown in progress, later through the query found that the original DBF and DMP is not said to delete can be deleted (when we clearly found that some do not allow the deletion, I still deliberately stop the Oracle service, and then remove it), resulting in the database instance will not start.

My resolution is as follows: Microsoft Windows [version 5.2.3790] (C) Copyright 1985-2003 Microsoft Corp. C:\Documents and Settings\administrator>sqlplus/nologSql*plus:release 10.2.0.1.0-production on Fri March 4 18:40:13 Copyright (c) 1982, 2005, Oracle. All rights reserved. sql> connect system/hope;Error:ora-01033:oracle initialization or shutdown in progress "that's the mistake." "Workaround" sql> Connect Sys/hope as Sysdbais connected. sql> shutdown NormalORA-01109: The database is not open and the database has been unloaded. The ORACLE routine has been closed. sql> Start MountSP2-0310: Unable to open file "Mount.sql" Sql> startup Mountoracle routine has been started. Total System Global area 612368384 bytesfixed size 1332348 bytesvariable size 183151492 byte Sdatabase buffers 423624704 Bytesredo buffers 4259840 bytes database loaded.sql> ALTER DATABASE open;ALTER DATABASE open* 1th 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 5 in data file"The database has changed. sql> ALTER DATABASE open; "We've been looping this statement until we don't prompt the error"The database has changed. sql> shutdown NormalThe database is closed. The database has been uninstalled. The ORACLE routine has been closed. sql> StartupThe ORACLE routine has been started. Total System Global area 612368384 bytesfixed size 1332348 bytesvariable size 187345796 byte Sdatabase buffers 419430400 Bytesredo buffers 4259840 bytes database loaded. The database is already open. This solves the ~ ~ ~ Hahaha ~~~~~~~~~~~~~~~~~~~~ reprint: http://blog.sina.com.cn/s/blog_49f485700100s362.html

Oracle ora-01033:oracle initialization or shutdown in progress error resolution