Thursday, March 15, 2018

oracle database error during DB startup


Issue:
I have faced some issue  & DB did not open when I restart the database using Pfile  and got the below error.

SQL> startup pfile='initORA1.ora' mount;
ORACLE instance started.

Total System Global Area 2.5655E+10 bytes
Fixed Size                  2258352 bytes
Variable Size            2617248336 bytes
Database Buffers         2.3018E+10 bytes
Redo Buffers               16904192 bytes
ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version
11.1.0.0.0
ORA-00202: control file: '/appdb1/oradata/oradb1.redoctrl01/control01.ctl'

Cause:
looks like the compatible  parameter value different in P & SP file

Solution:
corrected the Pfile according to SP file compatible value  and restarted the database and it opened without any issues.

No comments:

Post a Comment