ORA-01033: two solutions for ORACLE initialization or shutdown in SS

ORA-01033: ORACLE initialization or shutdown in progress two solutions symptom 1: sysdba can log on, but in use it appears "database not open, allow queries only in a fixed table/view, while normal users cannot log on to use, an error occurs in ORA-01033: ORACLE initialization or shutdown in progress. Analysis: the cause of this error is that after Oracle is started, the user needs to load the original configuration information in the solution during login. During the loading process, files in the configuration are not found, therefore, an error is reported. Solution Process:

C: \ Documents ents and Settings \ zhuanyou8> sqlplus/nologSQL * Plus: Release 10.1.0.2.0-Production on Monday September 28 14:35:38 2009 Copyright (c) 1982,200 4, Oracle. all rights reserved. SQL> connect sys/zhuanyou8 as sysdba; connected. SQL> shutdown normalORA-01109: the database has not been opened and the database has been detached. The ORACLE routine has been disabled. SQL> startup mount; the ORACLE routine has been started. Total System Global Area 171966464 bytesFixed Size 787988 bytesVariable Size 145750508 bytesDatabase Buffers 25165824 bytesRedo Buffers 262144 bytes database loaded. SQL> alter database open; alter database open * 1st Line Error: ORA-01589: to open the database, you must use RESETLOGS or NORESETLOGS option SQL> alter database open resetlogs; alter database open resetlogs * 1st row 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; database changed. SQL> alter database open resetlogs; the database has been changed. SQL> alter database datafile 2 offline drop; the database has been changed. SQL> alter database open; alter database open * 1st Line Error: ORA-01531: Routine opened database SQL> shutdown normal prompt: the database has been disabled and the ORACLE routine has been disabled. SQL> startup mount has been disabled. The ORACLE routine has been started. Total System Global Area 171966464 bytesFixed Size 787988 bytesVariable Size 145750508 bytesDatabase Buffers 25165824 bytesRedo Buffers 262144 bytes

 

The database has been loaded. At this point, the problem is solved. Symptom 2: some files have not been deleted, which may be caused by illegal shutdown or power failure. As a result, sysdba can log on, but "the database is not opened and can only be queried in a fixed table or view" is displayed during use, while normal users cannot log on to the solution: 1. Go to CMD and run set ORACLE_SID = www.zhuanyou8.com to ensure the correct SID is connected. 2. Run sqlplus "/as sysdba"

SQL> shutdownimmediate stop service SQL> startup start service. check whether there is any data file loading error at startup, remember the error data file number SQL> shutdownimmediate stop service again SQL> startupmount SQL> recover datafile 2 recover the data file SQL> shutdownimmediate stop service SQL again> startup start service, this time normal

 

3. Go to PL/SQL Developer for check. No error is displayed.