ORACLE initalization or shutdown in progress

C: \ Documents ents and Settings \ Administrator> sqlplus/nolog
SQL> connect system/password 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 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 348130180 bytes
Database Buffers 255852544 bytes
Redo Buffers 7135232 bytes
The database has been loaded.
SQL> alter database open
2;
Alter database open
*
Row 3 has an error:
ORA-01157: unable to identify/lock Data File 5-see DBWR trace file
ORA-01110: Data File 5:
 
'E: \ DATABASE \ ORACLE \ ORADATA \ ORCL \ mobile_base.dbf'
 
 
SQL> alter database create datafile 5;
 
The database has been changed.
 
SQL & gt; conn test/123456
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
 
 
Warning: you are no longer connected to ORACLE.
SQL> conn scott/tiger
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
 
 
SQL> alter database datafile 5 offline drop;
SP2-0640: not connected
SQL> conn sys/orcle
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
 
 
SQL> conn sys/oracle 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 612368384 bytes
Fixed Size 1250428 bytes
Variable Size 348130180 bytes
Database Buffers 255852544 bytes
Redo Buffers 7135232 bytes
The database has been loaded.
SQL> alter database open
2;
Alter database open
*
Row 3 has an error:
ORA-01113: File 5 requires media recovery
ORA-01110: Data File 5:
 
'E: \ DATABASE \ ORACLE \ ORADATA \ ORCL \ mobile_base.dbf'
 
 
SQL> alter database datafile
 
'E: \ DATABASE \ ORACLE \ ORADATA \ ORCL \ MOBILE_BASE.D
Ffline;
Alter database datafile
 
'E: \ DATABASE \ ORACLE \ ORADATA \ ORCL \ mobile_base.dbf'
 
O
E
*
Row 3 has an error:
ORA-01145: do not allow immediate offline unless media recovery is enabled
 
 
SQL> alter database datafile
 
'E: \ DATABASE \ ORACLE \ ORADATA \ ORCL \ MOBILE_BASE.D
Ffline drop;
 
The database has been changed.
 
SQL> alter database open
2;
 
The database has been changed.
 
SQL & gt; conn test/123456
Connected.
SQL>

Author: "the long-awaited sea"