Oracle Fleet Maintenance Patching – Detailed Implementation Plan

Overview

This document provides a comprehensive procedure for Oracle Fleet Maintenance patching to 19.24.0.0.0 across RAC clusters. It covers precheck, implementation, post-check, rollback, and testing plans.

1. Pre-Change Checks

Includes all the pre-implementation validations and checks to ensure the environment is ready for patching. This phase helps identify any potential conflicts or configuration mismatches.

2. Implementation Plan

Step-by-step instructions to perform the actual patch deployment using Oracle Enterprise Manager (OEM). This section also includes command references for all tasks and validations.

3. Post Implementation Verification

Validations to ensure the patch has been applied correctly and all Oracle services are functioning from the new Oracle homes.

4. Backout (Rollback) Plan

This section defines the rollback procedure if the patch fails or needs to be reverted due to any unforeseen issues.

5. Test Plan

After patching, this phase involves validation commands to confirm the correct patch level and functionality of ASM and database services.

Detailed Procedural Steps

Refer to the following step-by-step commands and instructions copied from the implementation draft.

Note: All outputs indicated as <COPY O/P HERE> must be filled post-execution by the administrator.

[Insert complete raw text here. For delivery, this content should be copied and formatted directly into this section as necessary.]

Expanded Procedural Content

Precheck Sample Commands

. oraenv
+ASM*
sudo -u oracle $ORACLE_HOME/OPatch/opatch lspatches > DB_patch_lspatches.log

sudo -u oracle $ORACLE_HOME/OPatch/opatch lsinventory > DB_patch_lsinv.log

Imperva Agent Check

ps -ef | grep -i imperva
<IMPERVA_HOME>/bin/rainit status
<IMPERVA_HOME>/bin/rainit stop

OGG Process Check

ps -ef | grep dirprm

OEM EMCLI Image Subscription

sudo -u oracle ./emcli db_software_maintenance -getTargetSubscriptions -target_name="<cluster_name>" -target_type="cluster"

Grid and DB Image Deployment

sudo -u oracle ./emcli db_software_maintenance -performOperation -name="deployGIsoftware" -purpose=DEPLOY_GI_SOFTWARE -target_type="cluster" -target_list="<cluster_name>" -normal_credential="V2V_ORACLE_VM_LOGIN:SYSMAN" -privilege_credential="GLOBAL_SUDO_TO_ROOT_VIA_ORACLE:SYSMAN" -input_file="data:/oracle_software/FPP/input_deploy_RAC_grid1924.txt"

sudo -u oracle ./emcli db_software_maintenance -performOperation -name="deployRACDBsoftware" -purpose=DEPLOY_RAC_SOFTWARE -target_type="rac_database" -target_list="<DB_NAME1>" -normal_credential="V2V_ORACLE_VM_LOGIN:SYSMAN" -privilege_credential="GLOBAL_SUDO_TO_ROOT_VIA_ORACLE:SYSMAN" -input_file="data:/oracle_software/FPP/input_deploy_RAC_db1924.txt"

Post-Check Commands

. oraenv
+ASM*
sudo -u oracle $ORACLE_HOME/OPatch/opatch lspatches

. oraenv
<DBNAME>
sudo -u oracle sqlplus / as sysdba

SELECT TO_CHAR(action_time, 'DD-MON-YYYY HH24:MI:SS') AS action_time,
action, status, description, patch_id
FROM sys.dba_registry_sqlpatch
ORDER BY action_time;