探索Oracle之数据库升级五PSU11.2.0.4.3rollback11.2.0.4.0 - 数据库编程

.a" Patchingcomponent oracle.precomp.common, 11.2.0.4.0... Patchingcomponent oracle.rdbms.rman, 11.2.0.4.0... Patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0... Patchingcomponent oracle.rdbms.deconfig, 11.2.0.4.0... RollbackSessionremoving interim patch '18522509' from inventory Rollingback patch 18031668... RollbackSessionrolling back interim patch '18031668' from OH '/DBSoft/Product/11.2.4/db_1' Patchingcomponent oracle.rdbms, 11.2.0.4.0... Patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0... Patchingcomponent oracle.ldap.rsf, 11.2.0.4.0... Patchingcomponent oracle.rdbms.crs, 11.2.0.4.0... Patchingcomponent oracle.precomp.common, 11.2.0.4.0... Patchingcomponent oracle.ldap.rsf.ic, 11.2.0.4.0... Patchingcomponent oracle.rdbms.deconfig, 11.2.0.4.0... Patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0... Patchingcomponent oracle.rdbms.rman, 11.2.0.4.0... RollbackSessionremoving interim patch '18031668' from inventory Rollingback patch 17478514... RollbackSessionrolling back interim patch '17478514' from OH '/DBSoft/Product/11.2.4/db_1' Patchingcomponent oracle.rdbms, 11.2.0.4.0... Patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0... Patchingcomponent oracle.sdo, 11.2.0.4.0... Patchingcomponent oracle.sysman.agent, 10.2.0.4.5... Patchingcomponent oracle.xdk, 11.2.0.4.0... Patchingcomponent oracle.rdbms.dbscripts, 11.2.0.4.0... Patchingcomponent oracle.sdo.locator, 11.2.0.4.0... Patchingcomponent oracle.nlsrtl.rsf, 11.2.0.4.0... Patchingcomponent oracle.xdk.rsf, 11.2.0.4.0... Patchingcomponent oracle.rdbms.rman, 11.2.0.4.0... RollbackSessionremoving interim patch '17478514' from inventory OPatchfound the word "warning" in the stderr of the make command. Pleaselook at this stderr. You can re-run this make command. Stderroutput: ins_emagent.mk:113:warning: overriding commands for target `nmosudo' ins_emagent.mk:52:warning: ignoring old commands for target `nmosudo' /DBSoft/Product/11.2.4/db_1/sysman/lib/ins_emagent.mk:113:warning: overriding commands for target `nmosudo' /DBSoft/Product/11.2.4/db_1/sysman/lib/ins_emagent.mk:52:warning: ignoring old commands for target `nmosudo' OPatchSession completed with warnings. Log filelocation:/DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/18522509_Oct_04_2014_07_00_07/rollback2014-10-04_07-00-07AM_1.log OPatchcompleted with warnings. [oracle@db0118522509]$

二、启动数据库，执行catbundle_PSU_WOO_ROLLBACK.sql

[oracle@db0118522509]$ sqlplus / as sysdba

 

SQL*Plus:Release 11.2.0.4.0 Production on Sat Oct 4 07:04:28 2014

 

Copyright(c) 1982, 2013, Oracle.  All rightsreserved.

 

Connectedto an idle instance.

 

SQL>!lsnrctl start

 

LSNRCTLfor Linux: Version 11.2.0.4.0 - Production on 04-OCT-2014 07:04:31

 

Copyright(c) 1991, 2013, Oracle.  All rightsreserved.

 

Starting/DBSoft/Product/11.2.4/db_1/bin/tnslsnr: please wait...

 

TNSLSNRfor Linux: Version 11.2.0.4.0 - Production

System parameterfile is /DBSoft/Product/11.2.4/db_1/network/admin/listener.ora

Logmessages written to /DBSoft/diag/tnslsnr/db01/listener/alert/log.xml

Listeningon: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)

探索Oracle之数据库升级五PSU11.2.0.4.3rollback11.2.0.4.0(二)