1. Cloud Control Database Lifecycle Management Administrator's Guide
  2. Database Maintenance: Updates (Patching) and Upgrades
  3. Oracle Fleet Patching and Provisioning and Enterprise Manager Integration
  4. FPP Setup Automation

FPP Setup Automation

With FPP Setup Automation you can setup and provision an FPP server of client while provisioning new Grid Infrastructure or on existing Grid Infrastructure.

You will need to provision both an FPP server and client, in these examples you can see sample commands to provision both server and client in new Grid Infrastructure or into existing Grid Infrastructure through Enterprise Manager

Note:

This method is currenlty supported for 19c releases only.
:
  • Provision an FPP Server on Exisiting Grid Infrastructure
     emcli submit_procedure -input_file=data:"/home/user_name/FPP/input.properties" -name="RACPROV2"
    The input file must contain the following
    TARGET_NAME=emracn0607
FPP_DISK_GROUP=MGMTDB
FPP_IMAGES_MOUNTPOINT=/scratch/cuser/fppImages
GNS_VIP_ADDRESS=emracn0607-gns.subnet1rg.emsubnet.companyvcn.com
NORMAL_USER=CUSER:SYSMAN
ROOT_USER=CUSER_ROOT:SYSMAN
MIN_HEAP_SIZE=3G
MAX_HEAP_SIZE=5G
REST_USER_NAME=restuser
REST_USER_PASSWORD=<password>
REST_USER_EMAIL=user@company.com
  • Provision an FPP Server and Grid Infrastructure
    emcli submit_procedure -input_file=data:"/home/user_name/FPP/gi_input.properties" -name="RACPROV2"
    The input file must contain the following
    ASMDBA_GROUP=oinstall
ASMOPER_GROUP=oinstall
ASM_DISK_LISTS=/mnt/emracdev/emracn0607/ASMDISK/disk1,/mnt/emracdev/emracn0607/ASMDISK/disk2,/mnt/emracdev/emracn0607/ASMDISK/disk3
ASM_DISK_STRINGS=/mnt/emracdev/emracn0607/ASMDISK/disk*;/mnt/emracdev/emracn0607/MGMTDB/disk*
AUTOVIP_ENABLED=false
CLUSTER_NAME=emracn0607
CONFIGURE_ASMFD=false
CONFIGURE_GIMR=true
CONFIGURE_MODE=CONFIGURE_ASM
CVU_CHECK_ERRORMODE=stop
DB_COMPONENT=Fleet/OH19/linux64/DB19_18 - OH19 RU18
DB_HOST_NORMAL_CREDNAMES=CUSER:SYSMAN
DB_HOST_ROOT_CREDNAMES=CUSER_ROOT:SYSMAN
DB_INS_CS_GUID=0
DB_ORACLE_BASE_LOC=/scratch/cuser/19c/racbase
DB_ORACLE_HOME_LOC=/scratch/cuser/19c/rachome
DB_PRODUCT_VERSION=19.0.0.0.0
DEPLOY_MODE=DEPLOY_GI
DISKGROUP_AU_COMPATIBLE=DATA:4:::;MGMTDB:4:::
DISK_GROUP_NAMES=DATA,MGMTDB
FLEX_ENABLED=false
GIMR_DB_ORACLE_BASE_LOC=/scratch/cuser/19c/racbase
GIMR_DB_ORACLE_HOME_LOC=/scratch/cuser/19c/rachome
GIMR_DISK_GROUP=MGMTDB
GIMR_TYPE=NOGIMR
GI_AU_SIZE=4
GI_CLUSTER_TYPE=1
GI_COMPONENT=Fleet/GI1919/linux64/GI_19_19 - GI 19 RU19
GI_HOME_SHARED=false
GI_HOST_NORMAL_CREDNAMES=CUSER:SYSMAN
GI_HOST_ROOT_CREDNAMES=CUSER_ROOT:SYSMAN
GI_ORACLE_BASE_LOC=/scratch/gridbase
GI_ORACLE_HOME_LOC=/scratch/gridhome
GI_PRODUCT_VERSION=19.0.0.0.0
GI_STORAGE_TYPE=1
GNS_ENABLED=true
GNS_VIP_ADDRESS=emracp1011-gns.subnet1rg.emsubnet.companyvcn.com
GRID_DISK_FLAG=true
GROUP_VERSION=19.0.0.0.0
INTERFACE_PARAM_VALUE=ens3:100.75.0.0:1,ens4:192.168.1.0:5
NOT_RELINK_DB_HOME_SELECTED=false
NOT_RELINK_GIMR_DB_HOME_SELECTED=false
NOT_RELINK_GI_HOME_SELECTED=false
OCR_VDSK_DISK_GROUP=DATA
OINSTALL_GROUP=oinstall
OSASM_GROUP=oinstall
OSBACKUPDBA_GROUP=oinstall
OSDBA_GROUP=oinstall
OSDGDBA_GROUP=oinstall
OSKMDBA_GROUP=oinstall
OSOPER_GROUP=oinstall
OSRACDBA_GROUP=oinstall
PAUSE_AFTER_PREREQ=false
PLATFORM_ARUID=226
PREREQ_CHECK_ERRORMODE=continue
RAC_DBCA_MODE=CreateRACDatabase
RAC_HOME_SHARED=false
RAC_STORAGE_TYPE=1
REDUNDANCYS=NORMAL,NORMAL
ROLE_NODENAMES=HUB,HUB
RUN_CVU_FROM_OH=true
SCAN_NAME=emracn0607-r.racdb-scan.emsubnet.companyvcn.com
SCAN_PORT=1521
SKIP_CVU_CHECK=false
SKIP_PREREQUISITE_CHECKS=false
SOURCE_TYPE=SOFTWARE_LIBRARY
SSH_SETUP=false
TARGET_HOST_LIST=emracn07.subnet1rg.emsubnet.companyvcn.com,emracn06.subnet1rg2.emsubnet.companyvcn.com
VERSION_GREATER_12102=true
VIP_NODENAMES=emracn07-vip.subnet1rg.emsubnet.companyvcn.com,emracn06-vip.subnet1rg.emsubnet.companyvcn.com
WORK_DIR_LOC=/tmp/
ASM_SYS_PASSWORD=oracle
FPP_CONFIGURATION_TYPE=server
FPP_DISK_GROUP=MGMTDB
FPP_IMAGES_MOUNTPOINT=/scratch/cuser/mount
REST_USER_NAME=restuser
REST_USER_PASSWORD=<password>
REST_USER_EMAIL=user@company.com
  • Provision an FPP Client and Grid Infrastructure
    emcli submit_procedure -input_file=data:"/home/user_name/FPP/gi_client_input.properties"-name="RAC_PROV"
    The input file must contain the following
    ASMDBA_GROUP=oinstall
ASMOPER_GROUP=oinstall
ASM_DISK_LISTS=/mnt/emracdev/emracp1011/ASMDISK/disk1,/mnt/emracdev/emracp1011/ASMDISK/disk2,/mnt/emracdev/emracp1011/ASMDISK/disk3
ASM_DISK_STRINGS=/mnt/emracdev/emracp1011/ASMDISK/disk*
ASM_FAILURE_AND_QUORUM_GROUPS=/mnt/emracdev/emracp1011/ASMDISK/disk1||false,/mnt/emracdev/emracp1011/ASMDISK/disk2||false,/mnt/emracdev/emracp1011/ASMDISK/disk3||false
ASM_OCRVDSK_FAILURE_AND_QUORUM_GROUPS=/mnt/emracdev/emracp1011/ASMDISK/disk1||false,/mnt/emracdev/emracp1011/ASMDISK/disk2||false,/mnt/emracdev/emracp1011/ASMDISK/disk3||false
ASM_SYS_PASSWORD=sample1
AUTOVIP_ENABLED=false
CLUSTER_NAME=emracp1011
CONFIGURE_ASMFD=false
CONFIGURE_GIMR=false
CONFIGURE_MODE=CONFIGURE_ASM
DB_ORACLE_BASE_LOC=/u02/app/oracle
DB_ORACLE_HOME_LOC=/u02/app/oracle/app/product/19.0.0.0.0/db
DB_PRODUCT_VERSION=19.0.0.0.0
DEPLOY_MODE=DEPLOY_GI
DISKGROUP_AU_COMPATIBLE=DATA:4:::
DISK_GROUP_NAMES=DATA
FLEX_ENABLED=false
GIMR_DB_ORACLE_BASE_LOC=/u03/app/oracle
GIMR_DB_ORACLE_HOME_LOC=/u03/app/oracle/app/product/21.0.0.0/gimrdb
GIMR_DISK_GROUP=DATA
GIMR_TYPE=NOGIMR
GI_AU_SIZE=4
GI_CLUSTER_TYPE=1
GI_COMPONENT=Fleet/OH19/linux64/DB19 - RU19
GI_HOME_SHARED=false
GI_HOST_NORMAL_CREDNAMES=CUSER:SYSMAN
GI_HOST_ROOT_CREDNAMES=CUSER_ROOT:SYSMAN
GI_ORACLE_BASE_LOC=/scratch/gridbase
GI_ORACLE_HOME_LOC=/scratch/gridhome
GI_PRODUCT_VERSION=19.0.0.0.0
GI_STORAGE_TYPE=1
GNS_ENABLED=false
GRID_DISK_FLAG=true
GROUP_VERSION=19.0.0.0.0
INTERFACE_PARAM_VALUE=ens3:100.75.0.0:1,ens4:192.168.1.0:5
NOT_RELINK_DB_HOME_SELECTED=false
NOT_RELINK_GIMR_DB_HOME_SELECTED=false
NOT_RELINK_GI_HOME_SELECTED=false
OCR_VDSK_DISK_GROUP=DATA
OINSTALL_GROUP=oinstall
OSASM_GROUP=oinstall
PAUSE_AFTER_PREREQ=false
PLATFORM_ARUID=226
PREREQ_CHECK_ERRORMODE=continue
RAC_DBCA_MODE=CreateRACDatabase
RAC_HOME_SHARED=false
RAC_STORAGE_TYPE=1
REDUNDANCYS=NORMAL
ROLE_NODENAMES=HUB,HUB
RUN_CVU_FROM_OH=true
SCAN_NAME=emracp1011-r.racdb-scan.emsubnet.companyvcn.com
SCAN_PORT=1521
SKIP_CVU_CHECK=true
SKIP_PREREQUISITE_CHECKS=false
SOURCE_TYPE=SOFTWARE_LIBRARY
SSH_SETUP=false
TARGET_HOST_LIST=emracp10.subnet1rg2.emsubnet.companyvcn.com,emracp11.subnet1rg2.emsubnet.company.com
VERSION_GREATER_12102=true
VIP_NODENAMES=emracp10-vip.subnet1rg2.emsubnet.companyvcn.com,emracp11-vip.subnet1rg2.emsubnet.companyvcn.com
FPP_SERVER_TARGET_NAME=emracn0607
FPP_SERVER_HOST_USER=CUSER:SYSMAN
FPP_CONFIGURATION_TYPE=client
#PREREQS_ONLY=true
WORK_DIR_LOC=/tmp/
  • Provision an FPP Client on Existing Grid Infrastructure
    emcli submit_procedure -input_file=data:"/home/user_name/FPP/input.properties" -name="SETUP_FPP_CLIENT"
    The input file must contain the following
    TARGET_NAME=emracp1011
NORMAL_USER=CUSER:SYSMAN
ROOT_USER=CUSER_ROOT:SYSMAN
FPP_SERVER_TARGET_NAME=emracn0607
FPP_SERVER_HOST_USER=CUSER:SYSMAN
WORKING_DIRECTORY=/scratch/cuser/tmp