How To Change Oracle Compatible Parameter in Primary and Standby Environments?

 

Your Primary and Physical Standby are running 12.2.0.1 and you need to change the COMPATIBLE parameter to 19.0.0.0 on both the databases.

Let's assume the current COMPATIBLE setting on both Primary and Standby databases is at 12.2.0.1.

STEPS:-

The value of COMPATIBLE parameter on Standby should always be higher or equal to the value of COMPATIBLE on Primary.

In order to change the COMPATIBLE parameter, make the changes in Standby first and then on Primary.

Steps to Raise the COMPATIBLE Parameter on the Standby

1. Change the value of the compatible parameter on standby

SQL> ALTER SYSTEM SET COMPATIBLE= ’19.0.0.0’ SCOPE=SPFILE;

If you are using pfile, then edit pfile and change the value of the parameter
*. COMPATIBLE= '19.0.0.0'

2. Shutdown and Restart the standby database in mount stage

3. Restart Managed recovery process.

Steps to Raise the COMPATIBLE Parameter on the Primary

1. Perform a backup of your database before you raise the COMPATIBLE initialization parameter (optional).

2. If you are using a server parameter file, then complete the following steps:

a. Update the server parameter file to set or change the value of the COMPATIBLE initialization parameter. For example, to set the COMPATIBLE initialization parameter to 19.0.0.0, issue the following statement:

SQL> ALTER SYSTEM SET COMPATIBLE = '19.0.0.0' SCOPE=SPFILE;

b. Shut down and restart the database.

3. If you are using an initialization parameter file, then complete the following steps:

a. Shut down the database if it is running:

SQL> SHUTDOWN IMMEDIATE;

b. Edit the initialization parameter file to set or change the value of the COMPATIBLE initialization parameter.

For example, to set the COMPATIBLE initialization parameter to 19.0.0.0, enter the following in the initialization parameter file:

COMPATIBLE = 19.0.0.0

c. Start the database using STARTUP.