1. Cloud Control Database Lifecycle Management Administrator's Guide
  2. Database Maintenance: Updates (Patching) and Upgrades
  3. Database Updates and Upgrades Using Fleet Maintenance
  4. Update Operations
  5. Use of Oracle Home Path Variables

Use of Oracle Home Path Variables

Starting with Enterprise Manager 13.5 Release 15 (13.5.0.15) you can use predefined variables for an Oracle Home path, simplifying your EM CLI and REST API Fleet Maintenance operations.

The following is a list of variables available in Enterprise Manager 13.5 for Oracle Home path definitions. You can specify variable name using the format %<variable name>%.

Table 18-1 Variable definitions for Oracle Home Path

Variable Implementation Comments
ORACLE_BASE Retrieves the Oracle Base location for the target from EM repository using property name as ADR_BASE.
Examples:
  • Database deployment:
    %ORACLE_BASE%/19.0.0/dbhome
  • Grid deployment:
    %ORACLE_BASE%/../19.0.0/grid
 The Oracle Grid Infrastructure Oracle base should not contain the Oracle Grid Infrastructure binaries for an Oracle Grid Infrastructure for a cluster installation. Permissions for the file path to the Oracle Grid Infrastructure binary home are changed to root during installation.
OH_PARENT_DIR Retrieves the Oracle Home location for the target from EM repository using property name as OracleHome.
Examples:
  • Database deployment: 
    %OH_PARENT_DIR%/dbhome_1
  • Grid deployment:
    %OH_PARENT_DIR%/gridhome
 N/A
VERSION Retrieve the version value from DB_GI_DEFINITIONS table.
Examples:
  • Database deployment: 
    %ORACLE_BASE%/%VERSION%/dbhome
  • Grid deployment:
    %ORACLE_BASE%/../%VERSION%/gridhome
 N/A
VERSION_NAME Retrieves the name value from DB_GI_VERSIONS.
Examples:
  • Database deployment: 
    %ORACLE_BASE%/%VERSION_NAME%/dbhome
  • Grid deployment:
    %ORACLE_BASE%/../%VERSION_NAME%/gridhome
 N/A
U This optional variable allows you to install the same product more than once in the same Oracle base directory.
Examples:
  • Database deployment: 
    %ORACLE_BASE%/%VERSION%/dbhome%U%
  • Grid deployment:
    %ORACLE_BASE%/../%VERSION%/grid%U%
 This variable is to be used only for bulk deployment. It is recommended to use this variable when there are several Oracle Homes in the same environment allowing you to update all in a single go.

Note:

Multiple Home deployment in parallel on the same host is currently not supported for Windows based Enterprise Manager Deployments

Note:

For security purposes, the Oracle Home or Grid Home path folder should not contain binaries and data files of the existing home.

Table 18-2 Support for Variables in the Working Directory

Variables Implementation Comments
emStageDir You can manually update the agent property file with the following commands:
AGENT_HOME/agent_inst/sysman/config/emd.properties and run emctl reload
from
AGENT_HOME/agent_13.5.0.0.0/bin
 N/A