Delphix Products

Expand all | Collapse all

Upgrading vDBs from 11g2 to 19c

Jump to Best Answer
  • 1.  Upgrading vDBs from 11g2 to 19c

    Posted 10-05-2020 04:39:00 AM
    Hi everyone,

    Upgrading Oracle DB version for vDBs is explained in below documentation.

    Upgrading an Oracle VDB

    The documentation states that applying patch to an Oracle Home is quite straightforward operation which just requires an environment refresh.

    However, installing a new Oracle Home (for new Oracle version) requires different specifics.

    Can you please share your experiences with Oracle Upgrades? Specifically from 11 to 19?

    BR,

    ------------------------------
    Rahim Cetinel
    Solution Architect | Delphix Blackbelt
    ------------------------------


  • 2.  RE: Upgrading vDBs from 11g2 to 19c

    Posted 10-05-2020 05:29:00 AM
    Rahim,

    from a database perspective the process have to follow those steps :

    1/ install the new db binary (full installer can't just do an in place home upgrade)
    2/ custom pfile to the newer version (deprecated, minimal values according to the version of needed ...)
    3/ stop database from old home
    4/ start database in upgrade mode from new home
    5/ apply oracle upgrade scripts to new version

    BR,

    Mouhssine

    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------



  • 3.  RE: Upgrading vDBs from 11g2 to 19c

    Posted 10-05-2020 06:41:00 AM

    Hi Mouhssine,

     

    Thanks for the reply.

     

    From the DB perspective everything looks quite clear. When Delphix comes to the picture we need same clarity, that's why I have opened this thread as well as mentioned this in the Support Ticket to Delphix.

     

    Delphix has "Upgrade vDB" option in vDB GUI but the documentation does not clarify which steps to be performed before/after Oracle binary installation (as well as ASM, grid installations in the Target systems that will be performed by DBAs).

     

    BR,

    Rahim Cetinel

    Solution Architect | Delphix Blackbelt

    M:+905334112490  | Skype: rahim.cetinel

    www.accuras.com






  • 4.  RE: Upgrading vDBs from 11g2 to 19c

    Posted 10-05-2020 07:05:00 AM
    Hi Rahim,

    Got the point.

    Will try to give out a feedback on the by the end of my working hour. If no one answers the thread before.

    KR,

    Mouhssine


    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------



  • 5.  RE: Upgrading vDBs from 11g2 to 19c

    Posted 10-05-2020 11:38:00 AM
    Hi Rahim,

    May be you will see clear on it if you check this note https://support.delphix.com/Delphix_Virtualization_Engine/Oracle/Testing_an_Oracle_Upgrade_Using_Rewind_(KBA1772)

    The steps including delphix are :

    0/ Take backup sapshot before upgrade
    1/ Backup old version of spfile
    2/ Use favorite DB tool to upgrade (dbua, manual scipts ...)
    3/ Re-create the spfile using the new parameters recommended by Oracle for the upgrade
    4/ Once the upgrade is complete, update the ORACLE_HOME in the UI, by selecting the "Upgrade" option for the upgraded VDB
    5/ Set the new ORACLE_HOME for the upgraded vdb (you may need to refresh the environment first to refresh the OHs)
    6/ Stop / Start VDB
    7/ Take snapshot for the new upgraded VDB

    In case thinks fails go back to step 0

    Hope you have all informations summarized here

    Regards,

    Mouhssine

    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------



  • 6.  RE: Upgrading vDBs from 11g2 to 19c

    Posted 10-06-2020 06:24:00 AM

    Hi Mouhssine,

     

    Thanks a lot for the steps and explanation.


    Below is the steps explained in Delphix documentation:

    Creating a new ORACLE_HOME

    1. Refresh the environment from the Delphix Management application. Verify that the new ORACLE_HOME is picked up and displayed in the Databases tab as an ORACLE Installation.
    2. Stop the VDB from the command line (old ORACLE_HOME).
    3. Export ORACLE_HOME=(newORACLE_HOME). Follow Oracle documentation to patch the database.
    4. Copy the init.ora for that VDB in this new $ORACLE_HOME/dbs directory. The delphix_os user will need write permissions to this directory.
    5. If there are any database parameter changes, update the spfile located on the delphix mount base with those values.
    6.  Navigate to the Datasets view, select the VDB and then select the Configuration tab.  
    7. From the Actions menu (...) select  Upgrade to switch the ORACLE_INSTALLATION to the new one you just used and verified. 

     

    Adding these together, it looks like all the steps should be something like below

     

    1. [DBA] Install new ORACLE_HOME to the Target Host
    2. [Delphix Admin] Take backup sapshot on vDB before upgrade from Delphix GUI
    3. [Delphix Admin] Refresh the environment from Delphix GUI
    4. [DBA] Backup old version of spfile
    5. [DBA] Stop the VDB from the command line (old ORACLE_HOME)
    6. [DBA] Export ORACLE_HOME=(newORACLE_HOME). Follow Oracle documentation to patch the database.
    7. [DBA] Copy the init.ora for that VDB in this new $ORACLE_HOME/dbs directory. The delphix_os user will need write permissions to this directory.
    8. [DBA] If there are any database parameter changes, update the spfile located on the delphix mount base with those values.
    9. [DBA] Re-create the spfile using the new parameters recommended by Oracle for the upgrade
    10. [Delphix Admin] Once the upgrade is complete, update the ORACLE_HOME in the UI, by selecting the "Upgrade" option for the upgraded VDB
    11. [Delphix Admin] Set the new ORACLE_HOME for the upgraded vdb (you may need to refresh the environment first to refresh the OHs)
    12. [Delphix Admin] Stop / Start VDB
    13. [Delphix Admin] Take snapshot for the new upgraded VDB

     

     

    Can you please check the steps?

     

    BR,

    Rahim Cetinel

    Solution Architect | Delphix Blackbelt

    M:+905334112490  | Skype: rahim.cetinel

    www.accuras.com






  • 7.  RE: Upgrading vDBs from 11g2 to 19c
    Best Answer

    Posted 10-06-2020 11:10:00 AM
    Hi Rahim,

    Some final arrangments :D

    • 1. [DBA] Install new ORACLE_HOME to the Target Host
    • 2. [Delphix Admin] Take backup sapshot on vDB before upgrade from Delphix GUI
    • 3. [Delphix Admin] Refresh the environment from Delphix GUI
    • 4. [DBA] Backup old version of spfile to $ORACLE_HOME/dbs
    • 5. [DBA] Stop listener from the command line (old ORACLE_HOME)
    • 6. [DBA] Stop the VDB from the command line (old ORACLE_HOME)
    • 7. [DBA] Export ORACLE_HOME=(newORACLE_HOME). Follow Oracle documentation to patch the database.
    • 8. [DBA] Copy the init.ora for that VDB in this new $ORACLE_HOME/dbs directory. The delphix_os user will need write permissions to this directory.
    • 9. [DBA] If there are any database parameter changes, update the spfile located on the delphix mount base with those values.
    • 10. [DBA] Re-create the spfile using the new parameters recommended by Oracle for the upgrade
    • Steps that takes care of upgrading database oracle catalog and updates database metadata to the new version
    • 11. a [DBA] Stop listener from the command line (new ORACLE_HOME)
    • 11. b [DBA] Start in upgrade mode the VDB from the command line (new ORACLE_HOME), and run oracle scripts
    • 11. c  [DBA] run upgrade scripts ORACLE_HOME/bin/dbupgrade   from (new ORACLE_HOME
    • 11. d [DBA] Start database in normal mode, because it gets shutdown at the end of the upgrade process,
    • or
    • 11. a [DBA] Start listener from the command line (new ORACLE_HOME)
    • 11. b [DBA] use dbua (gui tool) to upgrade the VDB
    • 12. [Delphix Admin] Once the upgrade is complete, update the ORACLE_HOME in the UI, by selecting the "Upgrade" option for the upgraded VDB
    • 13. [Delphix Admin] Set the new ORACLE_HOME for the upgraded vdb (you may need to refresh the environment first to refresh the ORACLE_HOME)
    • 14. [Delphix Admin] Stop / Start VDB
    • 15. [Delphix Admin] Take snapshot for the new upgraded VDB
    Regards

    Mouhssine

    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------



  • 8.  RE: Upgrading vDBs from 11g2 to 19c

    Posted 10-07-2020 06:29:00 AM

    Hi Mouhssine,

     

    Thanks a lot for the final arrangements. This looks great!

     

     

     

    Rahim Cetinel

    Solution Architect | Delphix Blackbelt

    M:+905334112490  | Skype: rahim.cetinel

    www.accuras.com






  • 9.  RE: Upgrading vDBs from 11g2 to 19c

    Posted 10-07-2020 10:05:00 AM
    Hi Rahim,

    You are always welcome

    KR,

    Mouhssine


    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------