ORA-00201: control file version

ERROR: ORA-00201, ORA-00202

ORA-00201: control file version 12.2.0.0.0 incompatible with ORACLE version 11.2.0.0.0

ORA-00202: control file

$ srvctl start database -d KARDBPRD

PRCR-1079 : Failed to start resource ora.KARDBPRD.db

CRS-5017: The resource action "ora.KARDBPRD.db start" encountered the following error:

ORA-00201: control file version 12.2.0.0.0 incompatible with ORACLE version 11.2.0.0.0

ORA-00202: control file: '+DATA/KARDBPRD/controlfile/current.259.1024388699'

. For details refer to "(:CLSN00107:)" in "/apps/oracle/diag/crs/kardbprd.us.com/crs/trace/ohasd_oraagent_oracle.trc".

CRS-2674: Start of 'ora.KARDBPRD.db' on 'kardbprd.us.com' failed

SQL> startup

ORACLE instance started.

Total System Global Area 3.0266E+10 bytes

Fixed Size                 12214256 bytes

Variable Size            3623878656 bytes

Database Buffers         2.6575E+10 bytes

Redo Buffers               54894592 bytes

ORA-00201: control file version 12.2.0.0.0 incompatible with ORACLE version 11.2.0.0.0

ORA-00202: control file: '+DATA/KARDBPRD/controlfile/current.259.1024388699'

SOLUTION:

NOTE: If you just make a change manually in the init.ora file “*.compatible='12.2.0.0.0'” and create a spfile from init.ora file. It does not work in my case. I have to execute the command as follow.

SQL> startup

ORACLE instance started.

Total System Global Area 3.0266E+10 bytes

Fixed Size                 12214256 bytes

Variable Size            3623878656 bytes

Database Buffers         2.6575E+10 bytes

Redo Buffers               54894592 bytes

ORA-00201: control file version 12.2.0.0.0 incompatible with ORACLE version 11.2.0.0.0

ORA-00202: control file: '+DATA/KARDBPRD/controlfile/current.259.1024388699'

SQL> alter system set compatible='12.2.0.0.0' scope=spfile;

System altered.

SQL> shut immediate;

ORA-01507: database not mounted

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 3.0266E+10 bytes

Fixed Size                 12214256 bytes

Variable Size            3623878656 bytes

Database Buffers         2.6575E+10 bytes

Redo Buffers               54894592 bytes

Database mounted.

Database opened.

It Works now!