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

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

  1. #1
    Join Date
    Mar 2018

    Downgrade database from Oracle to Oracle using catdwgrd.sq

    Downgrade database from Oracle to Oracle

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

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

    Refereed the


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

  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    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
    this space intentionally left blank

  3. #3
    Join Date
    Sep 2018
    I'd also like to know why someone would do this. Are there significant advantages in doing this?

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