标签云
asm恢复 bbed bootstrap$ dul In Memory kcbzib_kcrsds_1 kccpb_sanity_check_2 MySQL恢复 ORA-00312 ORA-00607 ORA-00704 ORA-00742 ORA-01110 ORA-01555 ORA-01578 ORA-08103 ORA-600 2131 ORA-600 2662 ORA-600 2663 ORA-600 3020 ORA-600 4000 ORA-600 4137 ORA-600 4193 ORA-600 4194 ORA-600 16703 ORA-600 kcbzib_kcrsds_1 ORA-600 KCLCHKBLK_4 ORA-15042 ORA-15196 ORACLE 12C oracle dul ORACLE PATCH Oracle Recovery Tools oracle加密恢复 oracle勒索 oracle勒索恢复 oracle异常恢复 Oracle 恢复 ORACLE恢复 ORACLE数据库恢复 oracle 比特币 OSD-04016 YOUR FILES ARE ENCRYPTED 勒索恢复 比特币加密文章分类
- Others (2)
- 中间件 (2)
- WebLogic (2)
- 操作系统 (103)
- 数据库 (1,734)
- DB2 (22)
- MySQL (75)
- Oracle (1,585)
- Data Guard (52)
- EXADATA (8)
- GoldenGate (24)
- ORA-xxxxx (160)
- ORACLE 12C (72)
- ORACLE 18C (6)
- ORACLE 19C (15)
- ORACLE 21C (3)
- Oracle 23ai (8)
- Oracle ASM (68)
- Oracle Bug (8)
- Oracle RAC (54)
- Oracle 安全 (6)
- Oracle 开发 (28)
- Oracle 监听 (28)
- Oracle备份恢复 (580)
- Oracle安装升级 (95)
- Oracle性能优化 (62)
- 专题索引 (5)
- 勒索恢复 (82)
- PostgreSQL (27)
- pdu工具 (5)
- PostgreSQL恢复 (9)
- SQL Server (28)
- SQL Server恢复 (9)
- TimesTen (7)
- 达梦数据库 (2)
- 生活娱乐 (2)
- 至理名言 (11)
- 虚拟化 (2)
- VMware (2)
- 软件开发 (37)
- Asp.Net (9)
- JavaScript (12)
- PHP (2)
- 小工具 (20)
-
最近发表
- win平台19c 打patch遭遇2个小问题汇总
- pg单个数据库目录恢复-pdu恢复单个数据库目录数据
- pg删除数据恢复—pdu恢复pg delete数据
- .[OnlyBuy@cyberfear.com].REVRAC勒索mysql恢复
- 表dml操作权限授权给public,导致只读用户失效
- 21c数据库恢复遭遇ora-600 ktugct: corruption detected
- pg_control丢失/损坏处理
- 当前主流数据库版本服务支持周期-202503
- pg启动报invalid checkpoint record处理
- 删除redo导致ORA-00313 ORA-00312故障处理
- Navicat连接postgresql时出现column “datlastsysoid” does not exist错误解决
- aix磁盘损坏oracle数据库恢复
- pg误删除数据恢复(PostgreSQL delete数据恢复)
- PostgreSQL表文件损坏恢复—pdu恢复损坏的表文件
- linux rm -rf 删除数据文件恢复
- PostgreSQL恢复工具—pdu恢复单个表文件
- PostgreSQL恢复工具—pdu工具介绍
- 近1万个数据文件的恢复case
- 不当使用_allow_resetlogs_corruption参数引起ORA-600 2662错误
- CSSD signal 11 in thread clssnmRcfgMgrThread故障处理
标签归档:OUI-67073
win平台19c 打patch遭遇2个小问题汇总
在给19c的库打ru patch的过程中遇到两个错误,进行记录,以供以后遇到类似错误参考:
UtilSession 失败: oracle/cluster/install/InstallException
C:\Users\Administrator>F:\updatecode\WINDOWS.X64_193000_db_home\opatch\opatch apply F:\oracle_patch\37486199 Oracle 临时补丁程序安装程序版本 12.2.0.1.45 版权所有 (c) 2025, Oracle Corporation。保留所有权利。 Oracle 主目录 :F:\updatecode\WINDOWS.X64_193000_db_home 主产品清单:C:\Program Files\Oracle\Inventory 来自 : OPatch 版本 :12.2.0.1.45 OUI 版本 :12.2.0.7.0 日志文件位置:F:\updatecode\WINDOWS.X64_193000_db_home\cfgtoollogs\opatch\opatch2025-03-17_18-19-56下午_1.log Verifying environment and performing prerequisite checks... UtilSession 失败: oracle/cluster/install/InstallException Log file location: F:\updatecode\WINDOWS.X64_193000_db_home\cfgtoollogs\opatch\opatch2025-03-17_18-19-56下午_1.log OPatch failed with error code = 73
对应的日志错误部分
[2025-3-17 18:19:57] [INFO] CAS Dynamic Loading : [2025-3-17 18:19:57] [INFO] CUP_LOG: Trying to load HomeOperations object [2025-3-17 18:19:57] [INFO] CUP_LOG: HomeOperations object created. CUP1.0 is enabled [2025-3-17 18:19:57] [INFO] OPatch invoked as follows: 'apply F:\oracle_patch\37486199 ' [2025-3-17 18:19:57] [INFO] Runtime args: [-DOPatch.ORACLE_HOME=F:\updatecode\WINDOWS.X64_193000_db_home, -DOPatch.DEBUG=false, -DOPatch.RUNNING_DIR=F:\updatecode\WINDOWS.X64_193000_db_home\OPatch, -DOPatch.MW_HOME=, -DOPatch.WL_HOME=, -DOPatch.COMMON_COMPONENTS_HOME=, -DOPatch.OUI_LOCATION=, -DOPatch.FMW_COMPONENT_HOME=, -DOPatch.WEBLOGIC_CLASSPATH=, -DOPatch.OPATCH_CLASSPATH=] [2025-3-17 18:19:57] [INFO] Heap in use : 120 MB Total memory: 1917 MB Free memory : 1796 MB Max memory : 27305 MB [2025-3-17 18:19:57] [INFO] Oracle 主目录 : F:\updatecode\WINDOWS.X64_193000_db_home 主产品清单: C:\Program Files\Oracle\Inventory 从 : OPatch 版本 : 12.2.0.1.45 OUI 版本 : 12.2.0.7.0 OUI 位置 : F:\updatecode\WINDOWS.X64_193000_db_home\oui 日志文件位置 : F:\updatecode\WINDOWS.X64_193000_db_home\cfgtoollogs\opatch\opatch2025-03-17_18-19-56下午_1.log [2025-3-17 18:19:57] [INFO] Patch history file: F:\updatecode\WINDOWS.X64_193000_db_home\cfgtoollogs\opatch\opatch_history.txt [2025-3-17 18:19:59] [INFO] [OPSR-TIME] Loading raw inventory [2025-3-17 18:20:00] [INFO] [OPSR-MEMORY] Loaded all components from inventory. Heap memory in use: 150 (MB) [2025-3-17 18:20:00] [INFO] [OPSR-MEMORY] Loaded all one offs from inventory. Heap memory in use: 160 (MB) [2025-3-17 18:20:00] [INFO] [OPSR-TIME] Raw inventory loaded successfully [2025-3-17 18:20:00] [INFO] NApply::no CAS enabled, OPatch runs with legacy process. [2025-3-17 18:20:00] [INFO] Verifying environment and performing prerequisite checks... [2025-3-17 18:20:00] [INFO] [OPSR-TIME] Running prerequisite checks [2025-3-17 18:20:00] [INFO] opatch-external.jar is in F:\updatecode\WINDOWS.X64_193000_db_home\OPatch\jlib\opatch-external.jar [2025-3-17 18:20:00] [SEVERE] OUI-67073:UtilSession 失败: oracle/cluster/install/InstallException [2025-3-17 18:20:00] [INFO] Finishing UtilSession at Mon Mar 17 18:20:00 CST 2025 [2025-3-17 18:20:00] [INFO] 堆栈说明: java.lang.RuntimeException: oracle/cluster/install/InstallException at java.lang.Class.getDeclaredConstructors0(Native Method) at java.lang.Class.privateGetDeclaredConstructors(Class.java:2671) at java.lang.Class.getConstructor0(Class.java:3075) at java.lang.Class.getConstructor(Class.java:1825) at oracle.opatch.OPatchExternalFactory.getRac(OPatchExternalFactory.java:158) at oracle.opatch.napplyhelper.EnvValidation.validateConnectStringNodes(EnvValidation.java:104) at oracle.opatch.napplyhelper.EnvValidation.checkConnectString(EnvValidation.java:92) at oracle.opatch.napplyhelper.EnvValidation.validate(EnvValidation.java:64) at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:530) at oracle.opatch.opatchutil.NApply.legacy_process(NApply.java:374) at oracle.opatch.opatchutil.NApply.process(NApply.java:354) at oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1143) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at oracle.opatch.UtilSession.process(UtilSession.java:355) at oracle.opatch.OPatchSession.process(OPatchSession.java:2640) at oracle.opatch.OPatch.process(OPatch.java:888) at oracle.opatch.OPatch.main(OPatch.java:945) Caused by: java.lang.NoClassDefFoundError: oracle/cluster/install/InstallException ... 20 more Caused by: java.lang.ClassNotFoundException: oracle.cluster.install.InstallException at java.net.URLClassLoader.findClass(URLClassLoader.java:387) at java.lang.ClassLoader.loadClass(ClassLoader.java:418) at java.lang.ClassLoader.loadClass(ClassLoader.java:351) ... 20 more
通过mos给出来的文档:Windows:opatch file with error: [SEVERE] OUI-67073:UtilSession failed: oracle/cluster/install/InstallException (Doc ID 3020534.1),可能是由于%ORACLE_HOME%\oui\jlib\srvm.jar 文件异常导致该问题,查看打patch机器,发现该文件丢失[丢失原因未知],从37486199的patch文件中拷贝该文件到数据库对应目录,后续没有再报该错误
然后提示Prerequisite check “CheckActiveFilesAndExecutables” failed.错误
注意参考:win平台 UtilSession 失败: Prerequisite check “CheckActiveFilesAndExecutables” failed. 处理没有解决问题(因为文件本身没有被占用)
F:\oracle_patch\37486199>F:\updatecode\WINDOWS.X64_193000_db_home\opatch\opatch apply Oracle 临时补丁程序安装程序版本 12.2.0.1.45 版权所有 (c) 2025, Oracle Corporation。保留所有权利。 Oracle 主目录 :F:\updatecode\WINDOWS.X64_193000_db_home 主产品清单:C:\Program Files\Oracle\Inventory 来自 : OPatch 版本 :12.2.0.1.45 OUI 版本 :12.2.0.7.0 日志文件位置:F:\updatecode\WINDOWS.X64_193000_db_home\cfgtoollogs\opatch\opatch2025-03-17_18-34-40下午_1.log Verifying environment and performing prerequisite checks... Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are: Following active files/executables/libs are used by ORACLE_HOME :F:\updatecode\WINDOWS.X64_193000_db_home F:\updatecode\WINDOWS.X64_193000_db_home\bin\oravssmsgus.dll F:\updatecode\WINDOWS.X64_193000_db_home\bin\ORAEVRUS19.dll UtilSession 失败: Prerequisite check "CheckActiveFilesAndExecutables" failed. Log file location: F:\updatecode\WINDOWS.X64_193000_db_home\cfgtoollogs\opatch\opatch2025-03-17_18-34-40下午_1.log OPatch failed with error code = 73
通过命令分析确认oravssmsgus.ddl和ORAEVRUS19.dll动态库没有被其他程序占用
F:\oracle_patch\37486199>tasklist /M ora* 信息: 没有运行的任务匹配指定标准。 F:\oracle_patch\37486199>tasklist /M ORA* 信息: 没有运行的任务匹配指定标准。
对于这种情况,根据mos文档:Database Release Update Bundle Windows Patch (XXX) Error”UtilSession failed: Prerequisite check “CheckActiveFilesAndExecutables” failed.” (Doc ID 3046640.1)建议,把对一个文件重命名
F:\updatecode\WINDOWS.X64_193000_db_home\bin>dir *bak.dll 驱动器 F 中的卷是 安全区 卷的序列号是 4407-E854 F:\updatecode\WINDOWS.X64_193000_db_home\bin 的目录 2022-07-28 17:35 4,096 ORAEVRUS19-bak.dll 2022-07-28 17:35 100,352 oravssmsgus-bak.dll 2 个文件 104,448 字节 0 个目录 680,382,025,728 可用字节
后续打patch操作一切正常,没有再出现其他问题.