Oracle 11g Error ora-01033:oracle initialization or shutdown in progress solution ____oracle

Source: Internet
Author: User

First, firstly: the cause of the problem, I previously created in the f:/llh/directory of a bookspace table space, and then do not want to this table space, so I directly deleted, this error is because I will f:/llh/bookspace.dbf and several files mistakenly deleted after the appearance.

Second, the phenomenon: Sql*plus cannot connect, display the following error: Ora-01033:oracle initialization or shutdown in progress
Third, analysis: should be Oracle after the start, the user login is to the original configuration information loaded into the scheme, the loading process encountered the original file specified location did not find, so they reported errors.
Iv. the process of settlement:
1, first run cmd under Windows, into the DOS environment.
2, the DBA user login, the specific command is
Sqlplus/nolog

Connect Sys/change_on_install as Sysdba


Tip: Successful

Shutdown normal

Tip: Database is closed
Database has been unloaded
ORACLE routines are closed


Startup Mount



Tip: Oracle routines have started
Total System Global area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 82886080 bytes
Database buffers 33554432 bytes
Redo buffers 532480 bytes
Database loading complete

ALTER DATABASE open;

Tips:
Line 1th Error:
ORA-01157: Unable to identify/lock data file 19-see DBWR trace file
ORA-01110: Data file: ' F:/llh/bookspace '. DBF ";
This hint file is somewhat different depending on each individual situation.

Continue Typing

ALTER DATABASE datafile offline drop; (Note: This is the number of tips above, this tip 19)


Tip: The database has changed.

Loop through the last two steps until ALTER DATABASE open and no longer prompt for an error, and the "DB Changed" appears.
And then you can enter

Shutdown normal


Tip: Database is closed
Database has been unloaded
ORACLE routines are closed

Startup



Tip: Oracle routines have started
Total System Global area 118255568 bytes
Fixed Size 282576 bytes
Variable Size 82886080 bytes
Database buffers 33554432 bytes
Redo buffers 532480 bytes
Database loading complete


can be solved.

Related Article

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.