暂无图片
Oracle 12.2 升级补丁执行datapatch -verbose报错
我来答
分享
只此无云
2024-04-07
Oracle 12.2 升级补丁执行datapatch -verbose报错

版本:12.2.0.1.0

操作系统:Linux oradb 5.10.134-13.an8.x86_64


故障:datapatch -verbose 执行报错

[oracle@oradb 33583921]$ /u01/SOFT/p6880880/OPatch/datapatch -verbose

SQL Patching tool version 12.2.0.1.0 Production on Sun Apr 7 18:24:11 2024
Copyright (c) 2012, 2021, Oracle. All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29104_2024_04_07_18_24_11/sqlpatch_invocation.log

Connecting to database...OK
Note: Datapatch will only apply or rollback SQL fixes for PDBs
that are in an open state, no patches will be applied to closed PDBs.
Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and package to current versions...done

Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'
and/or check the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29104_2024_04_07_18_24_11/sqlpatch_invocation.log
for the complete error.
Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_29104_2024_04_07_18_24_11/sqlpatch_invocation.log
for information on how to resolve the above errors.

SQL Patching tool complete on Sun Apr 7 18:24:23 2024
[oracle@oradb 33583921]$


SQL> select dbms_sqlpatch.verify_queryable_inventory from dual;

VERIFY_QUERYABLE_INVENTORY
--------------------------------------------------------------------------------
ORA-20001: Latest xml inventory is not loaded into table

SQL> select * from opatch_xml_inv;
ERROR:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04095: preprocessor command
/u01/app/oracle/product/12.2.0/db_1/QOpatch/qopiprep.bat encountered error
"Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
LsInventorySession failed: Unable to create patchObject Possible causes are:"

no rows selected

SQL> 

我来答
添加附件
收藏
分享
问题补充
6条回答
默认
最新
只此无云
上传附件:sqlpatch_invocation.log
暂无图片 评论
暂无图片 有用 0
只此无云

升级的这个补丁  p33583921/33583921/33587128


暂无图片 评论
暂无图片 有用 1
一般

看一下/etc/oraInst.loc的文件权限和内容

参考一下这个https://blog.csdn.net/weixin_35725138/article/details/116412889

暂无图片 评论
暂无图片 有用 0
只此无云
题主
2024-04-09
这个文件用户和属主都是root,内容如下 [root@oradb etc]# ls -ll ora* -rw-r--r-- 1 root root 52 Apr 7 16:26 oraInst.loc -rw-rw-r-- 1 oracle oinstall 787 Apr 7 16:26 oratab [root@oradb etc]# cat oraInst.loc inventory_loc=/u01/oraInventory inst_group=oinstall [root@oradb etc]#
一般

ls /u01/oraInventory看看

暂无图片 评论
暂无图片 有用 0
只此无云
题主
2024-04-10
[root@oradb ~]# ls -ll /u01/oraInventory total 8 drwxrwx--- 2 oracle oinstall 60 Apr 7 16:25 ContentsXML drwxrwx--- 2 oracle oinstall 219 Apr 7 18:04 logs -rw-rw---- 1 oracle oinstall 52 Apr 7 16:25 oraInst.loc -rwxrwx--- 1 oracle oinstall 1584 Apr 7 16:25 orainstRoot.sh drwxrwx--- 2 oracle oinstall 22 Apr 7 16:22 oui [root@oradb ~]#
一般

$OARCLE_HOME/OPatch/opatch lsinventory正常吗?

暂无图片 评论
暂无图片 有用 0
只此无云
题主
2024-04-10
感觉像是正常的样。 [oracle@oradb 33587128]$ /u01/SOFT/p6880880/OPatch/opatch lsinventory | grep 33587128 Patch 33587128 : applied on Sun Apr 07 18:07:43 CST 2024 Patch description: "Database Jan 2022 Release Update : 12.2.0.1.220118 (33587128)" [oracle@oradb 33587128]$
一般

输出是正常的,可以考虑我前面提供的网址重建一下orainventory

暂无图片 评论
暂无图片 有用 0
只此无云
题主
2024-04-12
好的,我试下。
回答交流
提交
问题信息
请登录之后查看
附件列表
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏