Patch 21352635-database patch Set Update 11.2.0.4.8

One, CPU and PSU

Recently, after upgrading the database from 9.2.0.6 to 11.2.0.4, it was found that ORA-02072 error occurred when 11.2.0.4 accessed other 9i libraries via Dblink, and found a solution via Google, which was to upgrade to PSU 11.2.0.4.8, Note the procedure for installing patches, and it is recommended that you carefully read the relevant sections of the patch Readme document before patching, and that all the details of the patch can be found in the documentation.

About ORA-02072:

ora-02072:distributed Database network protocol mismatchcause:this should never happen between different PRODUCTION Rele ASEs of ORACLE, but could happen between Alpha and beta releases, for example. Action:upgrade the older release.

The full name of the Oracle CPU is the critical patch Update, which Oracle releases a security fix pack for each quarter of its product, often to fix security concerns in the product.

The full name of the Oracle PSU is patch Set update,oracle, which contains bug fixes for every quarterly release of its product. Oracle picks up the number of downloads that have been downloaded by the user and has been validated with a lower-risk patch placed in the PSU for each quarter. Not only bug fixes but also the latest CPUs are included in each PSU. PSUs are usually released with the CPU.

The CPU is cumulative (cumulative), which means that the latest CPU patches already contain previous CPU patches, so just install the latest CPU patches.

PSUs are usually also incremental, and most PSUs can be installed directly, but some PSUs must require the installation of a previous version of the PSU before proceeding with the installation, which can be viewed in the PSU's Readme document.

Second, Opatch tools

Opatch Toolkit, installed in the installation directory $oracle_home, PSU installation upgrade, all through the Opatch to complete. The upgrade installation of the PSU has certain requirements for the Opatch version, which allows you to view the Readme documentation for the PSU. For example, to install P21352635_112040_LINUX-X86-64, you must have 11.2.0.3.6 or a later version of Opatch, as shown below:

So how do you determine the Opatch version of the current system? The method is as follows:

[[Email protected] dbhome_1]$ CD $ORACLE _home/opatch[[email protected] opatch]$./opatch versionopatch Version: 11.2.0.3.4OPatch succeeded.

Obviously, the current Opatch version of the system is not suitable for installing patch p21352635_112040_linux-x86-64, to upgrade Opatch first, the upgrade steps are as follows:

(1), back up the previous version of Opatch.

$ mv $ORACLE _home/opatch Opatch.backup  # can also be directly overwritten

(2), download the version of the Opatch extracted to the $oracle_home directory. Then grant execute permissions.

$ chmod +x opatch opatch.bat opatchdiag opatchdiag.bat

(3), re-verify the Opatch version.

$./opatch Versionopatch Version:11.2.0.3.6opatch succeeded.

Third, apply the patch

Primarily, the first thing to do is to turn off database snooping and instances.

$ unzip p21352635_112040_linux-x86-64.zip$ cd 21352635/$ $ORACLE _home/opatch/opatch applyoracle interim Patch Installer  Version 11.2.0.3.6Copyright (c), Oracle Corporation. All rights reserved. Oracle Home:/u01/app/oracle/product/11.2.0/db_1central Inventory:/u01/app/orainventory from:/u01/a Pp/oracle/product/11.2.0/db_1/orainst.locopatch Version:11.2.0.3.6oui version:11.2.0.4.0log File location:/ U01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-07-12_09-40-56am_1.logverifying Environment and Performing prerequisite Checks ... Opatch continues with these patches:17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 do Want to proceed? [Y|n] ... Omit part of the content ... Backing up files ... Applying Sub-patch ' 17478514 ' to OH '/u01/app/oracle/product/11.2.0/db_1 ' patching component Oracle.rdbms, 11.2.0.4.0...Patching component ORACLE.RDBMS.RSF, 11.2.0.4.0...Patching component oracle.sdo, 11.2.0.4.0...Patching ComponentOracle.sysman.agent, 10.2.0.4.5...Patching component ORACLE.XDK, 11.2.0.4.0...Patching component Oracle.rdbms.dbscripts, 11.2.0.4.0...Patching component Oracle.sdo.locator, 11.2.0.4.0...Patching component ORACLE.NLSRTL.RSF, 11.2.0.4.0...Patching component ORACLE.XDK.RSF, 11.2.0.4.0...Patching component Oracle.rdbms.rman , 11.2.0.4.0...Verifying the update ... Applying Sub-patch ' 18031668 ' to OH '/u01/app/oracle/product/11.2.0/db_1 ' patching component Oracle.rdbms, 11.2.0.4.0...Patching component ORACLE.RDBMS.RSF, 11.2.0.4.0...Patching component ORACLE.LDAP.RSF, 11.2.0.4.0 ... Patching component Oracle.rdbms.crs, 11.2.0.4.0...Patching component Oracle.precomp.common, 11.2.0.4.0...Patching Component Oracle.ldap.rsf.ic, 11.2.0.4.0...Patching component Oracle.rdbms.deconfig, 11.2.0.4.0...Patching component Oracle.rdbms.dbscripts, 11.2.0.4.0...Patching component Oracle.rdbms.rman, 11.2.0.4.0...Verifying the update ... Applying Sub-patch ' 18522509 ' to OH '/u01/app/oracle/product/11.2.0/db_1 ' patching Component ORACLE.RDBMS.RSF, 11.2.0.4.0...Patching component Oracle.rdbms, 11.2.0.4.0...Patching component Oracle.precomp.common, 11.2.0.4.0...Patching component Oracle.rdbms.rman, 11.2.0.4.0...Patching component Oracle.rdbms.dbscripts, 11.2.0.4.0...Patching component Oracle.rdbms.deconfig, 11.2.0.4.0...Verifying the update ... Applying Sub-patch ' 19121551 ' to OH '/u01/app/oracle/product/11.2.0/db_1 ' patching component Oracle.precomp.common, 11.2.0.4.0...Patching component Oracle.sysman.console.db, 11.2.0.4.0...Patching component ORACLE.RDBMS.RSF, 11.2.0.4.0...Patching component Oracle.rdbms.rman, 11.2.0.4.0...Patching component Oracle.rdbms, 11.2.0.4.0 ... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...Patching component Oracle.ordim.client, 11.2.0.4.0 ... Patching component Oracle.ordim.jai, 11.2.0.4.0...Verifying the update ... Applying Sub-patch ' 19769489 ' to OH '/u01/app/oracle/product/11.2.0/db_1 ' applysession:optional component (s) [ Oracle.sysman.agent, 11.2.0.4.0] not present In the Oracle Home or a higher version is found. Patching component Oracle.precomp.common, 11.2.0.4.0...Patching component Oracle.ovm, 11.2.0.4.0...Patching component ORACLE.XDK, 11.2.0.4.0...Patching component Oracle.rdbms.util, 11.2.0.4.0...Patching component Oracle.rdbms, 11.2.0.4.0...Patching component Oracle.rdbms.dbscripts, 11.2.0.4.0...Patching component Oracle.xdk.parser.java, 11.2.0.4.0...Patching component Oracle.oraolap, 11.2.0.4.0...Patching component ORACLE.RDBMS.RSF, 11.2.0.4.0 ... Patching component ORACLE.XDK.RSF, 11.2.0.4.0...Patching component Oracle.rdbms.rman, 11.2.0.4.0...Patching component Oracle.rdbms.deconfig, 11.2.0.4.0...Verifying the update ... Applying Sub-patch ' 20299013 ' to OH '/u01/app/oracle/product/11.2.0/db_1 ' patching component Oracle.rdbms.dv, 11.2.0.4.0...Patching component Oracle.rdbms.oci, 11.2.0.4.0...Patching component Oracle.precomp.common, 11.2.0.4.0...Patching component Oracle.sysman.agent, 10.2.0.4.5...Patching component Oracle.xdk, 11.2.0.4.0 ...Patching component Oracle.sysman.common, 10.2.0.4.5...Patching component Oracle.rdbms, 11.2.0.4.0...Patching Component Oracle.rdbms.dbscripts, 11.2.0.4.0...Patching component Oracle.xdk.parser.java, 11.2.0.4.0...Patching Component Oracle.sysman.console.db, 11.2.0.4.0...Patching component ORACLE.XDK.RSF, 11.2.0.4.0...Patching component ORACLE.RDBMS.RSF, 11.2.0.4.0...Patching component Oracle.sysman.common.core, 10.2.0.4.5...Patching component Oracle.rdbms.rman, 11.2.0.4.0...Patching component Oracle.rdbms.deconfig, 11.2.0.4.0...Verifying the update ... Applying Sub-patch ' 20760982 ' to OH '/u01/app/oracle/product/11.2.0/db_1 ' patching component oracle.sysman.console.db, 11.2.0.4.0...Patching component Oracle.rdbms, 11.2.0.4.0...Patching component oracle.rdbms.dbscripts, 11.2.0.4.0 ... Verifying the update ... Applying Sub-patch ' 21352635 ' to OH '/u01/app/oracle/product/11.2.0/db_1 ' patching component oracle.sysman.agent, 10.2.0.4.5...Patching component ORACLE.RDBMS.RSF, 11.2.0.4.0...Patching comPonent Oracle.rdbms.rman, 11.2.0.4.0...Patching component Oracle.rdbms, 11.2.0.4.0...Verifying the update ... Composite Patch 21352635 successfully applied. Log File Location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-07-12_09-40-56am_1.logopatch Succeeded.

Run the Catbundle.sql and Utlrp.sql scripts, and for the RAC environment, you only need to run on a single node.

(1), catbundle.sql the patch information into the database, so that the database will know you last hit a patch or rollback of which patches.

CD $ORACLE _home/rdbms/adminsqlplus/nologsql> connect/as sysdbasql> startupsql> @catbundle. SQL PSU applysql& Gt QUIT

(2), utlrp.sql scripts can compile invalid objects in the database while the database is running, Oracle recommends that you run the Utlrp.sql again after migrating, upgrading, and demoting the database to compile invalid objects.

CD $ORACLE _home/rdbms/adminsqlplus/nologsql> connect/as sysdbasql> @utlrp. sql

(3), check whether the log file under the _home/cfgtoollogs/catbundle or $ORACLE _base/cfgtoollogs/catbundle directory is logged incorrectly.

Catbundle_psu_<database Sid>_apply_<timestamp>.logcatbundle_psu_<database SID>_GENERATE_< Timestamp>.log

At this point, the patch process is complete.

Iv. confirmation of post-upgrade patch Information

(1), through the Opatch database records, you can see the patch information.

$ $ORACLE _home/opatch/opatch lsinventoryoracle Interim Patch Installer version 11.2.0.3.6Copyright (c), ORACLE Corpo  Ration. All rights reserved. Oracle Home:/u01/app/oracle/product/11.2.0/db_1central Inventory:/u01/app/orainventory from:/u01/a Pp/oracle/product/11.2.0/db_1/orainst.locopatch Version:11.2.0.3.6oui version:11.2.0.4.0log File location:/ U01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-07-12_11-01-23am_1.loglsinventory Output File Location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-07-12_ 11-01-23am.txt--------------------------------------------------------------------------------Installed Top-level products (1): Oracle Database 11g 11.2.0.4.0There is 1 product  (s) installed in the Oracle Home.interim patches (1):P atch 21352635:applied on Tue Jul 09:50:04 CST 2016Unique Patch id:19227862patch Description: "Database PatCH Set update:11.2.0.4.8 (21352635) "Created on 1 Sep, 07:49:44 hrs sub-patch 20760982; "Database Patch Set update:11.2.0.4.7 (20760982)" Sub-patch 20299013; "Database Patch Set update:11.2.0.4.6 (20299013)" Sub-patch 19769489; "Database Patch Set update:11.2.0.4.5 (19769489)" Sub-patch 19121551; "Database Patch Set update:11.2.0.4.4 (19121551)" Sub-patch 18522509; "Database Patch Set update:11.2.0.4.3 (18522509)" Sub-patch 18031668; "Database Patch Set update:11.2.0.4.2 (18031668)" Sub-patch 17478514; Database Patch Set update:11.2.0.4.1 (17478514) Bugs fixed:17288409, 21051852, 18607546, 17205719, 17811429, 17 816865, 20506699 17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817 16992075, 17446237, 14015842 , 19972569, 21538558, 20925795, 17449815 17375354, 19463897, 17982555, 17235750, 13866822, 18317531, 17478514 1823 5390, 14338435, 20803583, 13944971, 20142975, 17811789, 16929165 18704244, 20506706, 17546973, 20334344, 14054676, 17088068, 18264060 17346091, 17343514, 21538567, 19680952, 18471685, 19211724, 13951456 16315398, 1 8744139, 16850630, 19049453, 18673304, 17883081, 19915271 18641419, 18262334, 17006183, 16065166, 18277454, 16833527, 10136473 18051556, 17865671, 17852463, 18554871, 17853498, 18334586, 17588480 17551709, 19827973, 17842825, 173444 12, 18828868, 17025461, 11883252 13609098, 17239687, 17602269, 19197175, 18316692, 17313525, 12611721 19544839, 18 964939, 17600719, 18191164, 19393542, 17571306, 18482502 20777150, 19466309, 17040527, 17165204, 18098207, 16785708, 1 7174582 16180763, 17465741, 16777840, 12982566, 19463893, 12816846, 16875449 17237521, 19358317, 17811438, 1781144 7, 17945983, 18762750, 17184721 16912439, 18061914, 17282229, 18331850, 18202441, 17082359, 18723434 19554106, 140 34426, 18339044, 19458377, 17752995, 20448824, 17891943 17258090, 17767676, 16668584, 18384391, 17040764, 17381384, 15 913355 18356166, 14084247, 20506715, 13853126, 18203837, 14245531, 16043574 17848897, 17877323, 17468141, 17786518, 17912217, 17037130, 18 155762 16956380, 17478145, 17394950, 18189036, 18641461, 18619917, 17027426 21352646, 16268425, 19584068, 18436307 , 17265217, 17634921, 13498382 20004087, 17443671, 18000422, 20004021, 17571039, 21067387, 16344544 18009564, 1435 4737, 18135678, 18614015, 20441797, 18362222, 17835048 16472716, 17936109, 17050888, 17325413, 14010183, 18747196, 177  61775 16721594, 17082983, 20067212, 21179898, 17302277, 18084625, 15990359 18203835, 17297939, 17811456, 16731148, 17215560, 13829543, 14133975 17694209, 18091059, 17385178, 8322815, 17586955, 17201159, 17655634 18331812, 197305 08, 18868646, 17648596, 16220077, 16069901, 17348614 17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285 317 19289642, 14764829, 18328509, 17622427, 16943711, 14368995, 17346671 18996843, 17783588, 16618694, 17672719, 1 8856999, 18783224, 17851160 17546761, 17798953, 18273830, 19972566, 16384983, 17726838, 17360606 13645875, 18199537, 16542886, 17889549, 1 4565184, 17071721, 20299015 17610798, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058 18641451, 1274774 0, 18430495, 17042658, 17016369, 14602788, 19972568 18508861, 19788842, 14657740, 17332800, 13837378, 19972564, 171869 05 18315328, 19699191, 17437634, 19006849, 19013183, 17296856, 18674024 17232014, 16855292, 21051840, 14692762, 17 762296, 17705023, 19121551 19854503, 19309466, 18681862, 18554763, 20558005, 17390160, 18456514 16306373, 13955826 , 18139690, 17501491, 17299889, 17752121, 17889583 18673325, 18293054, 17242746, 17951233, 17649265, 18094246, 1961513 6 17011832, 16870214, 17477958, 18522509, 20631274, 16091637, 17323222 16595641, 16524926, 18228645, 18282562, 175  96908, 17156148, 18031668 16494615, 17545847, 17614134, 13558557, 17341326, 17891946, 17716305 16392068, 19271443, 18092127, 18440047, 17614227, 14106803, 16903536 18973907, 18673342, 17389192, 16194160, 17006570, 17612828, 17721717 17570240, 17390431,      16863422, 18325460, 19727057, 16422541, 19972570 17267114, 18244962, 21538485, 18765602, 18203838, 16198143, 17246576 14829250, 17835627, 18247991, 14458214, 21051862, 16692232, 17786278 17227277, 16042673, 16314254, 16228604, 1683 7842, 17393683, 17787259 20331945, 20074391, 15861775, 16399083, 18018515, 18260550, 21051858 17036973, 16613964,     17080436, 16579084, 18384537, 18280813, 20296213 16901385, 15979965, 18441944, 16450169, 9756271, 17892268, 11733603 16285691, 17587063, 16538760, 18180390, 18193833, 21051833, 17238511 17824637, 16571443, 18306996, 14852021, 186740 17853456, 12364061--------------------------------------------------------------------------------opatch Succeeded.

(2), in addition, you can also view the upgrade information through the Dba_registry_history view.

Sql> select version,id,bundle_series,comments from Dba_registry_history; VERSION              ID bundle_series                  COMMENTS---------------------------------------------------------------------- ----------------------11.2.0.4              0 PSU                            patchset 11.2.0.2.011.2.0.4              0 PSU                            patchset 11.2.0.2.011.2.0.4              8 PSU                            PSU 11.2.0.4.8

Patch 21352635-database patch Set Update 11.2.0.4.8