19.19 RAC安装 35074478 补丁（ORA-800 / Set Priority / DB Performance Merge Patch for 19.19 (Requires Root Access)

0、一套新安装的19.19 RAC, orachk报告显示GI和DB没有安装 34286265 和 34318125 这两个补丁，不满足ORACLE最佳实践。如果不安装这两个补丁，则数据库可能会遭遇ORA-00800错误，后台进程无法正确设置优化级。通过MOS查询发现， 34286265 和 34318125 已经merge成了一个补丁：35074478，后期只需要针对19.19安装 35074478 补丁即可。

1、如下内容是安装35074478补丁的简要步骤，每个计算节点依次执行如下步骤，当该节点补丁安装成功后，再对其他计算节点进行补丁安装。
(I) Pre-Installation
-----------------
(Only for Installation) Maintain a location for storing the contents of the patch ZIP file. In the rest of the document, this location (absolute path) is referred to as <PATCH_TOP_DIR>. Extract the contents of the patch ZIP file to the location (PATCH_TOP_DIR) you have created above. To do so, run the following command:
    (grid)$ unzip p35074478_1919000DBRU_Linux-x86-64.zip -d /software/35074478

(Only for Installation) Determine whether any currently installed interim patches conflict with this patch 35074478 as shown below:
    $ cd /software/35074478/35074478
    $ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./


Ensure that you shut down all the services running from the Oracle home of Oracle Database home.
   - Stopping services from Database home in Clustered Environments (Run as the database home owner)
   (oralce)$ $ORACLE_HOME/bin/srvctl stop database -d yxzwdb -o immediate

   # crsctl stop crs


Run the pre-root script as a root user from the Oracle home of Oracle Grid Infrastructure:Running the Script for Grid Infrastructure Home in Clustered Environments (Run as root)
   # $ORACLE_HOME/crs/install/rootcrs.sh -prepatch

(II) Installation
-----------------
1. Apply Patch to Grid Home as GI home owner :
     As root user, change oradism permissions
       # cd /u01/app/19.0.0/grid/bin/
       # ls -ld oradism
       # chown grid oradism
       # chmod 0750 oradism
       # ls -ld oradism

As GI home owner, apply the patch:
(grid)$ cd /software/35074478/35074478
(grid)$ $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /software/35074478/35074478

2. Apply Patch to DB home(s) as DB home owner :
   As root user, change oradism permissions
       # cd /u01/app/oracle/product/19.0.0/db_1/bin
       # ls -ld oradism
       # chown oracle oradism
       # chmod 0750 oradism
       # ls -ld oradism

   As DB home owner, apply the patch:
   (oracle)$ cd /software/35074478/35074478
   (oracle)$ $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /software/35074478/35074478

3. Verify whether the patch has been successfully installed by running the following command:
   As the Oracle Grid Infrastructure owner, run the following command:
   (grid)$ opatch lspatches

   As the Oracle Database home owner, run the following command:
(oracle) $ opatch lspatches

(III) Post-Installation
-----------------
    These make the new oradism binary owned by root with setuid, and executable by "oracle" user

    For Grid Home as root user
    # ls -ld /u01/app/19.0.0/grid/bin/oradism
    # chown root /u01/app/19.0.0/grid/bin/oradism
    # chmod 4750 /u01/app/19.0.0/grid/bin/oradism
    # ls -ld /u01/app/19.0.0/grid/bin/oradism

    For DB home(s) as root user
    # ls -ld /u01/app/oracle/product/19.0.0/db_1/bin/oradism
    # chown root /u01/app/oracle/product/19.0.0/db_1/bin/oradism
    # chmod 4750 /u01/app/oracle/product/19.0.0/db_1/bin/oradism
    # ls -ld /u01/app/oracle/product/19.0.0/db_1/bin/oradism

   Run the post script as a root user from the Oracle home of Oracle Grid Infrastructure: Running the script for Grid Infrastructure home in Clustered Environments (Run as root)
   # $ORACLE_HOME/crs/install/rootcrs.sh -postpatch

526互联

19.19 RAC安装 35074478 补丁（ORA-800 / Set Priority / DB Performance Merge Patch for 19.19 (Requires Root Access) - 34286265 34318125）