ORA-01219 database not opened

ORA-01219 database not opened

Today after the connection data, a look at the prompt that the ORA-01219 database is not open, closed the service re-opened is still like this, in the Baidu found the problem.

I deleted a data file and looked at the solution.

Error cause:
Close the database and delete the DBF file. That is, the tablespace file. An error occurs.

1. First, connect to the mount mode of Oracle and log on with the sys account,

2. Enter alter space. The database space is open;

3. Wait a moment and you will see the deleted or problematic database file. Remember the path and file name or mark it and copy it.

4. After running cmd (not sqlplus), enter sqlplus/nolog in the DOS window without spaces.
5. connect space/space as sysdba

6. This prompts connected comrades to continue. Input: alter space database space datafile. Here is the database file name you have a problem or you have deleted (the name must start with a path such: D :) 'offline space drop; then the system prompts "database changed ".

7. Enter alter database open again. Then, the system prompts "database changed ".

8. Input: name of the database file with the drop tablespace error (excluding the suffix name, for example, BOOK. DBF, enter BOOK ). The system prompts "The tablespace has been deleted ".

9. Enter the conn user name/password. After you press enter, the system prompts "connected!

The following are all the commands:

Step 1: SQL> C: \ Users \ Administrator \ sqlplus/nolog

Step 2: SQL> conn/as sysdba

Step 3: SQL> alter database datafile 'x: xxx. dbf' offline drop;

Step 4: SQL> alter database open;

Step 5: SQL> drop tablspace xxx;

Do not delete database files in windows next time. Otherwise, an error is reported when the database cannot be opened when oracle is started. We recommend that you drop the database.