Patch 34130714 - GI Release Update 19.16.0.0.220719

p34130714_190000_Linux-x86-64

・ p34130714_190000_Linux-x86-64_README

Record

System Operation: RHEL 8.7
Database Software: 19.3.0.0.0 RAC with 3 nodes

  1. Update OPatch utility version to 12.2.0.1.30 or later.

  2. Validation of Oracle Inventory on each node.

    ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
    ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

  3. Download and Unzip the Patch on each node.

    ~]# chown grid:oinstall /soft/p34130714_190000_Linux-x86-64.zip
    ~]$ unzip -q /soft/p34130714_190000_Linux-x86-64.zip -d /soft

  4. Run OPatch Conflict Check on each node.

    • As the Grid home user:
    ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/34130714/34133642
    ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/34130714/34160635
    ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/34130714/34139601
    ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/34130714/34318175
    ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/34130714/33575402
    • For Oracle home, as home user:
    ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/34130714/34133642
    ~]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/34130714/34160635

  5. Run OPatch System Space Check on each node.

    • For Grid Infrastructure home, as home user:
    ~]$ cat > /tmp/patch_list_gihome.txt << EOF
    /soft/34130714/34133642
    /soft/34130714/34160635
    /soft/34130714/34139601
    /soft/34130714/34318175
    /soft/34130714/33575402
    EOF

    $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt
    • For Oracle home, as home user:
    ~]$ cat > /tmp/patch_list_dbhome.txt << EOF
    /soft/34130714/34133642
    /soft/34130714/34160635
    EOF

    $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

  6. One-off Patch Conflict Detection and Resolution on each node.

    ~]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /soft/3413071

  7. Patch Installation Checks on each node.

    ~]$ cluvfy stage -pre patch

  8. Patch Installation

    • Case 1: Oracle RAC, where the Grid home and the Oracle homes are not shared and Oracle ACFS file system is not configured
      As root user, execute the following command on each node of the cluster:
    ~]# /u01/app/19.0.0/grid/OPatch/opatchauto apply /soft/34130714

  9. Patch Post Installation Instructions

    After applying the patch, the sanity of the patching operation can be verified by issuing the cluvfy stage -post patch command from any of the cluster nodes upon completion of the patch application process.

    ~]$ cluvfy stage -post patch

    List patches.

    ~]$ $ORACLE_HOME/OPatch/opatch lspatches
    34318175;TOMCAT RELEASE UPDATE 19.0.0.0.0 (34318175)
    34160635;OCW RELEASE UPDATE 19.16.0.0.0 (34160635)
    34139601;ACFS RELEASE UPDATE 19.16.0.0.0 (34139601)
    34133642;Database Release Update : 19.16.0.0.220719 (34133642)
    33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
    OPatch succeeded.