ORA-01033: ORACLEinitializationorshutdowninprogress.

Because a data file in the Oracle database is deleted by mistake, the Oracle-related services on the control panel are started, but SQL * Plus cannot be connected. SQLgt; shutdownimmediate; (s

Because a data file in the Oracle database is deleted by mistake, the Oracle-related services on the control panel are started, but SQL * Plus cannot be connected. SQLgt; shutdown immediate; (s

Cause: because a data file in the Oracle database is accidentally deleted, the Oracle-related services on the control panel are started, but SQL * Plus cannot be connected.

Solution:

You can open the database by taking the data file offline (deleting the data file normally.

SQL> conn/as sysdba;
Connected.
SQL> shutdown immediate; (shutdown does not seem to display a ORA-01109: the database did not open such information)
ORA-01109: the database is not open
The database has been detached.
The ORACLE routine has been disabled.
The ORACLE routine has been started.
(In fact, this error means that the database initialization or is closed, When I directly close, finally reported a ORA-01109: Database not open error .)
Startup force; (Be sure to force the startup)
Total System Global Area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 83886080 bytes
Database Buffers 33554432 bytes
Redo Buffers 532480 bytes
The database has been loaded.

ORA-01157: unable to identify/lock data file 9-see DBWR trace file
ORA-01110: data file 9: 'd: \ test \ ELOA'
Questions left: (dizzy, not offline last time, but the shadows are not scattered. You can study what else is following the tablespace)
SQL> shutdown immediate
ORA-01109: the database is not open
The database has been detached.
The ORACLE routine has been disabled.
SQL> startup mount;
SQL> alter database datafile 9 offline drop;
The database has been changed.
SQL> recover datafile 9; (if it is another file, it can be restored. This is not required here)
Media recovery is completed.
SQL> alter database open;
The database has been changed.
SQL> drop tablespace orcl

The tablespace is discarded.
SQL> conn/as sysdba

Connected.