19c Patch for 35074478 for Linux-x86-64 Platforms.txt--patch35074478 readme.txt

Patch35074478信息
patch35074478 补丁（ORA-800 / Set Priority / DB Performance Merge Patch for 19.19 (Requires Root Access) - 34286265 34318125）
ORA-00800: soft external error, arguments: [Set Priority Failed]

节点1 和 节点2 上分别打patch 35074478

19c Patch for 35074478 for Linux-x86-64 Platforms.txt ---- patch35074478 readme.txt

(I) Prerequisites
使用grid用户执行
(grid)$ cp /u01/soft/p35074478_1919000DBRU_Linux-x86-64.zip /tmp/orapsu/
(grid)$ cd /tmp/orapsu/
(grid)$ unzip p35074478_1919000DBRU_Linux-x86-64.zip
(grid)$ cd 35074478 ----/tmp/orapsu/35074478
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

所有节点停止 crs 服务（root用户）

crsctl stop crs

tfactl stop

cd /u01

tar -pcvf /tmp/orapsu/rac_app.tar ./app ----备份安装目录app, 目录app下包含GI&DB软件

/u01/app/19c/grid/crs/install/rootcrs.sh -prepatch

(II) Installation

节点1执行完成安装步骤后，再在节点2上执行安装步骤（即滚动打补丁）。

   ----- root 用户执行
   # cd /u01/app/19c/grid/bin/
   # ls -ld oradism
   # chown grid oradism
   # chmod 0750 oradism
   # ls -ld oradism

  1. Apply Patch to Grid Home as GI home owner :
    $ <GI_HOME>/OPatch/opatch apply -oh <GI_HOME> -local <PATCH_TOP_DIR>/35074478

    ----grid
    (grid)$ cd /tmp/orapsu/35074478
    (grid)$ /u01/app/19c/grid/OPatch/opatch apply -oh /u01/app/19c/grid -local /tmp/orapsu/35074478

  2. Apply Patch to DB home(s) as DB home owner
    ----- root 用户执行
    # cd /u01/app/oracle/product/19c/db_1/bin
    # ls -ld oradism
    # chown oracle oradism
    # chmod 0750 oradism
    # ls -ld oradism

    ----As DB home owner, apply the patch:

    su - oracle

    (oracle)$ cd /tmp/orapsu/35074478
    (oracle)$ /u01/app/oracle/product/19c/db_1/OPatch/opatch apply -oh /u01/app/oracle/product/19c/db_1 -local /tmp/orapsu/35074478

    ----p35074478 与 p35320424 冲突 --Patch 35320424: MRP INTERMITTENT HANG ON TWO STANDBY DATABASES REGR_FIX
    ---- (oracle)$ opatch rollback -id 35320424

  3. Verify whether the patch has been successfully installed by running the following command:
    (grid)$ opatch lspatches ---- opatch lsinv | grep 35074478 34286265 34318125

    (oracle) $ opatch lspatches ---- opatch lsinv | grep 35074478 34286265 34318125

3b. Post-install

3b.1 - For Grid Home as root user
    ------------root  --grid's
    For Grid Home as root user
    # ls -ld /u01/app/19c/grid/bin/oradism
    # chown root /u01/app/19c/grid/bin/oradism
    # chmod 4750 /u01/app/19c/grid/bin/oradism
    # ls -ld /u01/app/19c/grid/bin/oradism

3b.2 - For DB home(s) as root user
    ------------root --oracle's
    # ls -ld /u01/app/oracle/product/19c/db_1/bin/oradism
    # chown root /u01/app/oracle/product/19c/db_1/bin/oradism
    # chmod 4750 /u01/app/oracle/product/19c/db_1/bin/oradism
    # ls -ld /u01/app/oracle/product/19c/db_1/bin/oradism

  1. 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)
      (root)#/u01/app/19c/grid/crs/install/rootcrs.sh -postpatch

  2. Restart all the instances from the Oracle home.
    $ $ORACLE_HOME/bin/srvctl start instance -d <db_unique_name> -n <node_name>

    ----OR -- root (all node execute)
    (root)# crsctl start crs

(III) Deinstallation

  参看patch readme.txt。

(III) Deinstallation

停止所有节点的crs

crsctl stop crs

i.
root#
cd /u01/app/19c/grid/bin/
ls -ld oradism
chown grid oradism
chmod 0750 oradism
ls -ld oradism

ii.
root#
cd /u01/app/oracle/product/19c/db_1/bin
ls -ld oradism
chown oracle oradism
chmod 0750 oradism
ls -ld oradism

  1. Deinstall the patch from Grid Home as GI home owner :
    $ <GI_HOME>/OPatch/opatch rollback -local -id 35074478 -oh <GI_HOME>

su - grid
/u01/app/19c/grid/OPatch/opatch rollback -local -id 35074478 -oh /u01/app/19c/grid

  1. Deinstall the patch from DB home(s) as DB home owner :
    $ <ORACLE_HOME>/OPatch/opatch rollback -local -id 35074478 -oh <ORACLE_HOME>

su - oracle
/u01/app/oracle/product/19c/db_1/OPatch/opatch rollback -local -id 35074478 -oh /u01/app/oracle/product/19c/db_1

Post-install
i - For Grid Home as root user
------------root --grid's
For Grid Home as root user
# ls -ld /u01/app/19c/grid/bin/oradism
# chown root /u01/app/19c/grid/bin/oradism
# chmod 4750 /u01/app/19c/grid/bin/oradism
# ls -ld /u01/app/19c/grid/bin/oradism

ls -ld /u01/app/19c/grid/bin/oradism
chown root /u01/app/19c/grid/bin/oradism
chmod 4750 /u01/app/19c/grid/bin/oradism
ls -ld /u01/app/19c/grid/bin/oradism

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

ls -ld /u01/app/oracle/product/19c/db_1/bin/oradism
chown root /u01/app/oracle/product/19c/db_1/bin/oradism
chmod 4750 /u01/app/oracle/product/19c/db_1/bin/oradism
ls -ld /u01/app/oracle/product/19c/db_1/bin/oradism

所有节点依次执行。

3.启动所有节点的crs

crsctl start crs

$ su - grid
opatch lspatches

$su - oracle
opatch lspatches

相关case情况：
（1）
https://www.xifenfei.com/2022/11/ora-00800.html
在一套19.14的linux 2节点rac库中,使用sqlplus启动数据库成功,但是alert日志中报ORA-00800: soft external error, arguments: [Set Priority Failed]错误.
.........
这个问题一直困惑了很久,今天无意中在mos上发现了相关mos文档,具体参考:(DB50) Clusterware Fails to Start Because CSSD Cannot Get Real-Time Priority (Doc ID 2903663.1),由于 bug 34286265 and bug 34318125(Bug 34649727 Linux: ORA-800 / Set Priority / DB Performance Merge Patch for 19.17 – 34286265 34318125)

(2)
https://www.cnblogs.com/missyou-shiyh/p/17531455.html
19.19 RAC安装 35074478 补丁（ORA-800 / Set Priority / DB Performance Merge Patch for 19.19 (Requires Root Access) - 34286265 34318125）

posted @ 2023-07-21 12:07  武汉OracleDBA  阅读(94)  评论(0)  编辑  收藏  举报