This appendix displays sample property files for out-of-box RuntimeData templates. The following templates are described:
Sample properties file with Mandatory parameters for RAC provisioning procedure using Gold Image
Sample properties file with Mandatory parameters for RAC provisioning procedure using a Reference Installation
Sample properties file with Mandatory parameters for RAC Extend cluster procedure
Sample properties file with Mandatory parameters for RAC Delete cluster procedure
Sample properties file with Mandatory parameters for RAC Descale cluster procedure
Sample properties file with Mandatory parameters for all the patching procedures
The following section describes in detail the sample properties file with mandatory parameters for RAC provisioning procedure using Gold Image:
# --------------------------------------------------
# Properties file for Rac Provisioning on Linux with # 1. Gold Image as source # 2. ASM # 3. DB Instance # 4. No Mirrors # 5. No Save to Software Library ## Testcase Name: CRSASMRAC_GOLD_PROV ## Variables and values to be replaced in the template RuntimeDataXML file ## Format: # ------- # Variable=Value # --------------------------------------------------
# Mandatory Parameters #-----------------------------
CRS_COMPONENT=<CRS gold image location in the Software Library Eg: Components/CRS GOLD IMAGE>RAC_COMPONENT=<RAC gold image location in the Software Library Eg: Components/CRS GOLD IMAGE>ASM_COMPONENT=<ASM gold image location in the Software Library Eg: Components/CRS GOLD IMAGE>ORACLE_HOME_BASE_LOC=<Base installation directory for installation of the CRS, RAC and ASM>CLUSTER_ORACLE_HOME_NAME=<CRS Oracle Home Name. Eg: OraCrs10g_home>CLUSTER_NAME=<CRS Name. Eg: crs>DB_ORACLE_HOME_NAME=<RAC DB Oracle Home Name. Eg: OraRAC10g_home1>ASM_ORACLE_HOME_NAME=<ASM Oracle Home Name. Eg: OraASM10g_home1>
PUB_NODELIST_VALUE=<Comma separated list of nodes present in the Cluster with fully qualified host names. Eg: node1.example.com, node2.example.com>PRIV_NODELIST_VALUE=<Comma separated list of private fully qualified host names of the nodes present in the Cluster. Eg: node1-i.example.com, node2-i.example.com >VIRTUAL_NODELIST_VALUE=<Comma separated list of fully qualified virtual host names of the nodes present in the Cluster. Eg: node1-vip.example.com, node2-vip.example.com >
OCR_PARTITION_VALUE=<OCR Location. Eg:/store/storage/ocr>VDSK_PARTITION_VALUE=<VDISK Locations. Eg: /store/storage/vdsk>ORADATA_LOC=<Shared OraData Location. Eg:/store/storage/oradata>INSTALL_USER=<Target Credentials. Eg: oracle>USER_PASSWORD=<Target Credentials. Eg: oracle>
DEVICES=<Device List. Eg: ,node1.example.com:/scratch/nfs/src/nfs3%1320%NFS%/scratch/nfs/des/nfs3%NFS,,>
DB_SID=<The Cluster Database Name. Eg: racdb>
ASM_RED=<ASM Redundancy Type. Eg: NORMAL>ASM_DISK_LIST=<Comma separated ASM Disk List. Eg:/store/asmdisks/asm1,/store/asmdisks/asm2,/store/asmdisks/asm3>ASM_DISK_STRING=<ASM Disk Search String. Eg:/store/asmdisks/*>
CENTRAL_INVENTORY_LOCATION=<Oracle Inventory Location. Eg:/scratch/rac/oraInventory>
NICS=<Network Interface List in a specific Format. Eg:eth0:152.68.196.0:PUBLIC,eth1:152.68.80.0:PRIVATE>PRIV_IP_LIST_VALUE=<Comma separated private IPs. Eg:152.68.81.85,152.68.81.86>
The following section describes in detail the sample properties file with mandatory parameters for RAC provisioning procedure using a reference installation:
# -------------------------------------------------- # Properties file for Rac Provisioning on Linux with # 1. Installed Home as source # 2. ASM # 3. DB Instance # 4. No Mirrors # 5. No Save to Software Library ## Test case Name: CRSASMRAC_INSHOME_PROV ## Variables and values to be replaced in the template RuntimeDataXML file ## Format: # ------- # Variable=Value # -------------------------------------------------- #Mandatory Parameters #-----------------------------
REF_HOST_NAME=<Fully qualified host name of the reference node Eg:racnode2.example.com>WORK_DIR_LOC=<Working Directory Location. Eg: /tmp>HOST_USER=<Target Credentials for the Reference Host Eg:oracle>HOST_PASSWD=<Target Credentials for the Reference Host Eg:oracle>
SOURCE_CRS_HOME_LOC=<Reference CRS Oracle Home location /scratch/NewHomes/OraCrs10g_home1>SOURCE_RAC_HOME_LOC=<Reference RAC Oracle Home location/scratch/NewHomes/OraDB10g_home1>SOURCE_ASM_HOME_LOC=<Reference ASM Oracle Home location/scratch/NewHomes/OraAsm10g_home1>
ORACLE_HOME_BASE_LOC=<Location for cluster installation /scratch/app/oracle>CLUSTER_ORACLE_HOME_NAME=<New CRS Oracle Home Name Eg:OraCrs10g_home>CLUSTER_NAME=<New CRS Cluster name Eg:mycrs>DB_ORACLE_HOME_NAME=<New RAC Cluster name Eg:OraDB10g_home>ASM_ORACLE_HOME_NAME=<New ASM Cluster name Eg:OraAsm10g_home>
PUB_NODELIST_VALUE=<Comma separated list of nodes present in the Cluster with fully qualified host names. Eg: node1.example.com, node2.example.com>PRIV_NODELIST_VALUE=<Comma separated list of private fully qualified host names of the nodes present in the Cluster. Eg: node1-i.example.com, node2-i.example.com >VIRTUAL_NODELIST_VALUE=<Comma separated list of fully qualified virtual host names of the nodes present in the Cluster. Eg: node1-vip.example.com, node2-vip.example.com >
OCR_PARTITION_VALUE=<OCR Location. Eg:/store/storage/ocr>VDSK_PARTITION_VALUE=<VDISK Locations. Eg: /store/storage/vdsk>ORADATA_LOC=<Shared OraData Location. Eg:/store/storage/oradata>
INSTALL_USER=<Target Credentials. Eg: oracle>USER_PASSWORD=<Target Credentials. Eg: oracle>
DEVICES=<Device List. Eg: ,node1.example.com:/scratch/nfs/src/nfs3%1320%NFS%/scratch/nfs/des/nfs3%NFS,,>
DB_SID=<The Cluster Database Name. Eg: racdb>
ASM_RED=<ASM Redundancy Type. Eg: NORMAL>ASM_DISK_LIST=<Comma separated ASM Disk List. Eg:/store/asmdisks/asm1,/store/asmdisks/asm2,/store/asmdisks/asm3>ASM_DISK_STRING=<ASM Disk Search String. Eg:/store/asmdisks/*>
CENTRAL_INVENTORY_LOCATION=<Oracle Inventory Location. Eg:/scratch/rac/oraInventory>
NICS=<Network Interface List in a specific Format. Eg:eth0:152.68.196.0:PUBLIC,eth1:152.68.80.0:PRIVATE>PRIV_IP_LIST_VALUE=<Comma separated private IPs. Eg:152.68.81.85,152.68.81.86>
The following section describes in detail the sample properties file with mandatory parameters for RAC extend cluster procedures:
# -------------------------------------------------------------------------- # Properties file for Extending Cluster with CRS/RAC # Please note that # 1. Reference target should have CRS and RAC # 2. CRS/RAC targets and instances should be up. # 3. No Mirrors # 4. RAC and CRS targets should have 10.2.0.3 agents ## Variables and values to be replaced in the Template RuntimeDataXML file # # Format: # ------- # Variable=Value # --------------------------------------------------------------------------
# for extending ASM stack, include properties for # ASM_ORACLE_HOME_LOC and ASM_ORACLE_HOME_NAME # Mandatory Parameters #-----------------------------
CLUSTERWARE_ORACLE_HOME_LOC=<CRS Oracle Home Location. Eg: /u01/app/oracle/product/10.2.0/crs>DB_ORACLE_HOME_LOC=<RAC DB Oracle Home Location. Eg: /u01/app/oracle/product/10.2.0/mydb_1>DB_ORACLE_HOME_NAME=<RAC DB Oracle Home Name. Eg: OraRAC10g_home1>CLUSTER_ORACLE_HOME_NAME=<CRS Oracle Home Name. Eg: OraCrs10g_home> DB_TARGET=LINORCL DB_SID=<RAC Database SID Eg:LINORCL1>CLUSTER_NAME=<CRS Name. Eg: crs>
NEW_DB_SID_LIST=<List of SID for new nodes of RAC Database Eg:LINORCL2,LINORCL3>PUB_NODELIST_ALL_NODES=<Comma separated list of nodes present in the Cluster. Eg: node1,node2>
WORK_DIR_LOC=<Working Directory Location. Eg: /tmp>REF_NODENAME_username=<Target Credentials for reference cluster installation. Eg: oracle>REF_NODENAME_password=<Target Credentials for reference cluster installation. Eg: oracle>EXT_NODENAME_username=<Target Credentials for the new nodes. Eg: oracle>EXT_NODENAME_password=<Target Credentials for the new nodes. Eg: oracle>
ORADATA_LOC=<Location of shared dbfiles /oradbshare/oradata/linorcl/temp01.dbf>EM_REP_USER_NAME=<Management Repository User Eg:SYSMAN>LISTENER_ORACLE_HOME=<RAC Listener Oracle Home/u01/app/oracle/product/10.2.0/rac>REF_NODENAME=<Fully qualified host name of the reference Eg:node1.example.com>CRS_NEW_NODE_LIST=<List of fully qualified hostname,private host name and virtual ip for each node that would be included in the cluster Eg: node2.example.com:node2-priv:10.35.69.70:node2-vip:136.34.56.176,node3.example.com:node3-priv:10.35.69.71:node3-vip:136.34.56.177>
The following section describes in detail the sample properties file with mandatory parameters for RAC delete cluster procedures:
# -------------------------------------------------- # Properties file for Rac Delete of entire Cluster ## Variables and values to be replaced in the Template RuntimeDataXML file ## Format: # ------- # Variable=Value # -------------------------------------------------- # Mandatory Parameters #-----------------------------
CLUSTER_NAME=<CRS Name. Eg: crs>DB_TARGET=<The Cluster Database Name. Eg: racdb>DBPASSWORD=<The Cluster Database password for SYS uses. Eg: welcome1>DATABASE_INSTANCE_LIST=<Comma separated list of database instance names. Eg: racdb1,racdb2>
CLUSTER_ORACLE_HOME_NAME=<CRS Oracle Home Name. Eg: OraCrs10g_home>ASM_ORACLE_HOME_NAME=<ASM Oracle Home Name. Eg: OraASM10g_home1>DB_ORACLE_HOME_NAME=<RAC DB Oracle Home Name. Eg: OraRAC10g_home1>CLUSTERWARE_ORACLE_HOME_LOC=<CRS Oracle Home Location. Eg: /u01/app/oracle/product/10.2.0/crs>ASM_ORACLE_HOME_LOC=<ASM Oracle Home Location. Eg: /u01/app/oracle /product/10.2.0/myasm_1>DB_ORACLE_HOME_LOC=<RAC DB Oracle Home Location. Eg: /u01/app/oracle/product/10.2.0/mydb_1>
PUB_NODELIST_ALL_NODES=<Comma separated list of nodes present in the Cluster. Eg: node1,node2>HOST_LIST_FOR_DELETION=<Comma separated list of node fully qualified host names selected for deletion. Eg: node1.example.com, node2.example.com>
WORK_DIR_LOC=<Working Directory Location. Eg: /tmp>
TARGET_USERNAME=<Target Credentials. Eg: oracle>TARGET_PASSWORD=<Target Credentials. Eg: oracle>
The following section describes in detail the sample properties file with mandatory parameters for RAC descale cluster procedures:
# ------------------------------------------- # Properties file for partial delete of a Cluster ##Variables and values to be replaced in the # Template RuntimeDataXML file ## Format: # ------- # Variable=Value # ------------------------------------------- ## Mandatory Parameters#-----------------------------
CLUSTER_NAME=<CRS Name. Eg: crs>DB_TARGET=<The Cluster Database Name. Eg: racdb>DBPASSWORD=<The Cluster Database password for SYS uses. Eg: welcome1>DATABASE_INSTANCE_LIST=<Comma separated list of database instance names. Eg: racdb1,racdb2>
CLUSTER_ORACLE_HOME_NAME=<CRS Oracle Home Name. Eg: OraCrs10g_home>ASM_ORACLE_HOME_NAME=<ASM Oracle Home Name. Eg: OraASM10g_home1>DB_ORACLE_HOME_NAME=<RAC DB Oracle Home Name. Eg: OraRAC10g_home1>CLUSTERWARE_ORACLE_HOME_LOC=<CRS Oracle Home Location. Eg: /u01/app/oracle/product/10.2.0/crs>ASM_ORACLE_HOME_LOC=<ASM Oracle Home Location. Eg: /u01/app/oracle /product/10.2.0/myasm_1>DB_ORACLE_HOME_LOC=<RAC DB Oracle Home Location. Eg: /u01/app/oracle/product/10.2.0/mydb_1>
PUB_NODELIST_ALL_NODES=<Comma separated list of nodes present in the Cluster. Eg: node1,node2>HOST_LIST_FOR_DELETION=<Comma separated list of node fully qualified host names selected for deletion. Eg: node1.example.com, node2.example.com>
FIRST_TARGET_NAME=<Fully qualified host name of the node to be deleted Eg:node1.example.com>
WORK_DIR_LOC=<Working Directory Location. Eg: /tmp>TARGET_USERNAME=<Target Credentials. Eg: oracle>TARGET_PASSWORD=<Target Credentials. Eg: oracle>
The following section describes in detail the sample properties file with mandatory parameters for all patching procedures:
# Properties file for Standalone Database patching to be used with the above runtime # Template ## Use case: Patching a single database target ##Variables and values to be replaced in the template RuntimeDataXML file ## Format: # ----------- # Variable=Value # ---------------------------------------------------------------------
# Mandatory ParametersPA_VAR_targetsToPatch=<Target Names to be Patched. Eg:oracle1>
#Optional ParametersPA_VAR_hostCredentialsSet=<HostPrefNormal>PA_VAR_patchID_1=123456 PA_VAR_patchData_1=p1212121_10.2.0.3_46_9840 PA_VAR_patchSrcs_1=METALINK PA_VAR_patchTypes_1=Patch PA_VAR_patchReleases_1=10.2.0.3 PA_VAR_patchPlatforms_1=Linux PA_VAR_stageDir=%oracle_home%/EMStagedPatches PA_VAR_isPatchSet=false PA_VAR_isNotPatchset=true PA_VAR_sqlScript=defaultSqlScript PA_VAR_isUpgradeStepEnabled=true