暂无图片
oracle11g单节点asm升级grid补丁失败问题
我来答
分享
maoxiang123
2021-04-05
oracle11g单节点asm升级grid补丁失败问题
暂无图片 10M

环境:oracle linux 6.9+oracle 11.2.0.4
补丁:p31718723_112040_Linux-x86-64
opatch版本:11.2.0.3.25

补丁要求opatch版本:
You must use the OPatch utility version 11.2.0.3.23 or later to apply this patch.

这个版本不需要配置ocm,直接opatch auto安装
image.png

但是用root用户进行补丁安装时报错
image.png

检查了权限貌似无问题,以下是错误日志,提示需要升级opatch版本?

ZOP-50: The patch location is not valid because it may not exist (or) current user has no permission to access it. Please check the same.
Argument(s) Error… Patch Location not valid

Please check the arguments and try again.

OPatch failed with error code 135

2021-04-05 21:45:12: Status of opatch version check for /u01/app/oracle/product/11.2.0.4/db_home is 0
2021-04-05 21:45:12: Opatch version check failed for oracle home /u01/app/oracle/product/11.2.0.4/db_home
2021-04-05 21:45:12: Processing oracle home /u01/app/11.2.0.4/grid
2021-04-05 21:45:12: Oracle user for /u01/app/11.2.0.4/grid is grid
2021-04-05 21:45:12: Oracle user for /u01/app/11.2.0.4/grid is grid
2021-04-05 21:45:12: Running as user grid: /u01/app/11.2.0.4/grid/OPatch/opatch version -oh /u01/app/11.2.0.4/grid
2021-04-05 21:45:12: s_run_as_user2: Running /bin/su grid -c ’ /u01/app/11.2.0.4/grid/OPatch/opatch version -oh /u01/app/11.2.0.4/grid ’
2021-04-05 21:45:12: Removing file /tmp/file89vVQx
2021-04-05 21:45:12: Successfully removed file: /tmp/file89vVQx
2021-04-05 21:45:12: /bin/su successfully executed

2021-04-05 21:45:12: opatch version in oracle home /u01/app/11.2.0.4/grid is 11.2.0.3.25

2021-04-05 21:45:12: Running as user grid: /u01/app/11.2.0.4/grid/OPatch/opatch util checkMinimumOPatchVersion -ph /home/grid/31718723/29938455 -version 11.2.0.3.25 -oh /u01/app/11.2.0.4/grid
2021-04-05 21:45:12: s_run_as_user2: Running /bin/su grid -c ’ /u01/app/11.2.0.4/grid/OPatch/opatch util checkMinimumOPatchVersion -ph /home/grid/31718723/29938455 -version 11.2.0.3.25 -oh /u01/app/11.2.0.4/grid ’
2021-04-05 21:45:15: Removing file /tmp/fileHZp7tH
2021-04-05 21:45:15: Successfully removed file: /tmp/fileHZp7tH
2021-04-05 21:45:15: /bin/su successfully executed

2021-04-05 21:45:15: Running as user grid: /u01/app/11.2.0.4/grid/OPatch/opatch util checkMinimumOPatchVersion -ph /home/grid/31718723/31537677 -version 11.2.0.3.25 -oh /u01/app/11.2.0.4/grid
2021-04-05 21:45:15: s_run_as_user2: Running /bin/su grid -c ’ /u01/app/11.2.0.4/grid/OPatch/opatch util checkMinimumOPatchVersion -ph /home/grid/31718723/31537677 -version 11.2.0.3.25 -oh /u01/app/11.2.0.4/grid ’
2021-04-05 21:45:18: Removing file /tmp/fileY7vDi0
2021-04-05 21:45:18: Successfully removed file: /tmp/fileY7vDi0
2021-04-05 21:45:18: /bin/su successfully executed

2021-04-05 21:45:18: Running as user grid: /u01/app/11.2.0.4/grid/OPatch/opatch util checkMinimumOPatchVersion -ph /home/grid/31718723/29509309 -version 11.2.0.3.25 -oh /u01/app/11.2.0.4/grid
2021-04-05 21:45:18: s_run_as_user2: Running /bin/su grid -c ’ /u01/app/11.2.0.4/grid/OPatch/opatch util checkMinimumOPatchVersion -ph /home/grid/31718723/29509309 -version 11.2.0.3.25 -oh /u01/app/11.2.0.4/gr
id ’
2021-04-05 21:45:21: Removing file /tmp/filex7IQ8s
2021-04-05 21:45:21: Successfully removed file: /tmp/filex7IQ8s
2021-04-05 21:45:21: /bin/su successfully executed

2021-04-05 21:45:21: Status of opatch version check for /u01/app/11.2.0.4/grid is 1
2021-04-05 21:45:21: Opatch version check passed for oracle home /u01/app/11.2.0.4/grid
2021-04-05 21:45:21: Opatch version check failed
2021-04-05 21:45:21: ERROR: update the opatch version for the failed homes and retry

我来答
添加附件
收藏
分享
问题补充
3条回答
默认
最新
你好我是李白

提示你oracle rdbms home下的opatch版本失败啦。
grid补丁应该自带grid + rdbms的补丁,使用root auto不指定-oh的话,会自动将本节点的grid跟rdbms都进行校验,所以你把oracle rdbms的opatch升级一下,再试试。

暂无图片 评论
暂无图片 有用 0
打赏 0
暂无图片
maoxiang123

grid和oracle的opatch版本都是11.2.0.3.25

#按照readme文档中的case1运行就提示opatch版本需要升级
/u01/app/11.2.0.4/grid/OPatch/opatch auto /home/grid/31718723
复制
#在命令后加上-oh grid目录就正常了,不知为什么。。
/u01/app/11.2.0.4/grid/OPatch/opatch auto /home/grid/31718723 -oh /u01/app/11.2.0.4/grid
复制
暂无图片 评论
暂无图片 有用 0
打赏 0
你好我是李白

确实,之前也遇到过类似问题,也是只指定auto不指定-oh,各种出问题,之后一个一个指定-oh就正常了。

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
Oracle通过什么方式减少PL/SQL程序的单元迭代数量和迭代时间?
回答 1
已采纳
任何涉及循环逻辑的PL/SQL程序单元都可能存在大幅提高性能的空间。可以通过两种方式来改善这种类型程序的潜在性能。第一种方法是在保持功能性结果不变的前提下通过逻辑重构来减少迭代的次数;第二种方法是减少
Oracle里两段SQL有什么区别吗?
回答 4
已采纳
如果是分页的话,这两个分页sql都不对,至少要再套一层括号,你现在这两个sql相当于是取不排序的前150000行,对这个数据再进行排序,再取大于等于140000行。应该先orderby排完后,在外面取
oracle 无法连接,打算用来创建备库的,已经添加了静态监听?
回答 1
listener.ora内容发出来看看
oracle dump数据
回答 1
不包含。
Oracle delete expired archivelog all;和delete archivelog all;这两条命令执行效果有什么区别?
回答 2
已采纳
deleteexpiredarchivelogall;删除过期的归档,并更新v$archivedlog视图deletearchivelogall;将删除所有归档,包括未备份的归档日志
oracle导出的dmp文件 导入到本地 id最后变成#?
回答 1
字符集或者环境变量看一下对不对
oracle 11g 使用EXpdp 导出数据如何优化导出速度, CPU是32逻辑cpu
回答 4
已采纳
不到每秒10m的落地速度,瓶颈可能在数据库。看下是不是主要是几张表慢?这张表是否有lob类字段。是否有行链接、行迁移问题。
oracle授权kill权限
回答 4
已采纳
createuserPkillSessionidentifiedbyOraclekills;grantconnect,selectanytabletoPkillSession;SQL>grant
oracle10grac启动监听服务
回答 20
能描述更具体点嘛?有日志更好
Oracle ADG备库全量数据导出报错ora-01555
回答 1
调整参数UNDORETENTION 以秒每单位,举例:1、ALTERSYSTEMSETUNDORETENTION10800;2、更新clob字段属性ALTERTABLE表名MODIFYLOB