Two solutions for ora-01033:oracle initialization or shutdown in progress

Ora-01033:oracle initialization or shutdown in progress is usually caused by corruption of the ORACLE database file, following are the problems and resolutions that occur:

Symptom One : sysdba can log in, but in use, the database is not open, only allowed to query in fixed table/view, and normal user cannot log in to use, ora-01033:oracle initialization or Shutdown in progress error.

Analysis: This error should be due to Oracle after the start of the user login is to the original configuration information loaded into the scheme, the loading process is not found in the configuration files, so they reported errors.

resolution process :

C:\Documents and Settings\zhuanyou8>sqlplus/nolog

Sql*plus:release 10.1.0.2.0-production on Monday September 28 14:35:38 2009

Copyright (c) 1982, Oracle. All rights reserved.

Sql> connect sys/zhuanyou8 as SYSDBA;
is connected.
sql> shutdown Normal
ORA-01109: Database not open

The database has been unloaded.
The ORACLE routine has been closed.
sql> startup Mount;
The ORACLE routine has started.

Total System Global area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145750508 bytes
Database buffers 25165824 bytes
Redo buffers 262144 bytes
Database loading complete.
sql> ALTER DATABASE open;
ALTER DATABASE Open
*
Line 1th Error:
ORA-01589: You must use the Resetlogs or Noresetlogs option to open the database

sql> ALTER DATABASE open resetlogs;
ALTER DATABASE open Resetlogs
*
Line 1th Error:
ORA-01157: Unable to identify/lock data file 2-see DBWR trace file
ORA-01110: Data file 2: ' C:\ORACLE\PRODUCT\10.1.0\ORADATA\ORAL\FSCREDIT40 '

sql> ALTER DATABASE datafile 2 offline drop;

The database has changed.

sql> ALTER DATABASE open resetlogs;

The database has changed.

sql> ALTER DATABASE datafile 2 offline drop;

The database has changed.

sql> ALTER DATABASE open;
ALTER DATABASE Open
*
Line 1th Error:
ORA-01531: Routine has opened the database

Sql>shutdown Normal
Tip: Database is closed
Database has been unloaded
ORACLE routines are closed

sql> startup Mount;
The ORACLE routine has started.

Total System Global area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145750508 bytes
Database buffers 25165824 bytes
Redo buffers 262144 bytes
Database loading complete.

By this, the problem has been solved.

phenomenon Two, did not delete some documents, may be illegal shutdown or caused by power failure. Causes SYSDBA to log on, but in use the database is not open, only allowed to query in fixed tables/views, and normal users cannot log on using

resolution process:

1, enter CMD, execute set oracle_sid=www.zhuanyou8.com, make sure to connect to the correct SID;

2, run Sqlplus "/as sysdba"

Sql>shutdownimmediate Stop Service

Sql>startup Start Service, observe if there is no data file loading error at startup, and remember the error data file marking

Sql>shutdownimmediate Stop Service again

Sql>startupmount

Sql>recover datafile 2 Recovery error data file

Sql>shutdownimmediate Stop Service again

Sql>startup start service, this time normal

3, enter Pl/sql developer check, no further prompts error.

=======================================================

Oracle Expert QQ Group (500 people): 60618621

Oracle enthusiasts are welcome to join.

=======================================================