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. Fleet Maintenance Automation
  5. Fleet Maintenance EM CLI Operations
  6. Subscription Tasks
  7. Verifying if Image is Applicable

Verifying if Image is Applicable

This step verifies if the image can be used to patch a specified database target. This is done by comparing the bug fixes available in the current Oracle home of the database target and the image.

Sample code: 
emcli db_software_maintenance -checkApplicability -image_id=<image_id> 
-target_list=<target_list> -target_type=<target_type>
Description of Input Variables
  • target_list: List of database or Grid Infrastructure home or Oracle restart Home targets.
  • target_type: Refer to the table “EM CLI command inputs based on Entity type”.

Examples:

RAC Database
emcli db_software_maintenance –checkApplicability -image_id= FE55AD7AB28974EFE04313B2F00AD4A0 
-target_list=RACDB1 -target_type=rac_database
Oracle Restart
emcli db_software_maintenance –checkApplicability -image_id=2EA08B6339234B7E053BC3A410A2826 
-target_list=HAS1 -target_type=has

Grid Infrastructure

emcli db_software_maintenance -checkApplicability -image_id=72F8E4FCDE017B99E053BC3A410AF226 
-target_list=CLUSTER1 -target_type=cluster

Single Instance

emcli db_software_maintenance -checkApplicability -image_id=6E4EA63DDC00535CE0531636B10ABA1A 
-target_list=DB1 -target_type=oracle_database

Sample Output

Checking applicability for target [DB1]...
Image is applicable
This command can show one of the following results:
  • Applicable: The image and database target contain the same set of bug fixes. The image can be applied on the specified target.
  • Applicable and Image has more bug fixes: The image contains more bug fixes than those applied on the database. The list of extra bugs is displayed. The image can be applied on the specified target.
  • Not Applicable: The database contains more bug fixes than those included in the image. The list of missing bugs is displayed. The administrator has to create a new version of the image that includes the missing bugs before the database can uptake the same.