Explore Oracle Database Upgrade 5 PSU11.2.0.4.3 rollback 11.2.0.4.0 and oracle Database Upgrade

Source: Internet
Author: User
Tags sdo

Explore Oracle Database Upgrade 5 PSU11.2.0.4.3 rollback 11.2.0.4.0 and oracle Database Upgrade
Explore Oracle Database Upgrade 5 PSU11.2.0.4.3 rollback 11.2.0.4.0

 

1. Enter the PSU directory and run opatch rollback.

 

[root@db01~]# su - oracle[oracle@db01~]$ lsc18522509  Desktop OPatch p18522509_112040_Linux-x86-64.zip p6880880_112000_Linux-x86-64.zip  PatchSearch.xml  upgrade.log[oracle@db01~]$ cd 18522509/[oracle@db0118522509]$ ls17478514  18031668 18522509  patchmd.xml  README.html README.txt[oracle@db0118522509]$ clear[oracle@db0118522509]$ /home/oracle/OPatch/opatch rollback -id 18522509OracleInterim Patch Installer version 11.2.0.3.6Copyright(c) 2013, Oracle Corporation.  All rightsreserved.  OracleHome       : /DBSoft/Product/11.2.4/db_1CentralInventory : /DBSoft/oraInventory   from           : /DBSoft/Product/11.2.4/db_1/oraInst.locOPatchversion    : 11.2.0.3.6OUIversion       : 11.2.0.4.0Log 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   17478514Thefollowing 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]yUserResponded 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 inventoryOPatchfound 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]$

 

2. Start the database and run 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 - ProductionSystem parameterfile is /DBSoft/Product/11.2.4/db_1/network/admin/listener.oraLogmessages written to /DBSoft/diag/tnslsnr/db01/listener/alert/log.xmlListeningon: (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                     LISTENERVersion                   TNSLSNR for Linux: Version11.2.0.4.0 - ProductionStartDate                04-OCT-2014 07:04:31Uptime                    0 days 0 hr. 0 min. 0 secTraceLevel               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListenerParameter File   /DBSoft/Product/11.2.4/db_1/network/admin/listener.oraListenerLog File        /DBSoft/diag/tnslsnr/db01/listener/alert/log.xmlListeningEndpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db01)(PORT=1521)))Thelistener supports no servicesThecommand completed successfully SQL>startupORACLEinstance started. TotalSystem Global Area 2872786944 bytesFixedSize                  2256712 bytesVariableSize            2634023096 bytesDatabaseBuffers          218103808 bytesRedoBuffers               18403328 bytesDatabasemounted.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.

 

3. Check the version after rollback:

[oracle@db0118522509]$ /home/oracle/OPatch/opatch lsinventoryOracleInterim Patch Installer version 11.2.0.3.6Copyright(c) 2013, Oracle Corporation.  All rightsreserved.  OracleHome       : /DBSoft/Product/11.2.4/db_1CentralInventory : /DBSoft/oraInventory   from           :/DBSoft/Product/11.2.4/db_1/oraInst.locOPatchversion    : 11.2.0.3.6OUIversion       : 11.2.0.4.0Log 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.0Thereare 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 a40SQL>col comp_id format a10SQL>col version format a20SQL>col status format a30SQL>col status format a6SQL>set line 300SQL>set pagesize 200SQL>r  1* select comp_id,comp_name,version,statusfrom dba_registry COMP_ID    COMP_NAME                                VERSION              STATUS-------------------------------------------------- -------------------- ------EM         Oracle Enterprise Manager                11.2.0.4.0           VALIDOWB        OWB                                     11.2.0.3.0           VALIDAPEX       Oracle Application Express               3.2.1.00.12          VALIDAMD        OLAP Catalog                             11.2.0.4.0           VALIDSDO        Spatial                                 11.2.0.4.0           VALIDORDIM      Oracle Multimedia                        11.2.0.4.0           VALIDXDB        Oracle XML Database                      11.2.0.4.0           VALIDCONTEXT    Oracle Text                              11.2.0.4.0           VALIDEXF        Oracle Expression Filter                 11.2.0.4.0           VALIDRUL        Oracle Rules Manager                     11.2.0.4.0           VALIDOWM        Oracle Workspace Manager                 11.2.0.4.0           VALIDCATALOG    Oracle Database Catalog Views            11.2.0.4.0           VALIDCATPROC    Oracle Database Packages and Types       11.2.0.4.0           VALIDJAVAVM     JServer JAVA Virtual Machine             11.2.0.4.0           VALIDXML        Oracle XDK                               11.2.0.4.0           VALIDCATJAVA    Oracle Database Java Packages            11.2.0.4.0           VALIDAPS        OLAP Analytic Workspace                  11.2.0.4.0           VALIDXOQ        Oracle OLAP API                          11.2.0.4.0           VALID 18 rowsselected.

 

4. Now we can see that the database version has been rolled back to 11.2.0.4.0, indicating that the rollback is successful.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.