暂无图片
暂无图片
2
暂无图片
暂无图片
暂无图片
首页 / Oracle补丁集19.13补丁检查遇上等保设置（初始化hang住）

Oracle补丁集19.13补丁检查遇上等保设置（初始化hang住）

原创 AIQ 2021-11-09
2420

Table of Contents

背景

打19.13的补丁集时候，有一步是一次性补丁检查与解决，在初始化的时候就卡住不动了，1个小时过去了，没回声。
已经也没有错误信息。与虚拟机的测试完全不一样，一开始完全没有头绪。无从下手。
前台的信息：


[root@Chenzq1 grid]# /oracle/app/19.8.0/grid/OPatch/opatchauto apply /oracle/software/patch/19.13/33248471/33182768 -analyze

OPatchauto session is initiated at Mon Nov  8 23:37:35 2021
^C    ##此处ctrl+c中断了
OPATCHAUTO-72083: Performing bootstrap operations failed.
OPATCHAUTO-72083: The bootstrap execution failed because null.
OPATCHAUTO-72083: Fix the reported problem and re-run opatchauto.

OPatchauto session completed at Mon Nov  8 23:39:23 2021
Time taken to complete the session 1 minute, 48 seconds

opatchauto bootstrapping failed with error code 130.


复制

日志的信息：

bootstrap2021-11-08_11-37-35PM.log
2021-11-08 23:37:35,941 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - indexOfRemote: -1
2021-11-08 23:37:35,942 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - currentUser: root
2021-11-08 23:37:35,977 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - indexOfRemote: -1
2021-11-08 23:37:35,978 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - currentUser: root
2021-11-08 23:37:36,011 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHandler - Processing common bootstrap parameters.
2021-11-08 23:37:36,140 INFO  [1] oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader - crsType: CRS
2021-11-08 23:37:36,216 INFO  [1] oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader - running: true
2021-11-08 23:37:36,292 INFO  [1] oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader - running: true
2021-11-08 23:37:36,292 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - Is switchSession: false & get cloned home : false
2021-11-08 23:37:36,292 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - The final bootstrap path is  /oracle/app/19.8.0/grid
2021-11-08 23:37:36,294 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHandler - Space available: 47491 MB
2021-11-08 23:37:36,296 INFO  [1] oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader - running: true
2021-11-08 23:37:36,296 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - indexOfRemote: -1
2021-11-08 23:37:36,296 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - currentUser: root
2021-11-08 23:37:36,297 INFO  [1] com.oracle.glcm.patch.auto.db.util.PatchReaderUtil - Patch information is :  [Patch Location: /oracle/software/patch/19.13/33248471/33182768]
2021-11-08 23:37:36,297 INFO  [1] com.oracle.glcm.patch.auto.db.util.PatchReaderUtil - Patch information is :  [Patch Location: /oracle/software/patch/19.13/33248471/33182768, Patch Base Directory: null, Patch Id: null]
2021-11-08 23:37:36,301 INFO  [1] com.oracle.glcm.patch.auto.db.util.PatchPlatformValidator - Patch Aru ids are:[226]
2021-11-08 23:37:36,302 INFO  [1] com.oracle.glcm.patch.auto.db.util.PatchPlatformValidator - Platform Aru id:226
2021-11-08 23:37:36,302 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHandler - The patchInfo is : com.oracle.glcm.patch.auto.session.PatchInfoImpl@3b088d51
2021-11-08 23:37:36,303 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapController - The bootstrap params are: BootstrapParams [baseLocation=/oracle/app/19.8.0/grid, operationType=APPLY, homes=null, customLogDir=/oracle/app/19.8.0/grid/cfgtoollogs, customConfigDir=/oracle/app/19.8.0/grid/opatchautocfg/db, invPtrLocation=/oracle/app/19.8.0/grid/oraInst.loc, isRemotePatching=false, isOOPPatching=false, patchInfo=com.oracle.glcm.patch.auto.session.PatchInfoImpl@3b088d51, credential=null, gridHome=/oracle/app/19.8.0/grid, gridVersion=19.0.0.0.0, isBinaryPatching=false, isShardSidbPatching=false, isStandaloneSidbPatching=false, pathWithFilesFromLoc=null]
2021-11-08 23:37:36,303 INFO  [1] com.oracle.glcm.patch.auto.db.utils.BootstrapUtil - Creating boostrap dir: /oracle/app/19.8.0/grid/opatchautocfg/db/dbtmp/bootstrap_SSDSJ-ORADBN1
2021-11-08 23:37:36,304 INFO  [1] com.oracle.glcm.patch.auto.db.utils.BootstrapUtil - Creating patchwork dir: /oracle/app/19.8.0/grid/opatchautocfg/db/dbtmp/bootstrap_SSDSJ-ORADBN1/patchwork
2021-11-08 23:37:36,304 INFO  [1] com.oracle.glcm.patch.auto.db.utils.BootstrapUtil - Changing permission of bootstrap dir and sub-dir
2021-11-08 23:39:23,390 INFO  [1] com.oracle.glcm.patch.auto.db.product.executor.GISystemCall - Is retry required=false

复制

思路

1. 诱敌深入，或者欲让之灭亡，先欲之疯狂–让它提供更多的信息（日志）

2. 提取蛛丝马迹–关键词

3. 巧借东风，他人之石，可以攻玉–搜索mos

方法

1. 输出所有的日志

/oracle/app/19.8.0/grid/OPatch/opatchauto apply /oracle/software/patch/19.13/33248471/33182768 -analyze -LogLevel all

复制

2. 提取后台日志的关键信息

[root@Chenzq opatchautodb]# tail bootstrap2021-11-08_11-55-35PM.log
2021-11-08 23:55:35,848 FINEST [1] com.oracle.glcm.patch.auto.db.framework.sdk.patchplanner.PatchPlanEnv - Found property NodeNumberPerReadme
2021-11-08 23:55:35,848 FINEST [1] com.oracle.glcm.patch.auto.db.framework.sdk.patchplanner.PatchPlanEnv - Found property MoveConfigToOH
2021-11-08 23:55:35,849 FINEST [1] com.oracle.glcm.patch.auto.db.framework.sdk.patchplanner.PatchPlanEnv - Found property SelectivePatchingEnabled
2021-11-08 23:55:35,849 FINEST [1] com.oracle.glcm.patch.auto.db.framework.sdk.patchplanner.PatchPlanEnv - Found property MinimumOPatchVersion
2021-11-08 23:55:35,849 FINEST [1] com.oracle.glcm.patch.auto.db.framework.sdk.patchplanner.PatchPlanEnv - Found property IntgFactoryClass
2021-11-08 23:55:35,849 FINEST [1] com.oracle.glcm.patch.auto.db.framework.sdk.patchplanner.PatchPlanEnv - Found property customLogPath
2021-11-08 23:55:35,849 FINEST [1] com.oracle.glcm.patch.auto.db.framework.sdk.patchplanner.PatchPlanEnv - Found property ConfigurationSnapshot
2021-11-08 23:55:35,849 FINEST [1] com.oracle.glcm.patch.auto.db.framework.sdk.patchplanner.PatchPlanEnv - Found property ConsoleLogLevel
2021-11-08 23:55:35,850 FINEST [1] com.oracle.glcm.patch.auto.db.framework.sdk.patchplanner.PatchPlanEnv - Found property LogFileLevel
2021-11-08 23:55:35,857 FINE  [1] com.oracle.glcm.patch.auto.db.product.executor.GISystemCall - System Call command is: [/bin/su, root, -m, -c, chmod 775 /oracle/app/19.8.0/grid/opatchautocfg/db/dbtmp/bootstrap_Chenzq1]
[root@Chenzq1 opatchautodb]# pwd
/oracle/app/19.8.0/grid/cfgtoollogs/opatchautodb
[root@Chenzq1 opatchautodb]# 

复制

patch.auto.db.product.executor.GISystemCall opatchauto

  • 从上面看，当oracle用户或者grid使用su命令时，就卡住了，也没报错。初步判断为权限的问题。但也没有思路查看哪里限制了。
  • 如果系统知识扎实的话，应该会想到是限制su的检验了。

3. 搜索mos

patch.auto.db.product.executor.GISystemCall opatchauto
找到了
发现mos提供的解释是：

  1. 原因：/etc/pam.d/su配置了限制只有某组成员来使用su权限。
  2. 方法：注释auth required pam_wheel.so group=wheel即可。

验证

重跑检验补丁冲突检查与解决的命令行

/oracle/app/19.8.0/grid/OPatch/opatchauto apply /oracle/software/patch/19.13/33248471/33182768 -analyze

检查前后台日志

前台日志（显示通过了hang住的部分了）

[root@Chenzq1 grid]# /oracle/app/19.8.0/grid/OPatch/opatchauto apply /oracle/software/patch/19.13/33248471/33182768 -analyze 

OPatchauto session is initiated at Tue Nov  9 00:14:18 2021

System initialization log file is /oracle/app/19.8.0/grid/cfgtoollogs/opatchautodb/systemconfig2021-11-09_12-14-21AM.log.

Session log file is /oracle/app/19.8.0/grid/cfgtoollogs/opatchauto/opatchauto2021-11-09_12-15-07AM.log
The id for this session is F1TC
。。。。。。

复制

后台日志（显示通过了）

2021-11-09 00:14:19,240 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - indexOfRemote: -1
2021-11-09 00:14:19,242 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - currentUser: root
2021-11-09 00:14:19,283 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - indexOfRemote: -1
2021-11-09 00:14:19,283 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - currentUser: root
2021-11-09 00:14:19,316 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHandler - Processing common bootstrap parameters.
2021-11-09 00:14:19,464 INFO  [1] oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader - crsType: CRS
2021-11-09 00:14:19,542 INFO  [1] oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader - running: true
2021-11-09 00:14:19,631 INFO  [1] oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader - running: true
2021-11-09 00:14:19,631 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - Is switchSession: false & get cloned home : false
2021-11-09 00:14:19,631 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - The final bootstrap path is  /oracle/app/19.8.0/grid
2021-11-09 00:14:19,634 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHandler - Space available: 47482 MB
2021-11-09 00:14:19,636 INFO  [1] oracle.dbsysmodel.driver.sdk.productdriver.ClusterInformationLoader - running: true
2021-11-09 00:14:19,636 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - indexOfRemote: -1
2021-11-09 00:14:19,636 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHelper - currentUser: root
2021-11-09 00:14:19,637 INFO  [1] com.oracle.glcm.patch.auto.db.util.PatchReaderUtil - Patch information is :  [Patch Location: /oracle/software/patch/19.13/33248471/33182768]
2021-11-09 00:14:19,638 INFO  [1] com.oracle.glcm.patch.auto.db.util.PatchReaderUtil - Patch information is :  [Patch Location: /oracle/software/patch/19.13/33248471/33182768, Patch Base Directory: null, Patch Id: null]
2021-11-09 00:14:19,643 INFO  [1] com.oracle.glcm.patch.auto.db.util.PatchPlatformValidator - Patch Aru ids are:[226]
2021-11-09 00:14:19,645 INFO  [1] com.oracle.glcm.patch.auto.db.util.PatchPlatformValidator - Platform Aru id:226
2021-11-09 00:14:19,645 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapHandler - The patchInfo is : com.oracle.glcm.patch.auto.session.PatchInfoImpl@3b088d51
2021-11-09 00:14:19,645 INFO  [1] com.oracle.glcm.patch.auto.db.util.BootstrapController - The bootstrap params are: BootstrapParams [baseLocation=/oracle/app/19.8.0/grid, operationType=APPLY, homes=null, customLogDir=/oracle/app/19.8.0/grid/cfgtoollogs, customConfigDir=/oracle/app/19.8.0/grid/opatchautocfg/db, invPtrLocation=/oracle/app/19.8.0/grid/oraInst.loc, isRemotePatching=false, isOOPPatching=false, patchInfo=com.oracle.glcm.patch.auto.session.PatchInfoImpl@3b088d51, credential=null, gridHome=/oracle/app/19.8.0/grid, gridVersion=19.0.0.0.0, isBinaryPatching=false, isShardSidbPatching=false, isStandaloneSidbPatching=false, pathWithFilesFromLoc=null]
2021-11-09 00:14:19,645 INFO  [1] com.oracle.glcm.patch.auto.db.utils.BootstrapUtil - Creating boostrap dir: /oracle/app/19.8.0/grid/opatchautocfg/db/dbtmp/bootstrap_SSDSJ-ORADBN1
2021-11-09 00:14:19,647 INFO  [1] com.oracle.glcm.patch.auto.db.utils.BootstrapUtil - Creating patchwork dir: /oracle/app/19.8.0/grid/opatchautocfg/db/dbtmp/bootstrap_SSDSJ-ORADBN1/patchwork
2021-11-09 00:14:19,647 INFO  [1] com.oracle.glcm.patch.auto.db.utils.BootstrapUtil - Changing permission of bootstrap dir and sub-dir
2021-11-09 00:14:19,855 INFO  [1] com.oracle.glcm.patch.auto.db.utils.BootstrapUtil - Changing owner of bootstrap dir and sub-dir
2021-11-09 00:14:19,951 INFO  [1] oracle.glcm.opatch.common.impl.PatchFactoryImpl - Registering:SYSTEM_PATCH:oracle.glcm.opatch.common.impl.SystemPatch
2021-11-09 00:14:19,952 INFO  [1] oracle.glcm.opatch.common.impl.PatchFactoryImpl - Registering:COMPOSITE_PATCH:oracle.glcm.opatch.common.impl.CompositePatch
2021-11-09 00:14:19,952 INFO  [1] oracle.glcm.opatch.common.impl.PatchFactoryImpl - Registering:SINGLETON_PATCH:oracle.glcm.opatch.common.impl.SingletonPatch

复制

总结

1. 遇事不惊，量子力学，善于发挥主能动性，主动寻找问题的信息。

2. 请教别人不丢人。别人一句话，胜读十年书。节约自己的时间就是节约生命，相当于踩在前人的肩膀（积累）上看风景（更进一步）。

3. 遇事常总结归纳，常回顾。

chen_dba_o
最后修改时间：2021-11-09 09:12:24
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
1人已赞赏
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

评论

畅
畅谈Fintech
关注
117
文章
43
粉丝
107K+
浏览量
暂无图片
获得了17次点赞
暂无图片
内容获得10次评论
暂无图片
获得了56次收藏
TA的专栏
Oracle
收录1篇内容
MySQL Go
收录3篇内容
热门文章
Oracle DG的归档缺失修复
2021-03-10 4324浏览
VIP不在集群：CRS-2805: Unable to start 'ora.LISTENER.lsnr'
2021-01-27 2153浏览
MySQL指定账号加密方式的方法
2020-02-21 2065浏览
Create Database（Mysql建库）
2020-02-21 1457浏览
RAC多路径复用Controlfile
2020-02-14 1274浏览
最新文章
在线reduild索引的故障
2021-11-17 1270浏览
只读表的导出导入
2021-11-04 505浏览
Oracle DG的归档缺失修复
2021-03-10 4324浏览
VIP不在集群：CRS-2805: Unable to start 'ora.LISTENER.lsnr'
2021-01-27 2153浏览
Create Table 创建一个表在MySQL里
2020-02-21 1035浏览
目录
  • 背景
  • 思路
    • 1. 诱敌深入，或者欲让之灭亡，先欲之疯狂–让它提供更多的信息（日志）
    • 2. 提取蛛丝马迹–关键词
    • 3. 巧借东风，他人之石，可以攻玉–搜索mos
  • 方法
    • 1. 输出所有的日志
    • 2. 提取后台日志的关键信息
    • 3. 搜索mos
  • 验证
    • 重跑检验补丁冲突检查与解决的命令行
    • 检查前后台日志
    • 前台日志（显示通过了hang住的部分了）
    • 后台日志（显示通过了）
  • 总结
    • 1. 遇事不惊，量子力学，善于发挥主能动性，主动寻找问题的信息。
    • 2. 请教别人不丢人。别人一句话，胜读十年书。节约自己的时间就是节约生命，相当于踩在前人的肩膀（积累）上看风景（更进一步）。
    • 3. 遇事常总结归纳，常回顾。