oracle 11G 11.2.0.3.0 升级到11.2.0.3.6遇到的错误。
来源:互联网 发布:淘宝旅行客服 编辑:程序博客网 时间:2024/05/18 02:41
错误日志:
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用户的进程,一般这种时候应该很干净的
- oracle 11G 11.2.0.3.0 升级到11.2.0.3.6遇到的错误。
- oracle 11g 从11.2.0.3.0升级到11.2.0.3.6操作步骤(一)
- Oracle 11g升级至11.2.0.3
- ORACLE 11g从 11.2.0.1升级到11.2.0.4
- Oracle 10g 版本10.2.0.1.0升级到Oracle 10g 10.2.0.3.0过程
- Oracle 10g 版本10.2.0.1.0升级到Oracle 10g 10.2.0.3.0过程
- oracle 10G 升级到11G
- Oracle 11g RAC 11.2.0.3数据库升级失败后的两种回退方法
- 11g RAC 从11.2.0.3.0升级到11.2.0.3.9
- PSU-11g RAC 11.2.0.3.0 升级到11.2.0.3.1
- oracle 9I升级到11g用户的迁移
- 升级到ORACLE 11G 需注意的小问题
- oracle 12C中升级11g数据库到12c遇到ORA-65139
- Oracle 10g R2升级到Oracle 11g R2
- oracle 11.2.0.2升级到11.2.0.3
- oracle 11.2.0.3升级到11.2.0.4
- oracle数据库升级11.2.0.3升级到11.2.0.4
- 升级Oracle RAC 11.2.0.3.0到 11.2.0.3.9
- SQL按同字段的两种条件查询数量
- [小代码]md5加密字符串
- CFile、CStdioFile、FILE和其他文件操作
- ModelSim功能及使用入门
- “万能数据库查询分析器”用户已基本涵盖当前所有DBMS
- oracle 11G 11.2.0.3.0 升级到11.2.0.3.6遇到的错误。
- Memcache实践总结
- 记录
- UITableView每次滑动一行,类似scroll page enable
- Android开发之EditText属性详解
- asp.net 获取前台参数
- 2013年4月比较购物行业网站综合影响力排名
- ExtJS4.1+MVC3+Spring.NET1.3+EF5 整合八:ExtJS及其MVC
- vb.net用默认浏览器打开html页