Oracle on Linux and UNIX environment variables

The following table lists supported environment variables for Oracle databases on Linux or UNIX, for each BMC Database Automation activity:

Note

ASM and Listener variables are available only when ASM and Listener are configured.

Activity

Environment variables

Create Single Instance Oracle Database (Container or Regular)

GAC_{CUSTOM_FIELD}
GA_CDB
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_DBA_GROUP
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LISTENER_NAME
GA_LISTENER_PORT
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_OPER_GROUP
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_XML

Back to top

Create Pluggable Database

GAC_{CUSTOM_FIELD}
GA_ADMIN_USERNAME <PDB Admin User>
GA_DATABASE_LOCATION <PDB Datafile Location>
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_NUMBER_OF_PDBS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_XML

Back to top

Remove Single Instance Oracle Database

GAC_{CUSTOM_FIELD}
GA_CDB
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_XML

Back to top

Remove Pluggable Database

GAC_{CUSTOM_FIELD}
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_XML

Back to top

Move Pluggable Database

GAC_{CUSTOM_FIELD}
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_DESTINATION_DB_NAME
GA_DESTINATION_DB_ORACLE_HOME
GA_DESTINATION_DB_SID
GA_DESTINATION_DB_VERSION
GA_DESTINATION_INSTALL_GROUP
GA_DESTINATION_INSTALL_USER
GA_DESTINATION_ORACLE_BASE
GA_DESTINATION_PDB_NAME
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID

GA_XML

Back to top

Unplug Pluggable Database

GAC_{CUSTOM_FIELD}
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID

GA_XML

Back to top

Add Candidate Server

GAC_{CUSTOM_FIELD}
GA_ASM_INSTALL_USER
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_DIR
GA_DAGENT_VERSION
GA_DBA_GROUP
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_OPERATION_PRODUCT
GA_OPER_GROUP
GA_ORACLE_BASE
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_VERIFY_MODE
GA_XML

Back to top

Remove Candidate Server

GAC_{CUSTOM_FIELD}
GA_ASM_INSTALL_USER
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_DIR
GA_DAGENT_VERSION
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_OPERATION_PRODUCT
GA_ORACLE_BASE
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_VERIFY_MODE
GA_XML

Back to top

Create Single Instance Oracle Database on VCS

GAC_{CUSTOM_FIELD}
GAC_service_group
GA_CDB
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_DBA_GROUP
GA_DB_NAME
GA_ORACLE_BASE
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LISTENER_NAME
GA_LISTENER_PORT
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_ORACLE_BASE
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_OPER_GROUP
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_VCS_RESOURCE_GROUP
GA_XML

Back to top

Remove Single Instance Oracle Database on VCS

GAC_{CUSTOM_FIELD}
GA_CDB
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_XML

Back to top

Create Oracle Home

GAC_{CUSTOM_FIELD}
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_VERSION
GA_DBA_GROUP
GA_DB_ORACLE_HOME
GA_DB_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_OPER_GROUP
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE_PRESCRIPT
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_VAR_DIR
GA_XML

Back to top

Remove Oracle Home

GAC_{CUSTOM_FIELD}
GA_ASM_INSTALL_USER
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_VERSION
GA_DB_ORACLE_HOME
GA_DB_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_XML

Back to top

Create Oracle RAC Cluster

GAC_{CUSTOM_FIELD}
GA_ASM_DBA_GROUP
GA_ASM_INSTALL_USER
GA_ASM_OPER_GROUP
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_CLUSTER_NAME
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LISTENER_DBA_GROUP 2
GA_LISTENER_INSTALL_USER 2
GA_LISTENER_NAME 2
GA_LISTENER_OPER_GROUP 2
GA_LISTENER_ORACLE_HOME 2
GA_LISTENER_PORT 2
GA_LISTENER_VERSION 2
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_VAR_DIR
GA_XML

Back to top

Add Node to RAC

GAC_{CUSTOM_FIELD}
GA_ASM_DBA_GROUP
GA_ASM_INSTALL_USER
GA_ASM_OPER_GROUP
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_CLUSTER_NAME
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LISTENER_DBA_GROUP 2
GA_LISTENER_INSTALL_USER 2
GA_LISTENER_NAME 2
GA_LISTENER_OPER_GROUP 2
GA_LISTENER_ORACLE_HOME 2
GA_LISTENER_PORT 2
GA_LISTENER_VERSION 2
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_XML

Back to top

Create RAC Database

GAC_{CUSTOM_FIELD}
GA_ASM_INSTALL_USER
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_ORACLE_BASE
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_VERSION
GA_DBA_GROUP 1
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LISTENER_NAME
GA_LISTENER_PORT
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_OPER_GROUP 1
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_VAR_DIR
GA_XML

Back to top

Add Instance to RAC Database

GAC_{CUSTOM_FIELD}
GA_ASM_INSTALL_USER
GA_ORACLE_BASE
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_VERSION
GA_DBA_GROUP
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LISTENER_NAME
GA_LISTENER_PORT
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_OPER_GROUP
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_XML

Back to top

Remove Instance from RAC Database

GAC_{CUSTOM_FIELD}
GA_ASM_INSTALL_USER
GA_ORACLE_BASE
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_VERSION
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_XML

Back to top

Remove RAC Database

GAC_{CUSTOM_FIELD}
GA_ASM_INSTALL_USER
GA_ORACLE_BASE
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_CDB3
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_VERSION
GA_DB_NAME
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_XML

Back to top

Remove Node from Cluster

GAC_{CUSTOM_FIELD}
GA_ASM_INSTALL_USER
GA_ORACLE_BASE
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_CLUSTER_NAME
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LISTENER_INSTALL_USER
GA_LISTENER_ORACLE_HOME
GA_LISTENER_VERSION
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_XML

Back to top

Remove Cluster

GAC_{CUSTOM_FIELD}
GA_ASM_INSTALL_USER
GA_ORACLE_BASE
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_CLUSTER_NAME
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LISTENER_INSTALL_USER
GA_LISTENER_ORACLE_HOME
GA_LISTENER_VERSION
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_XML

Back to top

Upgrade Oracle RAC

GAC_{CUSTOM_FIELD}
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_VERSION_FROM
GA_CRS_VERSION_TO
GA_DAGENT_VERSION
GA_DB_ORACLE_HOME
GA_DOMAIN
GA_HOME_TYPE
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PDB_NAME
GA_PERL
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_XML

Back to top

Upgrade Oracle Database

GAC_{CUSTOM_FIELD}
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_DB_NAME 
GA_DB_ORACLE_HOME
GA_DB_SID
GA_DB_SID_LIST
GA_DB_VERSION_FROM
GA_DB_VERSION_TO
GA_DOMAIN
GA_HOME_TYPE
GA_INSTALL_USER (UNIX only)
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_XML

Back to top

Upgrade Oracle ASM

GAC_{CUSTOM_FIELD}
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_DB_ORACLE_HOME
GA_DB_VERSION_FROM
GA_DB_VERSION_TO
GA_DOMAIN
GA_HOME_TYPE
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_OPERATION_PRODUCT
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_VERIFY_MODE
GA_XML

Back to top

Create Restart Cluster

GAC_{CUSTOM_FIELD}
GA_ASM_DBA_GROUP
GA_ASM_INSTALL_USER
GA_ASM_OPER_GROUP
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LISTENER_DBA_GROUP
GA_LISTENER_INSTALL_USER
GA_LISTENER_NAME
GA_LISTENER_OPER_GROUP
GA_LISTENER_ORACLE_HOME
GA_LISTENER_PORT
GA_LISTENER_VERSION
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_VAR_DIR
GA_XML

Back to top

Remove Restart Cluster

GAC_{CUSTOM_FIELD}
GA_ASM_INSTALL_USER
GA_ASM_ORACLE_HOME
GA_ASM_VERSION
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_CRS_CLUSTER_NAME
GA_CRS_INSTALL_USER
GA_CRS_ORACLE_HOME
GA_CRS_VERSION
GA_DAGENT_VERSION
GA_DOMAIN
GA_INSTALL_GROUP
GA_INSTALL_USER
GA_JOB_ID
GA_LISTENER_INSTALL_USER
GA_LISTENER_ORACLE_HOME
GA_LISTENER_VERSION
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_ORACLE_BASE
GA_PDB_NAME
GA_PERL
GA_RUN_STATE
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_VAR_DIR
GA_XML

Back to top

Apply Patch to Oracle RAC DBMS Home

GAC_{CUSTOM_FIELD}
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_ORACLE_BASE
GA_DB_ORACLE_HOME
GA_DB_SID
GA_HOME_TYPE
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_NODE_NUM
GA_OPATCH_APPLY_METHOD
GA_OPATCH_ID
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PATCH_LOCATION
GA_PDB_NAME
GA_PERL
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_XML

Back to top

Apply Patch to Oracle RAC CRS Home

GAC_{CUSTOM_FIELD}
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_ORACLE_BASE
GA_DB_ORACLE_HOME
GA_HOME_TYPE
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_NODE_NUM
GA_OPATCH_APPLY_METHOD
GA_OPATCH_ID
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PATCH_LOCATION
GA_PDB_NAME
GA_PERL
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_XML

Back to top

Apply Patch to Oracle Single Instance Database

GAC_{CUSTOM_FIELD}
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_ORACLE_BASE
GA_DB_ORACLE_HOME
GA_DB_SID
GA_HOME_TYPE
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_NODE_NUM
GA_OPATCH_APPLY_METHOD
GA_OPATCH_ID
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PATCH_LOCATION
GA_PDB_NAME
GA_PERL
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_XML

Back to top

Rollback Patch on Oracle RAC DBMS Home

GAC_{CUSTOM_FIELD}
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_ORACLE_BASE
GA_DB_ORACLE_HOME
GA_DB_SID
GA_HOME_TYPE
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_NODE_NUM
GA_OPATCH_APPLY_METHOD
GA_OPATCH_ID
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PATCH_LOCATION
GA_PDB_NAME
GA_PERL
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_XML

Back to top

Rollback Patch on Oracle RAC CRS Home

GAC_{CUSTOM_FIELD}
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_ORACLE_BASE
GA_DB_ORACLE_HOME
GA_HOME_TYPE
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_NODE_NUM
GA_OPATCH_APPLY_METHOD
GA_OPATCH_ID
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PATCH_LOCATION
GA_PDB_NAME
GA_PERL
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_XML

Back to top

Rollback Patch on Oracle Single Instance Database

GAC_{CUSTOM_FIELD}
GA_CLARITY_USER
GA_CLARITY_USERIP
GA_DAGENT_VERSION
GA_ORACLE_BASE
GA_DB_ORACLE_HOME
GA_DB_SID
GA_HOME_TYPE
GA_INSTALL_USER
GA_JOB_ID
GA_LOG_DIR
GA_MANAGER_ADDRESS
GA_NODE_NUM
GA_OPATCH_APPLY_METHOD
GA_OPATCH_ID
GA_OPERATION
GA_OPERATION_DESCRIPTION
GA_PATCH_LOCATION
GA_PDB_NAME
GA_PERL
GA_SCRIPT_DIR
GA_SUBJOB_ID
GA_SUBPATCH_COUNT (Applicable for version 8.9.01 and later)
GA_SUBPATCH_LOCATION (Applicable for version 8.9.01 and later)
GA_SUBPATCH_SERIAL (Applicable for version 8.9.01 and later)
GA_XML

Back to top

1 The GA_DBA_GROUP and GA_OPER_GROUP variables are not set when a RAC database is created in a shared home.

2 These variables are set in the following scenarios:

  • For Create 10gR2 RAC Cluster or Add Node to RAC cluster, the variables are set.
  • For Create 11gR2 RAC Cluster or Add Node to RAC cluster, the variables are set in the Create Cluster Job. The variables are not set in the Add Node to Cluster job.
  • For Create 12C RAC Cluster or Add Node to RAC cluster, the variables are not set in the Create Cluster Job or in the Add Node to Cluster job.

3 This variable is only set for Oracle 12c.

Was this page helpful? Yes No Submitting... Thank you

Comments