DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Mar 2018
    Posts
    2

    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)

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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

  3. #3
    Join Date
    Sep 2018
    Posts
    1
    Quote Originally Posted by gandolf989 View Post
    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
  •  


Click Here to Expand Forum to Full Width