Oracle error: ORA-01033

(In particular, this post mainly comes from "Fun C technology. NET ", I made some edits and added a little bit of my opinion. For the original article, see Ghost. NET.

In addition, you can add a number for your blog .)

Error Code: ORA-01033: ORACLE initialization or shutdown in progress

Fault description: A ORA-01033 error occurs during database connection because files such as database files ([NAME]. DMP)/log files are moved.

Fault Analysis: There is a common saying on the Internet that this type of fault is usually caused by the failure to perform IO operations due to the damage to the database log files caused by moving files. ORACLE recognizes that the database is not fully loaded and the above error occurs.

Fault features: You cannot open a database using command line sqlplus or PL/SQL Developer. However, you can use the sys user to log on to the system as sysdba.

Procedure:

1. Run cmd in 'start' --> 'run '.

2. Input: sqlplus "/as sysdba"

The following information should be prompted:

SQL * Plus: Release 9.2.0.1.0-Production on Wednesday May 20 22:07:45 2009

Copyright (c) 1982,200 2, Oracle Corporation. All rights reserved.
Connect:
Oracle9i Enterprise Edition Release 9.2.0.1.0-Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0-Production

3. Input: shutdown immediate
The following information should be prompted:

ORA-01109: the database is not open

The database has been detached.

4. Input: startup

The following information should be prompted:

ORA-01157: unable to identify/lock data file 15-see DBWR trace file
ORA-01110: Data File 15: 'd: \ TEST \ MY_INDEX1_1.DBF'
5. Enter alter database datafile 'd: \ TEST \ MY_INDEX1_1.DBF 'offline drop according to step 2.

The following information should be prompted:

The database has been changed.

6. Repeat steps 3rd, 4, 5 until the ORA-01157, ORA-01110 error message does not appear in step 4th, that is, OK.