Patching a Hybrid DR Deployment

Not Oracle Cloud InfrastructureNot Oracle Cloud at Customer This topic does not apply to Oracle Cloud Infrastructure or to Oracle Cloud at Customer.

You cannot use the Oracle Database Classic Cloud Service console or the patch subcommand of the dbaascli utility to patch the on-premises database in your Hybrid DR deployment. However, you can use the tools to patch the database on the cloud compute node in your Hybrid DR deployment.

To apply quarterly patches to the databases in your Hybrid DR deployment:

  1. Ensure that the on-premises database is up-to-date with patches:
    1. For the April PSU, download one of the following files:
      • From Chicago: https://storage.us2.oraclecloud.com/v1/dbcsswlibp-usoracle29538/dbaas_patch/dbcs_hdg_onprem/apr2017/hdg_patches.zip

      • From Slough: https://a88717.storage.oraclecloud.com/v1/Storage-a88717/dbaas_patch/dbcs_hdg_onprem/apr2017/hdg_patches.zip

    2. For the July PSU, download one of the following files:
      • From Chicago: https://storage.us2.oraclecloud.com/v1/dbcsswlibp-usoracle29538/dbaas_patch/dbcs_hdg_onprem/jul2017/hdg_patches.zip

      • From Slough: https://a88717.storage.oraclecloud.com/v1/Storage-a88717/dbaas_patch/dbcs_hdg_onprem/jul2017/hdg_patches.zip

    3. Unzip the downloaded PSU file and follow the instructions in the README file to install the patch and execute any required scripts.
  2. Patch the database on the cloud compute node and then run the post-install script:
    1. Use the Oracle Database Classic Cloud Service console or the patch subcommand of the dbaascli utility. See Applying a Patch for details.
    2. Connect as the oracle user to the compute node.
    3. Run the post-install script:
      • For Oracle Database 12c:

        $ datapatch -verbose
      • For Oracle Database 11g:

        $ cd $OH/rdbms/admin
        $ sqlplus / as sysdba
        SQL> @@catbundle.sql psu apply
        SQL> exit;
    4. Disconnect from the compute node.
After applying the patch to the databases in the Hybrid DR deployment, confirm appropriate application of the patch .