upgrade with dbua compatible parameter

4130935 wrote:

 

Hello

 

I just did an upgrade from 12.1 to 12.2 using dbua however I realized that compatible parameter is still set 12.1.0.2.0 although it was upgraded to 12.2

Why didnt dbua change this parameter ? Is it because the flashback was on ?

Oracle  did NOT change COMPATIBLE parameter because it assumed that since you explicitly set it (as opposed to taking Oracle default), that you wanted it set to 12.1.0.2 & left it for you to change it. Problem Exists Between Keyboard And Chair.

4130935 wrote:

 

Hi John,

 

Does it mean that any upgrades with dbua, the compatible parameter will always be same ? DBUA will never change that parameter

IMO, you are asking the WRONG question.

What does DBUA do when COMPATIBLE is NOT set to any value & the upgrade is performed?

4130935 wrote:

 

Compatible is set to 12.1.0.2

After the upgrade with dbua

It is still same.

 

I thought dbua will change it 12.2.0.1 once the upgrade is finished

Oracle & reality demonstrated that you thought wrongly.

Hi,

You should have spent little more time reading upgrade guide, it has well depth of information.

When to Set the COMPATIBLE Initialization Parameter in Oracle Database

When to Set the COMPATIBLE Initialization Parameter in Oracle Database

Oracle recommends increasing the COMPATIBLE parameter only after you have completed testing the upgraded database.

After the upgrade is complete, you can increase the setting of the COMPATIBLE initialization parameter to the maximum level for Oracle Database 12c. However, after you increase the COMPATIBLE parameter, you cannot subsequently downgrade the database.

Regards,

Yoonas

To downgrade, first decrease the COMPATIBLE parameter.

dvohra21 wrote:

 

To downgrade, first decrease the COMPATIBLE parameter.

What happens when a feature that exists in the higher version (& has been used)  does NOT exist in the lower version & attempt a downgrade?

What Is Oracle Database Compatibility?

Downgrading Oracle Database to an Earlier Release

6 Downgrading Oracle Database to an Earlier Release

For supported releases of Oracle Database, you can downgrade a database to the release from which you last upgraded. For example, if you recently upgraded from release 11.2.0.4 to Oracle Database 12c, and you did not change the compatible initialization parameter to 12.1 or higher, then you can downgrade to release 11.2.0.4. If your Oracle Database 12c is release 12.1.0.2, and you did not change the compatible initialization parameter to 12.1.0.2, then you can downgrade to release 12.1.0.1 and so forth.

Seems like not.

"You cannot downgrade a database once you have set the compatible initialization parameter to 12.1.0.2."