Oracle 11g Error ora-01033:oracle initialization or shutdown in progress solution

Source: http://blog.csdn.net/liverliu/article/details/6410287

First: The cause of the problem, I previously in the f:/llh/directory created a bookspace table space, and later do not want this table space, so I deleted directly, this error is because I will f:/llh/bookspace.dbf and so on a few files deleted after the appearance.

Second, the phenomenon: Sql*plus Unable to connect, the following error is displayed: Ora-01033:oracle initialization or shutdown in progress
Third, analysis: it should be Oracle after startup, the user is logged in to the original configuration information loaded into the scenario, the loading process encountered the original file specified location is not found, so the error is reported.
Iv. Process of Settlement:
1, first run cmd under Windows, enter the DOS environment.
2. Log in as DBA user, the specific command is
Sqlplus/nolog

Connect Sys/change_on_install as Sysdba

Tip: Successfully

Shutdown normal

Tip: The database is closed
Database has been uninstalled
ORACLE routines are closed

Startup Mount

Tip: Oracle routines are started
Total System Global area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 82886080 bytes
Database buffers 33554432 bytes
Redo buffers 532480 bytes
Database loading complete

ALTER DATABASE open;

Tips:
An error occurred on line 1th:
ORA-01157: Unable to identify/lock data file 19-see DBWR trace file
ORA-01110: Data file: "' F:/llh/bookspace. DBF ";
This hint file section is somewhat different depending on the circumstances of each person.

Continue Typing

ALTER DATABASE datafile offline drop; (Note: The above tips on how much to use, here is the tip 19)


Tip: The database has changed.

The loop uses the last two steps until the ALTER database open; no longer prompts for an error, and a "db changed" appears.
And then you can enter it.

Shutdown normal

Tip: The database is closed
Database has been uninstalled
ORACLE routines are closed

Startup

Tip: Oracle routines are started
Total System Global area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 82886080 bytes
Database buffers 33554432 bytes
Redo buffers 532480 bytes
Database loading complete

Problem solving.

Oracle 11g Error ora-01033:oracle initialization or shutdown in progress solution