ORA-01033: Oracle initialization or shutdown in progress
C: \ Users \ Administrator> sqlplus/nolog
SQL * Plus: Release 10.2.0.1.0-production on Friday April 26 19:05:16 2013
Copyright (c) 1982,200 5, Oracle. All rights reserved.
SQL> connect sys/admin as sysdba;
Connected.
SQL> shutdown normal;
ORA-01109: the database is not open
The database has been detached.
The Oracle routine has been disabled.
SQL> startup Mount;
The Oracle routine has been started.
Total system global area 293601280 bytes
Fixed size 1248600 bytes
Variable Size 88081064 bytes
Database buffers 197132288 bytes
Redo buffers 7139328 bytes
The database has been loaded.
SQL> alter database open;
Alter database open
*
Row 3 has an error:
ORA-01157: unable to identify/lock data file 14-see dbwr trace file
ORA-01110: Data File 14: 'd: \ oracledata \ zjjb2_data.ora'
SQL> alter database datafile 14 offline drop;
The database has been changed.
SQL> alter database open;
The database has been changed.
SQL> select sysdate from dual;
Sysdate
--------------
26-4 month-13
SQL>