Upgrading or Changing ORACLE HOME for vPDB or PDB dSource (KBA1799)

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

KBA

KBA#1799

Updating Oracle Home Data Stored in the Continuous Data Engine

After cloning an Oracle Home to carry out Patch Set Updates (PSU) or upgrading an Oracle Home, it is possible to update the Oracle Home data stored in Delphix either via the GUI or via the CLI. This document will outline the method for changing it via the CLI

Applicable Delphix Versions

Click here to view the versions of the Delphix engine to which this article applies

Major Release	All Sub Releases
6.0	6.0.x.x and later

Resolution

To upgrade the ORACLE_HOME after PSU for a dSource CDB/PDB:

Clone the new ORACLE_HOME.
Run an environment refresh from the Delphix Engine and make sure the new ORACLE_HOME shows under the Database tab for the environment.
Patch the new ORACLE_HOME as per Oracle instructions.
Upgrade the CDB using the CLI as an admin user. In the below example a 12c database is upgraded to 19c

Example Procedure to Upgrade the CDB Using the CLI:

Connect to the engine via ssh with an admin user

ssh admin@engine-hostname

List the available sources

engine-hostname> source
engine-hostname source> ls
Objects
NAME                  CONTAINER         VIRTUAL
12C_NCDB              12C_NCDB          false
GLDCOPY               GLDCOPY           true
12CTO19C              12CTO19C          true

Select the required source and upgrade

engine-hostname source> select "12CTO19C"
engine-hostname source '12CTO19C'> upgrade

Edit the source config

engine-hostname source '12CTO19C' upgrade *> edit sourceConfig

List the available parameters

engine-hostname source '12CTO19C' upgrade sourceConfig *> ls

Properties
    type: MSSqlAvailabilityGroupDBConfig                
    name: (unset)
    databaseName: (unset)
    discovered: (unset)
    environmentUser: (unset)
    linkingEnabled: true
    mirroringState: NONE
    namespace: (unset)
    recoveryModel: SIMPLE
    reference: (unset)
    repository: (unset)

Update to the required parameters

engine-hostname source '12CTO19C' upgrade sourceConfig *> set type=OracleSIConfig
engine-hostname source '12CTO19C' upgrade sourceConfig *> set environmentUser=ORCL1914TGT/oracle
engine-hostname source '12CTO19C' upgrade sourceConfig *> set repository=ORCL1914TGT/'/u01/app/oracle/product/19.14.0.0/dbhome_1'

Commit the changes

engine-hostname source '12CTO19C' upgrade sourceConfig *> commit

    Dispatched job JOB-4442
    SOURCE_UPGRADE job started for "12CTO19C".
    SOURCE_UPGRADE job for "12CTO19C" completed successfully

Note : ORCL1914TGT is the environment name

Now the dSource PDB and CDB should both show the correct ORACLE_HOME on the Datasets page (Configuration tab)

You can also see the PDB/vPDB with a new oracle home on the Environment page: select environment > databases > check VDB/vPDB under new oracle home.

For non-CDB/PDB dSources use the following documentation to upgrade Oracle in Delphix:
https://cd.delphix.com/docs/latest/upgrading-dsources-after-an-oracle-upgrade

For non-CDB/PDB VDBs use the following documentation to upgrade Oracle in Delphix:
https://cd.delphix.com/docs/latest/upgrading-an-oracle-vdb-linked-cdb-or-a-vcdb

KBA

Updating Oracle Home Data Stored in the Continuous Data Engine

Applicable Delphix Versions

Resolution

Example Procedure to Upgrade the CDB Using the CLI:

Related Articles