Pages

Thursday, September 10, 2020

ORA-00201: control file version 18.0.0.0.0 incompatible with ORACLE version 11.2.0.0.0 - NetWeaver

 

Problem:

ORA-00201: control file version 18.0.0.0.0 incompatible with ORACLE version11.2.0.0.0


Solution:

a. Reset COMPATIBLE parameter by SQL> ALTER SYSTEM SET COMPATIBLE = '18.0.0' SCOPE=SPFILE;

b. Then restart database.
        SQL> SHUTDOWN IMMEDIATE

        SQL> STARTUP


Note : SAP Supported Values list all values that are supported for SAP for the given Oracle version.


Oracle Database Release SAP Default Value         SAP Supported Value(s)
11.2.0.1 '11.2.0' (*) '11.2.0' (*)

11.2.0.2 '11.2.0' (*) '11.2.0' (*)
'11.2.0.2' '11.2.0.2'

11.2.0.3 '11.2.0' (*) '11.2.0' (*)
'11.2.0.2' '11.2.0.2'
'11.2.0.3'

11.2.0.4 '11.2.0' (*) '11.2.0' (*)
'11.2.0.2' '11.2.0.2'
'11.2.0.3'
'11.2.0.4'

12.1.0.2 '12.1.0.2.0' '12.1.0.2'
'12.1.0.2.0'

12.2.0.1 '12.2.0.1.0' '12.2.0.1.0'

18.X.Y (18c) '18.0.0' '18.0.0'

19.X.Y (19c) '19.0.0' '19.0.0'

(*) Value COMPATIBLE='11.2.0' is only supported for databases on file system, not for databases in ASM

No comments:

Post a Comment