Apply Online Patch (Aka Hot Patch) make the other Node's Inventory Corrupt in RAC if the applied patches of two nodes are not the same
(Doc ID 2298350.1)
Last updated on FEBRUARY 19, 2019
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
In RAC system, if the applied patches for two nodes are not the same (eg, 2 patches are applied to node1, and 1 patch is applied to node2), then applying an online patch will corrupt the another node's inventory.
Steps to reproduce the problem:
1. Apply patch 13914613 (it could be other patch) with OFFLINE mode in node1 only (with -local option), do NOT apply it to node2
2. Then start all the instances of the RAC system
3. Run opatch in node1 to apply another patch (eg 12879027) with ONLINE mode
(eg: opatch apply online -connectString R112031:sys:oracle:rac1,R112032:sys:oracle:rac2)
This will corrupt node2's inventory (the opatch will add 13914613 to node2's $ORACLE_HOME/inventory/ContentsXML/comps.xml, but this patch is not applied to node2 before)
4. Run opatch lspatches in node2 will receive below error:
LsInventorySession failed: Unable to create patchObject
Possible causes are:
ORACLE_HOME/inventory/oneoffs/13914613 is corrupted
No read permission to above directory
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document