Oracle initialization or shutdown in progress solution appears after the data file is deleted by mistake in oracle
I. Error Analysis
1. In this case, the tablespace generated after the following SQL statement is executed.
-- Custom tablespace data table space Temporary tablespace
Create temporary tablespace HOUSE_TEMP
TEMPFILE 'd: \ OracleData \ HOUSE_TEMP.DBF'
SIZE 32 M
AUTOEXTEND ON
NEXT 32 M
MAXSIZE 2G
Extent management local;
Create tablespace HOUSE_DATA
LOGGING
DATAFILE 'd: \ OracleData \ HOUSE_DATA.DBF'
SIZE 32 M
AUTOEXTEND ON
NEXT 32 M
MAXSIZE UNLIMITED
Extent management local;
But !!! Sometimes because your tablespace name and file name are not so friendly. At this time, you are very happy to use the shirt + delete to permanently delete (of course, this is my habit. If you delete it back to the recycle bin and restore it directly, it will not be so troublesome ).
If this happens, you will find that you reconnect back to Oracle again, congratulations, you have a good thing, an error -- ORA-01033: ORACLE initialization or shutdown in progress
If this error occurs, if you are a Daniel, you can solve it calmly. But !!!! If you are a beginner like me, you will be nervous about your life. After all, for Oracle configuration errors, you can only say OMG.
Don't panic. Xiaozhi will take you on the bus. This is an effective test.
2. Solution
A: First, try to use the Oracle instance to operate the database using a thread.
# This is the cmd command. Run sqlplus/nolog as the administrator.
B: Use the sysdba role to connect
SQL> user/ui