ora01219 database is not open

Source: Internet
Author: User
Tags sqlplus

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.