Today, after connecting the data, a look at the prompt ora01219 database is not open, shut down the service is still so, in the degree Niang found the problem
It's supposed to be me. Delete a data file and see the workaround
Cause of Error:
Close the database directly, and then delete the dbf file. That is, the tablespace file. Causes an error.
1. Connect to Oracle's mount mode first, log in with the SYS account and go in.2, input alter space database space open;3, wait to see the database file you deleted or the problem, remember this path and file name or direct tag after copying down. 4, run the cmd (avoid, not sqlplus), in the DOS window input sqlplus/nolog, no space. 5. Connect space/space as SYSDBA6, this is prompted to connect the comrade continue, enter: Alter SPACE database Space datafile ' Here is your problem or deleted by you file name (must include path such as: D:) ' Offline space drop, after the "database has changed." 7. Re-enter: Alter DATABASE open; 8, Input: Drop tablespace The database file name of the problem (does not include the suffix name such as: BOOK.DBF enter book on the line). You will be prompted to "table space deleted." 9, good input: Conn user name/password, enter after the prompt "connected", well done!
all commands are given below:
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; the next time you delete a database file, do not delete it directly in Windows, or the Oracle boot will find that the database is not open to report errors, it is recommended to use drop a bit.
ora01219 database is not open