Downgrade database from Oracle 12.2.0.1 to Oracle 11.2.0.3 using catdwgrd.sq

[ssivaprasad]

Downgrade database from Oracle 12.2.0.1 to Oracle 11.2.0.3:


Like to know if any one successfully downgraded the database from version Oracle 12cR2 ( Release 2) to Oracle 11g Release 2 (11.2.0.3) using manual method of catdwgrd.sql.

Please share your views and inputs as we are unable to downgrade it successfully.

Refereed the

https://docs.oracle.com/en/database/...tml#GUID-CAD9…

How to Downgrade a 12.2 Non CDB Database to Previous Release (Doc ID 2193965.1)

[gandolf989]

You might want to start with, why should I downgrade from 12c to 11g.
If this is a tuning issue, take a look at these parameter and see if changing
them helps. Also if you pin plans, you should stop.

optimizer_adaptive_plans                                                  boolean              FALSE
optimizer_adaptive_reporting_only                                         boolean              TRUE
optimizer_adaptive_statistics                                             boolean              TRUE

[Bergen]

You might want to start with D-Bal Max and why should I downgrade from 12c to 11g.
If this is a tuning issue, take a look at these parameter and see if changing
them helps. Also if you pin plans, you should stop.

optimizer_adaptive_plans                                                  boolean              FALSE
optimizer_adaptive_reporting_only                                         boolean              TRUE
optimizer_adaptive_statistics                                             boolean              TRUE

I'd also like to know why someone would do this. Are there significant advantages in doing this?