Oracle initialization or shutdown in progress solution appears after the data file is accidentally deleted by oracle,

Oracle initialization or shutdown in progress solution appears after the data file is accidentally deleted by oracle,
I. Error Analysis

1. In this case, the tablespace generated after the following SQL statement is executed.

1 -- custom TABLESPACE data table space temporary tablespace 2 create temporary tablespace HOUSE_TEMP 3 TEMPFILE 'd: \ OracleData \ HOUSE_TEMP.DBF '4 SIZE 32 M 5 autoextend on 6 NEXT 32 M 7 MAXSIZE 2G 8 extent management local; 9 10 create tablespace HOUSE_DATA11 LOGGING12 DATAFILE 'd: \ OracleData \ HOUSE_DATA.DBF '13 SIZE 32M14 AUTOEXTEND ON15 NEXT 32 M 16 MAXSIZE UNLIMITED17 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.

1 # This is the cmd command. Run 2 sqlplus/nolog as the administrator.

B: Use the sysdba role to connect

1 SQL> user/ui as sysdba

C: run the following command to delete your tablespace:

1 SQL> alter database datafile 'E:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/TSTEST001.DBF' offline drop;2 SQL> alter database open;3 SQL> drop tablespace CTBASEDATA;

D: Use the preceding command again until the prompt that your data file does not exist.

E: Remember to exit your routine after using this routine, otherwise you will gg

SQL > exit

3. After connecting again, you will find that you can connect to the database. Isn't it very good? Don't worry. Check your original folder. Although you have deleted your data file, however, your temporary file still exists. File with * temp. DBF. This is the temporary tablespace you created. Remember to delete it at the same time. Run the following command on the command line to delete it:

SQL> alter database tempfile 'your temporary file path 'drop including datafiles

4. It is best to restart the computer after deletion, so that Oracle can be used securely. Finally, you should be cautious when creating tables because data is risky.

Appendix:

Create USER commands

-- Create user house identified by HOUSE_DATADEFAULT TABLESPACE HOUSE_DATATEMPORARY TABLESPACE HOUSE_TEMP;

Change User Password command

Alter user Username identified by new password