Upgrading or Changing ORACLE HOME for vPDB or PDB dSource (KBA1799)
KBA
KBA#1799
Troubleshooting vPDB or PDB dSources
Currently the functionality to change the ORACLE_HOME due to patching or otherwise does not exist in the Delphix Administration application (GUI) for vPDB or PDB dSources. If you navigate to Datasets, select a vPDB or a PDB dSource, then select the Ellipsis from the upper right hand corner, and select Upgrade, nothing changes.
Applicable Delphix Versions
- Click here to view the versions of the Delphix engine to which this article applies
-
Major Release All Sub Releases 5.3
5.3.0.0 5.2
5.2.2.0, 5.2.2.1, 5.2.3.0, 5.2.4.0, 5.2.5.0, 5.2.5.1, 5.2.6.0, 5.2.6.1
Resolution
To upgrade the ORACLE_HOME after PSU for 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 per Oracle instructions.
- Upgrade the CDB using the CLI as a delphix_admin user.
Example using my internal RAC dSource CDB/PDB named CDOMLOSR9FB7/CDOMLOSR9FB7PDB1:
First make note of the existing sourceconfig settings for the CDB:
sd-dEngine5240.dcenter> sourceconfig
sd-dEngine5240.dcenter sourceconfig> ls
Objects
NAME REPOSITORY LINKINGENABLED
boaCDB '/u01/app/ora12201/product/12.2.0/dbhome_1' true
CDOMLOSR9FB7 '/u01/app/oracle/product/12.2.0.1/dbhome_patch' true
boaPDB '/u01/app/ora12201/product/12.2.0/dbhome_1' true
CDOMLOSR9FB7PDB1 '/u01/app/oracle/product/12.2.0.1/dbhome_patch' true
Operations
create
sd-dEngine5240.dcenter sourceconfig> select CDOMLOSR9FB7
sd-dEngine5240.dcenter sourceconfig 'CDOMLOSR9FB7'> ls
Properties
type: OracleRACConfig
name: CDOMLOSR9FB7
cdbType: ROOT_CDB
credentials:
type: PasswordCredential
password: ********
crsDatabaseName: CDOMLOSR9FB7
databaseName: CDOMLOSR
discovered: true
environmentUser: acrac2/oracle
instances:
0:
type: OracleRACInstance
instanceName: CDOMLOSR9FB71
instanceNumber: 1
node: acrac1
1:
type: OracleRACInstance
instanceName: CDOMLOSR9FB72
instanceNumber: 2
node: acrac2
linkingEnabled: true
nonSysCredentials: (unset)
nonSysUser: (unset)
reference: ORACLE_RAC_CONFIG-70
repository: '/u01/app/oracle/product/12.2.0.1/dbhome_patch'
services:
0:
type: OracleService
discovered: true
jdbcConnectionString: jdbc:oracle:thin:@(DESCRIPTION=(ENABLE=broken)(ADDRESS=(PROTOCOL=tcp)(HOST=acrac1-scan.dcenter.delphix.com)(PORT=1521))(CONNECT_DATA=(UR=A)(SERVICE_NAME=CDOMLOSR9FB7)))
uniqueName: CDOMLOSR9FB7
user: c##delphix
Perform the upgrade from source using the correct sourceConfig type and repository for the CDB:
sd-dEngine5240.dcenter source> select CDOMLOSR9FB7
sd-dEngine5240.dcenter source 'CDOMLOSR9FB7'> upgrade
sd-dEngine5240.dcenter source 'CDOMLOSR9FB7' upgrade *> set sourceConfig.type=OracleRACConfig
sd-dEngine5240.dcenter source 'CDOMLOSR9FB7' upgrade *> set sourceConfig.repository=acrac2/'/u01/app/oracle/product/12.2.0.1/dbhome_1'
sd-dEngine5240.dcenter source 'CDOMLOSR9FB7' upgrade *> commit;
Dispatched job JOB-1736
SOURCE_UPGRADE job started for "CDOMLOSR9FB7".
SOURCE_UPGRADE job for "CDOMLOSR9FB7" completed successfully.
Now the dSource PDB and CDB should both show the correct ORACLE_HOME under datasets->Configuration tab.
To update the ORACLE_HOME for the vCDB/vPDB, you will perform an update of the sourceConfig repository on the vCDB. Example below is for boaCDB/boaPDB vCDB/vPDB.
1. Clone and patch the new ORACLE_HOME on the target environment.
2. Refresh the environment in Delphix to pick up the new ORACLE_HOME.
3. Disable the vPDB from the Delphix GUI using Datasets->Disable
4. Login to the Delphix CLI using a delphix_admin account.
sd-dEngine5240.dcenter> cd sourceconfig
sd-dEngine5240.dcenter sourceconfig> select boaCDB
sd-dEngine5240.dcenter sourceconfig 'boaCDB'> update
sd-dEngine5240.dcenter sourceconfig 'boaCDB' update *> set repository='/u01/app/ora12201/product/12.2.0/dbhome_patch'
sd-dEngine5240.dcenter sourceconfig 'boaCDB' update *> commit
5. Enable the vPDB from Datasets->Enable.
Related Articles
- For non-CDB/PDB dSources use the following documentation to upgrade Oracle in Delphix:
https://docs.delphix.com/docs/delphi...oracle-upgrade
- For non-CDB/PDB VDBs use the following documentation to upgrade Oracle in Delphix:
https://docs.delphix.com/docs/delphi...-an-oracle-vdb