October 1, 2015

Oracle Inconsistent Control Files Error ORA-00214


Oracle Inconsistent Control Files Error ORA-00214 is a very common oracle database error. This posts guide to resolve the Oracle Inconsistent Control Files Error ORA-00214. These steps are both for Windows and LINUX users.
Follow the following steps if you are facing inconsistent control files error ORA-00214 in oracle database. 


Step 1 (to resolve Oracle Inconsistent Control Files Error ORA-00214 ):

open the sqlplus and connect as sysdba user by the following command

conn / as sysdba

and enter password

Step 2 (to resolve Oracle Inconsistent Control Files Error ORA-00214 ):

Execute the following commands

shutdown immediate;

STARTUP NOMOUNT;

Step 3 (to resolve Oracle Inconsistent Control Files Error ORA-00214 ):

Execute the following commands and you may change the path of control file if any.

alter system set control_files='C:\>oracle\product\10.20.0\db10g1\CONTROL01.CTL' scope=spfile;

show parameter control_files;


shutdown immediate;

startup mount;

recover database;

alter database open;

Step 4 (to resolve Oracle Inconsistent Control Files Error ORA-00214 ):

If the error of inconsistent control files continues repeat step 2 and 3. And change the control01.CTL to control02.CTL or  control03.CTL

No comments:

Post a Comment

Web Statistics