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. Deploy a Gold Image and Patch Using FPP
  5. FPP Patching Using EM CLI

FPP Patching Using EM CLI

To deploy software images and patch using EM CLI use the following examples.

Deploy a Gold Image for a Database

To deploy a software image use the EM CLI command 
emcli db_software_maintenance -performOperation 
-name="Deploy 19.14 RAC Home" 
-purpose=DEPLOY_RAC_SOFTWARE 
-target_type=rac_database 
-target_list="demodbfpp" 
-normal_credential="CUSER:SYSMAN" 
-input_file="data:/<location>/deploy_input.prop"
.
The input file must contain the following parameters:
NEW_ORACLE_HOME_LIST=/scratch/<user>/<location>/swDeploy
dispatchLoc=/scratch/cuser/workDir
workingDir=/scratch/cuser/workDir
SKIP_PREREQUISITE_CHECKS=false
workingCopy=EM_WORKING_COPY_1
*workingCopyPrefix=EM_WORKING_LIST 
homeNamePrefix=<User defined Oracle Home name>

Note:

  • If there is more than one target in the target_list user will have to specify workingCopyPrefix instead of workingCopy.
  • homeNamePrefix=<User defined Oracle Home name>: Allows you to define a custom Oracle Home name prefix, allowing for the ability to discover Oracle Homes with custom name in deployment command. If the home name prefix is not specified, the default value will be used. This variable is available starting with Oracle Enterprise Manager 13.5 Release update 20 (13.5.0.20).

Patch a Database

To patch a database use the EM CLI command 
emcli db_software_maintenance 
-performOperation -name="Update dbfpp" 
-purpose=UPDATE_RACDB 
-target_type=rac_database 
-target_list="demodbfpp" 
-normal_credential="HHKAUR:SYSMAN"
.

First deploy the software on all standby databases, then patch all standby databases. Once the standby process is complete, repeat on primary databases by first deploying the software and then patching.