Skip to main content
Delphix

How to Update Oracle Grid Home in a Delphix-managed Environment

Applicable Delphix Versions

  • 5.1
  • 5.0

Issue

During an Oracle upgrade, refreshing an Environment will generally discover new Oracle installations, allowing for virtual database (VDB) or dSource upgrade to be handled through the UI. However, if the Oracle Grid home is changed, due to an Oracle upgrade, the crsClusterHome parameter will need to be updated manually through command line (CLI).

Resolution

1. Through the delphix_admin CLI (or equivalent login), locate the Environment in question.

yourengine> /environment; ls

Objects
NAME            DESCRIPTION
seanora12src    
000.00.000.0  

Children
oracle
user
windows

Operations
create

yourengine> select 000.00.000.0 
yourengine environment '000.00.000.0'> ls
Properties
    type: OracleCluster
    name: 000.00.000.0
    clusterUser: ora12201
    crsClusterHome: /u01/app/112/grid 
    crsClusterName: 
    description: 
    enabled: true
    primaryUser: ora12201
    reference: ORACLE_CLUSTER-1
    remoteListener: (unset)
    scan: (unset)
    scanManual: false
    version: 


Operations
delete
update
disable
enable
refresh

2. Update the crsClusterHome parameter to reflect the updated location, and commit the change.

yourengine environment '000.00.000.0'> update
yourengine environment '000.00.000.0' update *> set crsClusterHome=/u01/app/12.2.0/grid
yourengine environment '000.00.000.0' update *> commit
    Dispatched job JOB-15
    ENVIRONMENT_UPDATE job started for "000.00.000.0".
    ENVIRONMENT_UPDATE job for "000.00.000.0" completed successfully.

3.  The updated value can be confirmed by checking 'ls' output for the environment, or in the GUI.

yourengine environment '000.00.000.0'> ls
Properties
    type: OracleCluster
    name: 000.00.000.0
    clusterUser: ora12201
    crsClusterHome: /u01/app/12.2.0/grid
    crsClusterName: bbrac3638
    description: 
    enabled: true
    primaryUser: ora12201
    reference: ORACLE_CLUSTER-1
    remoteListener: (unset)
    scan: bbrac3638-scan
    scanManual: false
    version: 12.2.0.1.0