Oracle Database Discussions

Hi,

I am using Oracle9i (9.2.0.1.0) on Windows 2000 platform. Today I was unable to connect the database. When I ran SQL*Plus, it gave me the following error.

SQL> connect
Enter user-name: someuser/pswd@mydb
ORA-01033: ORACLE initialization or shutdown in progress

I searched the 'asktom' site for ‘ORA-01033’ and learned that I should connect as ‘sysdba’. So I ran OEM and used username ‘sys’ and connected as ‘sysdba’, I was connected to the database. I saw the database Instance State was in ‘Started (NOMOUNT)’. I selected the ‘Shutdown - Immediate’ option, it succeeded. Then I selected the ‘Open’ option to start the database again. The step ‘Starting up the database’ got the ‘tick’ icon but the process stopped at the next step ‘Mounting the database’ with the following error.

ORA-00214: controlfile ‘D:\ORACLE\ORADATA\ORA9I\CONTROL02.CTL’ version 1422 inconsistent with file ‘D:\ORACLE\ORADATA\ORA9I\CONTROL01.CTL’ version 14

The OEM again showed the database instance is in ‘Started (NOMOUNT)’ state.

I again searched the 'asktom' site for ‘ORA-00214’ but this time found no entry. I took a deep sigh, because I don’t want to take risk and play with the production-database.

I am waiting for the response anxiously. Thanks in anticipation.

Regards