联系:手机/微信(+86 17813235971) QQ(107644445)
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
在给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操作一切正常,没有再出现其他问题.