IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    win平台 UtilSession 失败: Prerequisite check “CheckActiveFilesAndExecutables” failed. 处理

    惜分飞发表于 2023-04-20 10:28:46
    love 0

    联系:手机/微信(+86 17813235971) QQ(107644445)QQ咨询惜分飞

    标题:win平台 UtilSession 失败: Prerequisite check “CheckActiveFilesAndExecutables” failed. 处理

    作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

    win平台打patch,提示UtilSession 失败: Prerequisite check “CheckActiveFilesAndExecutables” failed.

    C:\Users\Administrator\Desktop\nmgOracle补丁\34474433>E:\app\Administrator\produ
    ct\11.2.0\dbhome_1\OPatch\opatch apply ./
    Oracle 临时补丁程序安装程序版本 11.2.0.3.40
    版权所有 (c) 2023, Oracle Corporation。保留所有权利。
    
    
    Oracle 主目录       :E:\app\ADMINI~1\product\112~1.0\dbhome_1
    主产品清单:C:\Program Files\Oracle\Inventory
       来自           :
    OPatch 版本    :11.2.0.3.40
    OUI 版本       :11.2.0.4.0
    日志文件位置:E:\app\ADMINI~1\product\112~1.0\dbhome_1\cfgtoollogs\opatch\opatch
    2023-04-20_18-05-20下午_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 :E:\app\ADMINI~1
    \product\112~1.0\dbhome_1
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraxml11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orahasgen11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraocr11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraocrb11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraocrutl11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oran11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orantcp11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oranl11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orancrypt11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orapls11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orageneric11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraclient11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oracommon11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\rdbms\mesg\diaus.msb
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraplc11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraplp11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orannzsbb11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orazt11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraztkg11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraldapclnt11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oracore11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oracell11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraasmclnt11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orannzsbb11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\orazt11.dll
    E:\app\ADMINI~1\product\112~1.0\dbhome_1\bin\oraztkg11.dll
    
    UtilSession 失败: Prerequisite check "CheckActiveFilesAndExecutables" failed.
    Log file location: E:\app\ADMINI~1\product\112~1.0\dbhome_1\cfgtoollogs\opatch\o
    patch2023-04-20_18-05-20下午_1.log
    
    OPatch failed with error code = 73
    

    通过tasklist命令找出来占用的进程名称和进程号

    E:\app\Administrator\product\11.2.0\dbhome_1\OPatch>tasklist /M ora*
    
    映像名称                       PID 模块
    ========================= ======== ============================================
    esfdaemon.exe                 1296 oracleclientsvc.dll, oracleengine.dll,
                                       oracledatasource.dll, oraclecore.dll,
                                       OraClient11.Dll, oracore11.dll,
                                       oranls11.dll, oraunls11.dll, orauts.dll,
                                       oracommon11.dll, orasnls11.dll,
                                       orageneric11.dll, oraxml11.dll, oran11.dll,
                                       oranl11.dll, orantcp11.dll, oranldap11.dll,
                                       orannzsbb11.dll, oraldapclnt11.dll,
                                       orancrypt11.dll, orazt11.dll, oranro11.dll,
                                       oranhost11.dll, orancds11.dll,
                                       orantns11.dll, oraztkg11.dll, orapls11.dll,
                                       oraslax11.dll, oravsn11.dll, oraplp11.dll,
                                       orahasgen11.dll, oraocr11.dll,
                                       oraocrb11.dll, oraasmclnt11.dll,
                                       oracell11.dll, oraocrutl11.dll,
                                       orasql11.dll, OraPlc11.Dll, oranbeq11.dll
    plsqldev.exe                 29840 OraClient11.Dll, oracore11.dll,
                                       oranls11.dll, oraunls11.dll, orauts.dll,
                                       oracommon11.dll, orasnls11.dll,
                                       orageneric11.dll, oraxml11.dll, oran11.dll,
                                       oranl11.dll, orantcp11.dll, oranldap11.dll,
                                       orannzsbb11.dll, oraldapclnt11.dll,
                                       orancrypt11.dll, orazt11.dll, oranro11.dll,
                                       oranhost11.dll, orancds11.dll,
                                       orantns11.dll, oraztkg11.dll, orapls11.dll,
                                       oraslax11.dll, oravsn11.dll, oraplp11.dll,
                                       orahasgen11.dll, oraocr11.dll,
                                       oraocrb11.dll, oraasmclnt11.dll,
                                       oracell11.dll, oraocrutl11.dll,
                                       orasql11.dll, OraPlc11.Dll
    
    

    可以在任务管理器中直接把相关进程kill掉,也可以通过taskkill /F /im 进程名方式杀掉进程,然后再次检查占用情况,无任何进程占用的情况下,就可以直接打patch

    E:\app\Administrator\product\11.2.0\dbhome_1\OPatch>tasklist /M ora*
    信息: 没有运行的任务匹配指定标准。
    
    
    • delete expired backup报ORA-19606错误处理
    • Oracle Recovery Tools快速恢复重建ctl遗漏数据文件故障
    • 安装19c 数据库 libclntsh.so: file format not recognized
    • awr导出/导入/分析
    • 10.2.0.x升级到10.2.0.5.5
    • fuser命令缺失导致19c打补丁失败
    • open只有system文件的库
    • 11.2.0.4 打patch遭遇extjobO: Operation not permitted处理
    • 重建oraInventory解决ORA-20001
    • 使用bbed解决ORA-01178 file N created before last CREATE CONTROLFILE, cannot recreate
    • Oracle Recovery Tools快速恢复断电引起的无法正常启动数据库(ORA-01555,MISSING000等问题)
    • Oracle Recovery Tools解决ORA-00279 ORA-00289 ORA-00280故障


沪ICP备19023445号-2号
友情链接