Skip to main content
Delphix

Updating Oracle Grid Home For a Delphix Managed Environment (KBA1413)

 

Troubleshooting Upgrade for Oracle Grid Home

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

To upgrade Oracle for Home Grid

  1. Locate the Environment using the Delphix Engine Admin CLI (or equivalent login)
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.  Verify the updated value by checking 'ls' output for the environment, or using 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

For Versions 5.1.x and Below:

For Versions 5.2.x and Higher:

Applicable Delphix Versions

This article applies to the following versions of the Delphix Engine:

Major Release

 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

5.1

5.1.0.0, 5.1.1.0, 5.1.2.0, 5.1.3.0, 5.1.4.0, 5.1.5.0, 5.1.5.1, 5.1.6.0, 5.1.7.0, 5.1.8.0, 5.1.8.1, 5.1.9.0, 5.1.10.0

5.0

5.0.1.0, 5.0.1.1, 5.0.2.0, 5.0.2.1, 5.0.2.2, 5.0.2.3, 5.0.3.0, 5.0.3.1, 5.0.4.0, 5.0.4.1 ,5.0.5.0, 5.0.5.1, 5.0.5.2, 5.0.5.3, 5.0.5.4