oracle 11G 11.2.0.3.0 升级到11.2.0.3.6遇到的错误。

本文详细记录了一次使用opatch工具进行数据库补丁应用时遇到的错误日志解析过程,包括日志中显示的检查失败原因、存在的进程问题及其解决方法。通过分析日志信息,理解了为何补丁应用失败,并提供了具体的解决步骤,有助于避免类似问题再次发生。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

错误日志:

https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=pcs1vuhno_146&_afrLoop=40321988385944

 

[May 15, 2013 9:16:19 PM]    OPatch invoked as follows: 'apply -invPtrLoc /opt/oracle/datasoft/oraInst.loc '
[May 15, 2013 9:16:19 PM]    OUI-67077:
                             Oracle Home       : /opt/oracle/datasoft
                             Central Inventory : /opt/oraInventory
                                from           : /opt/oracle/datasoft/oraInst.loc
                             OPatch version    : 11.2.0.3.4
                             OUI version       : 11.2.0.3.0
                             OUI location      : /opt/oracle/datasoft/oui
                             Log file location : /opt/oracle/datasoft/cfgtoollogs/opatch/opatch2013-05-15_21-16-19PM_1.log
[May 15, 2013 9:16:19 PM]    Patch history file: /opt/oracle/datasoft/cfgtoollogs/opatch/opatch_history.txt
[May 15, 2013 9:16:22 PM]    Verifying environment and performing prerequisite checks...
[May 15, 2013 9:16:22 PM]    Ignoring file "/opt/oracle/datasoft/16056266/README.html" in the patch directory.
[May 15, 2013 9:16:22 PM]    Ignoring file "/opt/oracle/datasoft/16056266/README.txt" in the patch directory.
[May 15, 2013 9:16:22 PM]    Ignoring file "/opt/oracle/datasoft/16056266/patchmd.xml" in the patch directory.
[May 15, 2013 9:16:23 PM]    Checking conflict among patches...
[May 15, 2013 9:16:23 PM]    Patch ID  16056266
[May 15, 2013 9:16:23 PM]    Patches that conflict: [  ]
[May 15, 2013 9:16:23 PM]    Checking conflicts for patch : 16056266
[May 15, 2013 9:16:23 PM]    Checking if Oracle Home has components required by patches...
[May 15, 2013 9:16:23 PM]    Check if patch "13343438"  is a no-op patch.
[May 15, 2013 9:16:23 PM]    Check if patch "13696216"  is a no-op patch.
[May 15, 2013 9:16:23 PM]    Check if patch "13923374"  is a no-op patch.
[May 15, 2013 9:16:23 PM]    Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0
[May 15, 2013 9:16:23 PM]    [ oracle.network.cman, 11.2.0.3.0 ]
[May 15, 2013 9:16:23 PM]    Check if patch "14275605"  is a no-op patch.
[May 15, 2013 9:16:23 PM]    Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0
[May 15, 2013 9:16:23 PM]    [ oracle.precomp.lang, 11.2.0.3.0 ]
[May 15, 2013 9:16:23 PM]    Check if patch "14727310"  is a no-op patch.
[May 15, 2013 9:16:23 PM]    Check if patch "16056266"  is a no-op patch.
[May 15, 2013 9:16:23 PM]    Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0
[May 15, 2013 9:16:23 PM]    [ oracle.network.cman, 11.2.0.3.0 ]
[May 15, 2013 9:16:23 PM]    Running prerequisite checks...
[May 15, 2013 9:16:23 PM]    Patch "13343438" is ignored as it is not a "Fusion Applications patch".
[May 15, 2013 9:16:23 PM]    Patch "13696216" is ignored as it is not a "Fusion Applications patch".
[May 15, 2013 9:16:23 PM]    Patch "13923374" is ignored as it is not a "Fusion Applications patch".
[May 15, 2013 9:16:23 PM]    Patch "14275605" is ignored as it is not a "Fusion Applications patch".
[May 15, 2013 9:16:23 PM]    Patch "14727310" is ignored as it is not a "Fusion Applications patch".
[May 15, 2013 9:16:23 PM]    Patch "16056266" is ignored as it is not a "Fusion Applications patch".
[May 15, 2013 9:16:23 PM]    Check if patch "13343438"  is a no-op patch.
[May 15, 2013 9:16:23 PM]    Check if patch "13696216"  is a no-op patch.
[May 15, 2013 9:16:23 PM]    Check if patch "13923374"  is a no-op patch.
[May 15, 2013 9:16:23 PM]    Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0
[May 15, 2013 9:16:23 PM]    [ oracle.network.cman, 11.2.0.3.0 ]
[May 15, 2013 9:16:23 PM]    Check if patch "14275605"  is a no-op patch.
[May 15, 2013 9:16:23 PM]    Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0
[May 15, 2013 9:16:23 PM]    [ oracle.precomp.lang, 11.2.0.3.0 ]
[May 15, 2013 9:16:23 PM]    Check if patch "14727310"  is a no-op patch.
[May 15, 2013 9:16:23 PM]    Check if patch "16056266"  is a no-op patch.
[May 15, 2013 9:16:23 PM]    Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0
[May 15, 2013 9:16:23 PM]    [ oracle.network.cman, 11.2.0.3.0 ]
[May 15, 2013 9:16:23 PM]    None of the selected patches are no-op. patches..
[May 15, 2013 9:16:23 PM]    Space Needed : 237.072MB
[May 15, 2013 9:16:23 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 13343438
[May 15, 2013 9:16:23 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 13696216
[May 15, 2013 9:16:23 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 13923374
[May 15, 2013 9:16:23 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 14275605
[May 15, 2013 9:16:24 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 14727310
[May 15, 2013 9:16:24 PM]    Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 16056266
[May 15, 2013 9:16:24 PM]    Start fuser command /sbin/fuser /opt/oracle/datasoft/bin/oracle at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Finish fuser command /sbin/fuser /opt/oracle/datasoft/bin/oracle at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Start fuser command /sbin/fuser /opt/oracle/datasoft/bin/asmcmdcore at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Finish fuser command /sbin/fuser /opt/oracle/datasoft/bin/asmcmdcore at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Start fuser command /sbin/fuser /opt/oracle/datasoft/bin/renamedg at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Finish fuser command /sbin/fuser /opt/oracle/datasoft/bin/renamedg at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Start fuser command /sbin/fuser /opt/oracle/datasoft/bin/nid at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Finish fuser command /sbin/fuser /opt/oracle/datasoft/bin/nid at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Start fuser command /sbin/fuser /opt/oracle/datasoft/bin/tnslsnr at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Finish fuser command /sbin/fuser /opt/oracle/datasoft/bin/tnslsnr at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Start fuser command /sbin/fuser /opt/oracle/datasoft/bin/proc at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Finish fuser command /sbin/fuser /opt/oracle/datasoft/bin/proc at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Start fuser command /sbin/fuser /opt/oracle/datasoft/bin/rman at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Finish fuser command /sbin/fuser /opt/oracle/datasoft/bin/rman at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Start fuser command /sbin/fuser /opt/oracle/datasoft/bin/wrap at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Finish fuser command /sbin/fuser /opt/oracle/datasoft/bin/wrap at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:24 PM]    Start fuser command /sbin/fuser /opt/oracle/datasoft/bin/plshprof at Wed May 15 21:16:24 CST 2013
[May 15, 2013 9:16:25 PM]    Finish fuser command /sbin/fuser /opt/oracle/datasoft/bin/plshprof at Wed May 15 21:16:25 CST 2013
[May 15, 2013 9:16:25 PM]    Start fuser command /sbin/fuser /opt/oracle/datasoft/lib/libclntsh.so.11.1 at Wed May 15 21:16:25 CST 2013
[May 15, 2013 9:16:25 PM]    Finish fuser command /sbin/fuser /opt/oracle/datasoft/lib/libclntsh.so.11.1 at Wed May 15 21:16:25 CST 2013
[May 15, 2013 9:16:25 PM]    Following executables are active :
                             /opt/oracle/datasoft/lib/libclntsh.so.11.1
[May 15, 2013 9:16:25 PM]    Prerequisite check "CheckActiveFilesAndExecutables" failed.
                             The details are:
                             
                             
                             Following executables are active :
                             /opt/oracle/datasoft/lib/libclntsh.so.11.1
[May 15, 2013 9:16:25 PM]    Start fuser command /sbin/fuser /opt/oracle/datasoft/bin/amdu at Wed May 15 21:16:25 CST 2013
[May 15, 2013 9:16:25 PM]    Finish fuser command /sbin/fuser /opt/oracle/datasoft/bin/amdu at Wed May 15 21:16:25 CST 2013
[May 15, 2013 9:16:25 PM]    Start fuser command /sbin/fuser /opt/oracle/datasoft/bin/kfed at Wed May 15 21:16:25 CST 2013
[May 15, 2013 9:16:25 PM]    Finish fuser command /sbin/fuser /opt/oracle/datasoft/bin/kfed at Wed May 15 21:16:25 CST 2013
[May 15, 2013 9:16:25 PM]    OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[May 15, 2013 9:16:25 PM]    Finishing UtilSession at Wed May 15 21:16:25 CST 2013
[May 15, 2013 9:16:25 PM]    Log file location: /opt/oracle/datasoft/cfgtoollogs/opatch/opatch2013-05-15_21-16-19PM_1.log
[May 15, 2013 9:16:25 PM]    Stack Description: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed.
[May 15, 2013 9:16:25 PM]    StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:6420)
[May 15, 2013 9:16:25 PM]    StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:1587)
[May 15, 2013 9:16:25 PM]    StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1136)
[May 15, 2013 9:16:25 PM]    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[May 15, 2013 9:16:25 PM]    StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[May 15, 2013 9:16:25 PM]    StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[May 15, 2013 9:16:25 PM]    StackTrace: java.lang.reflect.Method.invoke(Method.java:592)
[May 15, 2013 9:16:25 PM]    StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:322)
[May 15, 2013 9:16:25 PM]    StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2346)
[May 15, 2013 9:16:25 PM]    StackTrace: oracle.opatch.OPatch.main(OPatch.java:613)


问题分析:

注意这句话:[May 15, 2013 9:16:25 PM] Prerequisite check "CheckActiveFilesAndExecutables" failed. The details are:

可以发现虽然数据库关掉了,监听也关掉了,但是在ps -ef |grep oracle 查看进程的时候,发现还存在很多的进程,那么要么杀死这些进程,要么重新启动服务器。

问题得到解决。

在论坛有个朋友是这样给我回复的:可能是有人用asmcmd但没有退出,可以ps -ef | grep asmcmd 看下
或者ps -ef | grep oracle (假设安装用户是oracle)看下当前所有oracle用户的进程,一般这种时候应该很干净的

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值