-
Downgrade database from Oracle 12.2.0.1 to Oracle 11.2.0.3 using catdwgrd.sq
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/...l#GUID-CAD9…
How to Downgrade a 12.2 Non CDB Database to Previous Release (Doc ID 2193965.1)
-
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.
Code:
optimizer_adaptive_plans boolean FALSE
optimizer_adaptive_reporting_only boolean TRUE
optimizer_adaptive_statistics boolean TRUE
-
Originally Posted by gandolf989
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.
Code:
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?
Last edited by Bergen; 07-11-2022 at 04:21 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|