Oracle 19c RAC_RU19.10 打补丁及错误处理简单步骤.txt
5墨值下载
1、 grid 和 oracle 用户替换 Opatch
cd /app/soft
unzip p6880880_122010_Linux-zSer_12.2.0.1.23.zip –d $ORACLE_HOME
2、验证 opatch 版本
opatch version
OPatch Version: 12.2.0.1.23
3、 grid 用户解压 19.10 RU 补丁（这里必须要用 grid 用户解压）
cd /app/soft
unzip p32226239_190000_Linux-zSer-1910.zip
4、 检测是否有补丁冲突
grid、oracle 用户均需要执行
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir
/app/soft/32226239/32218454
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir
/app/soft/32226239/32222571
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir
/backup/soft/32126842/32226239/32218454
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir
/backup/soft/32126842/32226239/32222571
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir
/backup/soft/32126842/32226239/
5、复制 oui-patch.xml 到远程节点注意权限
scp -p jieker1:/u01/app/oraInventory/ContentsXML/oui-patch.xml ./
6、root 用户分析补丁
/app/app/19.0.0.0/grid/OPatch/opatchauto apply /app/soft/32226239 -analyze
/backup/app/19.0.0.0/grid/OPatch/opatchauto apply
/backup/soft/32126842/32226239/ -analyze
/u01/app/19.0.0.0/grid/OPatch/opatchauto apply /backup/soft/32126842/32226239/
-analyze
root 自动打补丁
/u01/app/19.0.0.0/grid/OPatch/opatchauto apply /backup/soft/32126842/32226239/
查看 lib 包是否有进程占用
fuser /app/app/oracle/product/19.0.0.0/dbhome_1/lib/libsqlplus.so
fuser /app/app/oracle/product/19.0.0.0/dbhome_1/lib/libclntsh.so.19.1
如果存在进程占用，将会产生如下报错
/app/app/oracle/product/19.0.0.0/dbhome_1/bin/expdp at Thu Mar 04 15:31:14 CST
2021
[Mar 4, 2021 3:31:14 PM] [INFO] Following active executables are not used by
opatch process : /app/app/oracle/product/19.0.0.0/dbhome_1/lib/libclntsh.so.19.1
/app/app/oracle/product/19.0.0.0/dbhome_1/lib/libsqlplus.so
Following active executables are used by opatch process :
[Mar 4, 2021 3:31:14 PM] [INFO] Prerequisite check
"CheckActiveFilesAndExecutables" failed.
The details are:
Following active executables are not used by opatch process :
/app/app/oracle/product/19.0.0.0/dbhome_1/lib/libclntsh.so.19.1
/app/app/oracle/product/19.0.0.0/dbhome_1/lib/libsqlplus.so
Following active executables are used by opatch process :
[Mar 4, 2021 3:31:15 PM] [SEVERE] OUI-67073:UtilSession failed: Prerequisite
check "CheckActiveFilesAndExecutables" failed.
[Apr 8, 2021 10:39:06 PM] [INFO] Finish fuser command /bin/fuser
/u01/app/19.0.0.0/grid/bin/expdp at Thu Apr 08 22:39:06 CST 2021
[Apr 8, 2021 10:39:06 PM] [INFO] Following active executables are not used by
opatch process :
/u01/app/19.0.0.0/grid/lib/libasmclntsh19.so
/u01/app/19.0.0.0/grid/lib/libclntsh.so.19.1
Following active executables are used by opatch process :
[Apr 8, 2021 10:39:06 PM] [INFO] Prerequisite check
"CheckActiveFilesAndExecutables" failed.
The details are:
Following active executables are not used by opatch process :
/u01/app/19.0.0.0/grid/lib/libasmclntsh19.so
/u01/app/19.0.0.0/grid/lib/libclntsh.so.19.1
Following active executables are used by opatch process :
[Apr 8, 2021 10:39:06 PM] [SEVERE] OUI-67073:UtilSession failed: Prerequisite
check "CheckActiveFilesAndExecutables" failed.
可以通过 kill 占用进程进行处理
jieker1:~ # fuser -kv /u01/app/19.0.0.0/grid/lib/libclntsh.so.19.1
jieker1:~ # fuser -kv /u01/app/19.0.0.0/grid/lib/libasmclntsh19.so
7、 检查/app/soft/32226239/32222571/files/bin/ocrcheck.bin 属主(如果使用 oracle 用
户解压补丁，权限需要修改为 grid)
ls –l /app/soft/32226239/32222571/files/bin/ocrcheck.bin
chown grid:oinstall /app/soft/32226239/32222571/files/bin/ocrcheck.bin
单机 ASM 出现的权限问题
jiekexu:/u01/app/19.0.0.0/grid/bin # ls -l
/backup/soft/30899722/30894985/files/bin/ocrcheck.bin
-rwx------ 1 oracle oinstall 825152 Apr 11 2020
/backup/soft/30899722/30894985/files/bin/ocrcheck.bin
jiekexu:/u01/app/19.0.0.0/grid/bin # chown grid:oinstall
/backup/soft/30899722/30894985/files/bin/ocrcheck.bin
jiekexu:/u01/app/19.0.0.0/grid/bin # ls -l
/backup/soft/30899722/30894985/files/bin/ocrconfig.bin
-rwx------ 1 oracle oinstall 957136 Apr 11 2020
/backup/soft/30899722/30894985/files/bin/ocrconfig.bin
jiekexu:/u01/app/19.0.0.0/grid/bin # chown grid:oinstall
/backup/soft/30899722/30894985/files/bin/ocrconfig.bin
jiekexu:/u01/app/19.0.0.0/grid/bin # ls -l
/backup/soft/30899722/30894985/files/bin/ocrconfig.bin
-rwx------ 1 grid oinstall 957136 Apr 11 2020
/backup/soft/30899722/30894985/files/bin/ocrconfig.bin
如果权限错误将会产生报错
Patch: /app/soft/32226239/32222571
Log: /app/app/19.0.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-03-
04_15-43-38PM_1.log
Reason: Failed during Analysis: CheckPatchApplicable Failed, [ Prerequisite
Status: FAILED, Prerequisite output:
The details are:
of 3
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
文档被以下合辑收录
评论