探索Oracle之数据库升级五 PSU 11.2.0.4.3 rollback 11.2.0.4.0

浏览数：36 / 时间：2015年06月12日

探索Oracle之数据库升级五

PSU 11.2.0.4.3 rollback 11.2.0.4.0

一、进入PSU目录，执行opatch rollback

[root@db01~]# su - oracle
[oracle@db01~]$ ls
c18522509 Desktop OPatch p18522509_112040_Linux-x86-64.zip p6880880_112000_Linux-x86-64.zip PatchSearch.xml upgrade.log

[oracle@db01~]$ cd 18522509/
[oracle@db0118522509]$ ls
17478514 18031668 18522509 patchmd.xml README.html README.txt

[oracle@db0118522509]$ clear
[oracle@db0118522509]$ /home/oracle/OPatch/opatch rollback -id 18522509

OracleInterim Patch Installer version 11.2.0.3.6
Copyright(c) 2013, Oracle Corporation. All rightsreserved.

OracleHome       : /DBSoft/Product/11.2.4/db_1
CentralInventory : /DBSoft/oraInventory
   from           : /DBSoft/Product/11.2.4/db_1/oraInst.loc
OPatchversion    : 11.2.0.3.6
OUIversion       : 11.2.0.4.0
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

Patcheswill be rolled back in the following order:
   18522509 18031668   17478514
Thefollowing patch(es) will be rolled back: 18522509 18031668 17478514
Sub-patchesof a composite series are being rolled back. The system will be returned to astate where all subpatches are rolled back.
Thefollowing bug fixes will be removed:17596908,17174582,17648596,17011832,13645875,18096714,17752995,13951456,17655634,16992075,17786518,17393915,13498382,13609098,15861775,16360112,17571306,17477958,16392068,17006570,14458214,14602788,17397545,16268425,17165204,14565184,17883081,18522509,18018515,17672719,16315398,13853126,18554871,17767676,17588480,16542886,17227277,16855292,14054676,17786278,17311728,18247991,18277454,15979965,18681862,18996843,17754782,17892268,17614134,16314254,17478145,18061914,19049453,17238511,17600719,17381384,18744139,17297939,17783588,17716305,16180763,17545847,18203838,17393683,16863422,17389192,17394950,16731148,17761775,10136473,17726838,17186905,17441661,17325413,18203835,13364795,17050888,16472716,17622427,17546761,17468141,17040764,14010183,16837842,16228604,17205719,17284817,17346671,18180390,17235750,14133975,17721717,17082359,17602269,17071721,16613964,16929165,16043574,17080436,17265217,17865671,14852021,16399083,16943711,17375354,17546973,16785708,16956380,18094246,17614227,18031668,17313525,16912439,17385178,16618694,16220077,17016369,18203837,17027426,17341326,18139690,17437634,16875449,17465741,17752121,17344412,17296856,17390431,14338435,17323222,16850630,17551709,13944971,17811447,13866822,17811429,16069901,16721594,17443671,17478514,17612828,17610798,17239687,17501491,17446237,16450169,17811438,17288409,17811456,12905058,17088068,16285691,17332800

Pleaseshutdown Oracle instances running out of this ORACLE_HOME on the local system.
(OracleHome = ‘/DBSoft/Product/11.2.4/db_1‘)

Is thelocal system ready for patching? [y|n]
y
UserResponded with: Y
Rollingback patch 18522509...
RollbackSessionrolling back interim patch ‘18522509‘ from OH ‘/DBSoft/Product/11.2.4/db_1‘
Patchingcomponent oracle.rdbms.rsf, 11.2.0.4.0...
Patchingcomponent oracle.rdbms, 11.2.0.4.0...
Deleting"kzradmape.o" from archive"/DBSoft/Product/11.2.4/db_1/lib/libserver11.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)))
Listeningon: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))
Connectingto (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUSof the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version11.2.0.4.0 - Production
StartDate 04-OCT-2014 07:04:31
Uptime 0 days 0 hr. 0 min. 0 sec
TraceLevel off
Security ON: Local OS Authentication
SNMP OFF
ListenerParameter File /DBSoft/Product/11.2.4/db_1/network/admin/listener.ora
ListenerLog File /DBSoft/diag/tnslsnr/db01/listener/alert/log.xml
ListeningEndpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))
Thelistener supports no services
Thecommand completed successfully
SQL>startup
ORACLEinstance started.
TotalSystem Global Area 2872786944 bytes
FixedSize 2256712 bytes
VariableSize 2634023096 bytes
DatabaseBuffers 218103808 bytes
RedoBuffers 18403328 bytes
Databasemounted.
Databaseopened.
SQL>
SQL>alter system register;
Systemaltered.
SQL>@?/rdbms/admin/catbundle_PSU_WOO_ROLLBACK.sql
SQL>alter system register;
Systemaltered.
SQL>alter system register;
Systemaltered.

三、检查回滚后的版本:

[oracle@db0118522509]$ /home/oracle/OPatch/opatch lsinventory
OracleInterim Patch Installer version 11.2.0.3.6
Copyright(c) 2013, Oracle Corporation. All rightsreserved.
OracleHome : /DBSoft/Product/11.2.4/db_1
CentralInventory : /DBSoft/oraInventory
from :/DBSoft/Product/11.2.4/db_1/oraInst.loc
OPatchversion : 11.2.0.3.6
OUIversion : 11.2.0.4.0
Log filelocation : /DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/opatch2014-10-04_07-10-34AM_1.log
LsinventoryOutput file location :/DBSoft/Product/11.2.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-10-04_07-10-34AM.txt
--------------------------------------------------------------------------------
InstalledTop-level Products (1):
OracleDatabase 11g 11.2.0.4.0
Thereare 1 product(s) installed in this Oracle Home.
Thereare no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatchsucceeded.
[oracle@db0118522509]$
SQL>col comp_name format a40
SQL>col comp_id format a10
SQL>col version format a20
SQL>col status format a30
SQL>col status format a6
SQL>set line 300
SQL>set pagesize 200
SQL>select comp_id,comp_name,version,statusfrom dba_registry;
COMP_ID COMP_NAME VERSION STATUS
-------------------------------------------------- -------------------- ------
EM Oracle Enterprise Manager 11.2.0.4.0 VALID
OWB OWB 11.2.0.3.0 VALID
APEX Oracle Application Express 3.2.1.00.12 VALID
AMD OLAP Catalog 11.2.0.4.0 VALID
SDO Spatial 11.2.0.4.0 VALID
ORDIM Oracle Multimedia 11.2.0.4.0 VALID
XDB Oracle XML Database 11.2.0.4.0 VALID
CONTEXT Oracle Text 11.2.0.4.0 VALID
EXF Oracle Expression Filter 11.2.0.4.0 VALID
RUL Oracle Rules Manager 11.2.0.4.0 VALID
OWM Oracle Workspace Manager 11.2.0.4.0 VALID
CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID
CATPROC Oracle Database Packages and Types 11.2.0.4.0 VALID
JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID
XML Oracle XDK 11.2.0.4.0 VALID
CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID
APS OLAP Analytic Workspace 11.2.0.4.0 VALID
XOQ Oracle OLAP API 11.2.0.4.0 VALID
18 rowsselected.