Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

19.20.0 Change compatible initialization parameter

rmattNov 29 2023

Hello,

I'm trying to change the compatible initialization parameter on version 19.20.0. Currently, it is set to 19.0.0 but I need to change it to 12.2.0. This is a brand-new install with no containers/PDBs just a single instance. I'm running this command -

ALTER SYSTEM SET COMPATIBLE = '12.2.0' SCOPE=SPFILE;

After a shutdown and startup, I get the error

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

I have googled this around but haven't found anything related to changing the compatible parameter. Generally, I'm a developer so I apologize if this is a silly question.

Thanks

This post has been answered by User_3ABCE on Nov 30 2023

Jump to Answer

Added on Nov 29 2023

#dba, #general-database-discussions

1 comment

770 views