DB and RAC (11.2.0.3) Patch Set Update (11.2.0.3.6)

The latest PSU of Oracle is 11.2.0.3.6 on July 6, May 29, 2013. This upgrade is performed for RAC and DB respectively to prepare for the future RAC + DG Environment.
 
System: linux 5.7 x86_64
 
Database Version: 11.2.0.3.0
 
Upgrade ORACLE from a single machine
 
First, upgrade the standalone database to 11.2.0.3.6:
 
Download the patch 11.2.0.3.6 with the patch number 16056266.
 
1.1 check patch conflicts
 
Use the oracle unzip patch package to go To the ORACLE_HOME directory.
 
[Oracle @ bogon db_1] $ cd 16056266/
 
[Oracle @ localhost 16056266] $ ../OPatch/opatch prereq CheckConflictAgainstOHWithDetail-ph ./
 

Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
 
PREREQ session
 
Oracle Home:/u01/app/oracle/product/11g/db_1
Central Inventory:/u01/app/oraInventory
From:/u01/app/oracle/product/11g/db_1/oraInst. loc
OPatch version: 11.2.0.3.4
OUI version: 11.2.0.3.0
Log file location:/u01/app/oracle/product/11g/db_1/export toollogs/opatch/opatch2013-05-27_11-00-06AM_1.log
 
Invoking prereq "checkconflictagainstohwithdetail"
 
Prereq "checkConflictAgainstOHWithDetail" passed.
 
OPatch succeeded.
 

1.2 check the patch history of the current database.
 
SQL> select action, comments from registry $ history;
 
ACTION
------------------------------
COMMENTS
--------------------------------------------------------------------------------
APPLY
Patchset 11.2.0.2.0
 
APPLY
Patchset 11.2.0.2.0
 
 
 
1.3 apply patches for upgrade
 
-- Exit the database, listener, and sqlplus before the upgrade. Otherwise, an error is reported during the pre-check.
 
[Oracle @ bogon 16056266] $ ../OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
 

Oracle Home:/u01/app/oracle/product/11g/db_1
Central Inventory:/u01/app/oraInventory
From:/u01/app/oracle/product/11g/db_1/oraInst. loc
OPatch version: 11.2.0.3.4
OUI version: 11.2.0.3.0
Log file location:/u01/app/oracle/product/11g/db_1/export toollogs/opatch/opatch2013-05-28_11-00-14AM_1.log
 
Verifying environment and padding Ming prerequisite checks...
OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310
 
Do you want to proceed? [Y | n]
Y
 
-- The Single-host PSU does not require the MOS account
 

Composite patch 16056266 successfully applied.
UtilSession: N-Apply done.
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1) OUI-67215:
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
Ins_precomp.mk: 19: warning: overriding commands for target 'pcscfg. cfg'
/U01/app/oracle/product/11g/db_1/precomp/lib/env_precomp.mk: 2160: warning: ignoring old commands for target 'pcscfg. cfg'
/U01/app/oracle/product/11g/db_1/precomp/lib/ins_precomp.mk: 19: warning: overriding commands for target 'pcscfg. cfg'
/U01/app/oracle/product/11g/db_1/precomp/lib/env_precomp.mk: 2160: warning: ignoring old commands for target 'pcscfg. cfg'
--------------------------------------------------------------------------------
OUI-67008: OPatch Session completed with warnings.
Finishing UtilSession at Tue May 28 11:10:43 CST 2013
Log file location:/u01/app/oracle/product/11g/db_1/export toollogs/opatch/opatch2013-05-28_11-00-14AM_1.log
 
-- Despite the alarm, the installation is still successful.
 
1.4 check the version after the upgrade (PSU)
 
-- View the current patch version
[Oracle @ localhost OPatch] $./opatch lspatches
16056266; Database Patch Set Update: 11.2.0.3.6 (16056266)
 

-- View Details of the current patch
[Oracle @ localhost OPatch] $./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
 

Oracle Home:/u01/app/oracle/product/11g/db_1
Central Inventory:/u01/app/oraInventory
From:/u01/app/oracle/product/11g/db_1/oraInst. loc
OPatch version: 11.2.0.3.4
OUI version: 11.2.0.3.0
Log file location:/u01/app/oracle/product/11g/db_1/export toollogs/opatch/opatch2013-05-28_11-33-02AM_1.log
 
Lsinventory Output file location:/u01/app/oracle/product/11g/db_1/export toollogs/opatch/lsinv/lsinventory2013-05-28_11-33-02AM.txt
 
--------------------------------------------------------------------------------
Installed Top-level Products (1 ):

Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
 

Interim patches (1 ):
 
Patch 16056266: applied on Tue May 28 11:09:50 CST 2013
Unique Patch ID: 15962803
Patch description: "Database Patch Set Update: 11.2.0.3.6 (16056266 )"
Created on 12 Mar 2013, 02:14:47 hrs PST8PDT
Sub-patch 14727310; "Database Patch Set Update: 11.2.0.3.5 (14727310 )"
Sub-patch 14275605; "Database Patch Set Update: 11.2.0.3.4 (14275605 )"
Sub-patch 13923374; "Database Patch Set Update: 11.2.0.3.3 (13923374 )"
Sub-patch 13696216; "Database Patch Set Update: 11.2.0.3.2 (13696216 )"
Sub-patch 13343438; "Database Patch Set Update: 11.2.0.3.1 (13343438 )"
Bugs fixed:
13566938,135 93999, 10350832,141 38130, 12919564,135 61951, 13624984
13588248,130 80778, 13914613,138 04294, 14258925,128 73183, 13645875
14472647,128 80299, 14664355,144 09183, 12998795,144 69008, 13719081
13492735,134 96884, 12857027,142 63036, 14263073,137 32226, 13742433
16368108,163 14469, 12905058,137 38534, 12849688,129 50644, 13742435
13464002,135 34412, 12879027,139 58038, 14613900,125 85543, 12535346
12588744,118 77623, 13786142,128 47466, 13649031,139 81051, 12582664
12797765,142 62913, 12923168,133 84182, 13612575,134 66801, 13484963
14207163,110 63191, 13772618,130 70939, 12797420,130 41324, 16314467
16314468,129 76376, 11708510,136 14589750,130, 13742437
13737746,146 44185, 13742438,133 26736, 13596521,130 01379, 16344871
13099577,987 3405, 14275605,137 limit 36, 9858539,148 41812, 11715084
16231699,140 40433, 12662040,970 3627, 12617123,128 45115, 12764337
13354082,144 59552, 13397104,139 13630, 12964067,129 83611, 13550185
13810393,127 80983, 12583611,145 12775, 13476583,158 62016, 11840910
13903046,158 62017, 13572659,162 94378, 13718279,140 88346, 13657605
13448206,163 14466, 14480676,134 19660, 13632717,140 63281, 14110275
13430938,134 67683, 13420224,138 12031, 14548763,162 99830, 12646784
13616375,140 35825, 12861463,128 34027, 15862021,136 32809, 13377816
13036331,147 27310, 13685544,158 62018, 13499128,161 75381, 13584130
12829021,158 62019, 12794305,145 46673, 12791981,137 87482, 13503598
10133521,127 18090, 13399435,140 23636, 13860201,124 01111, 13257247
13362079,141 76879, 12917230,139 23374, 14220725,144 80675, 13524899
13559697,970 6792, 14480674,139 16709, 13098318,137 73133, 14076523
13340388,133 66202, 13528551,128 94807, 13454210,133 43438, 12748240
14205448,133 85346, 15853081,142 73397, 12971775,135 82702, 10242202
13035804,135 44396, 16382353,854 7978, 14226599,140 62795, 13035360
12693626,133 32439, 14038787,140 62796, 12913474,148 41409, 14390252
16314470,133 70330, 13059165,140 62797, 14062794,129 59852, 13358781
12345082,129 60925, 9659614,136 99124, 14546638,139 36424, 13338048
12938841,126 58411, 12620823,126 56535, 14062793,126 78920, 13038684
14062792,138 07411, 13250244,125 94032, 15862022,976 1357, 12612118
13742464,140 52474, 13911821,134 57582, 13527323,158 62020, 13910420
13502183,127 80098, 13705338,136 96216, 14841558,102 63668, 15862023
16056266,158 62024, 13554409,136 45917, 13103913,130 11409, 14063280
 
 
 
--------------------------------------------------------------------------------
 
OPatch succeeded.
 
./Opatch lsinventory-detail -- view patch details
 
1.5 load the upgrade information to the database
 
Cd $ ORACLE_HOME/rdbms/admin
Sqlplus/nolog
SQL> CONNECT/AS SYSDBA
SQL> STARTUP
SQL> @ catbundle. SQL psu apply
SQL> QUIT

1 2 3 Next Page