19.19 RAC安装 35074478 补丁（ORA-800 / Set Priority / DB Performance Merge Patch for 19.19 (Requires Root Access) - 34286265 34318125）
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
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
