Oracle 11gR2单实例数据库补丁升级记录(五)

2015-11-10 12:17:44 · 作者: · 浏览: 36
1.log


--日志片段:


[Aug 4, 2015 10:29:31 AM]? ? Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/bin/proc at Tue Aug 04 10:29:31 CST 2015


[Aug 4, 2015 10:29:31 AM]? ? Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/lib/liborasdkbase.so.11.1 at Tue Aug 04 10:29:31 CST 2015


[Aug 4, 2015 10:29:31 AM]? ? Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/lib/liborasdkbase.so.11.1 at Tue Aug 04 10:29:31 CST 2015


[Aug 4, 2015 10:29:31 AM]? ? Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/bin/wrap at Tue Aug 04 10:29:31 CST 2015


[Aug 4, 2015 10:29:31 AM]? ? Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/bin/wrap at Tue Aug 04 10:29:31 CST 2015


[Aug 4, 2015 10:29:31 AM]? ? Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/bin/e2eme at Tue Aug 04 10:29:31 CST 2015


[Aug 4, 2015 10:29:31 AM]? ? Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/dbhome_1/bin/e2eme at Tue Aug 04 10:29:31 CST 2015


[Aug 4, 2015 10:29:31 AM]? ? OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.


[Aug 4, 2015 10:29:31 AM]? ? Finishing UtilSession at Tue Aug 04 10:29:31 CST 2015


[Aug 4, 2015 10:29:31 AM]? ? Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-08-04_10-29-25AM_1.log


[Aug 4, 2015 10:29:31 AM]? ? Stack Description: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed.


[Aug 4, 2015 10:29:31 AM]? ? StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:5717)


[Aug 4, 2015 10:29:31 AM]? ? StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:697)


[Aug 4, 2015 10:29:31 AM]? ? StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1082)


[Aug 4, 2015 10:29:31 AM]? ? StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


[Aug 4, 2015 10:29:31 AM]? ? StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)


[Aug 4, 2015 10:29:31 AM]? ? StackTrace: sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)


[Aug 4, 2015 10:29:31 AM]? ? StackTrace: java.lang.reflect.Method.invoke(Method.java:592)


[Aug 4, 2015 10:29:31 AM]? ? StackTrace: oracle.opatch.UtilSession.process(UtilSession.java:317)


[Aug 4, 2015 10:29:31 AM]? ? StackTrace: oracle.opatch.OPatchSession.main(OPatchSession.java:2575)


[Aug 4, 2015 10:29:31 AM]? ? StackTrace: oracle.opatch.OPatch.main(OPatch.java:626)


经过分析,认为是Oracle数据库和监听器启动状态。安装补丁的时候,最好还是能够停机进行。


[oracle@XXX-PROD-DB 20299013]$ lsnrctl stop


LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 04-AUG-2015 10:37:25


Copyright (c) 1991, 2013, Oracle.? All rights reserved.


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))


The command completed successfully


[oracle@INTCTL-PROD-DB 20299013]$ sqlplus /nolog


SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 4 10:37:32 2015


Copyright (c) 1982, 2013, Oracle.? All rights reserved.


SQL> conn / as sysdba


Connected.


SQL> shutdown immediate;


Database closed.


Database dismounted.


ORACLE instance shut down.


SQL> quit


Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production


With the Partitioning, OLAP, Data Mining and