11.2.0.3.7 PSU patch upgrade

11.2.0.3.7 PSU patch upgrade Description: This is a new host that has not yet been created. If the database already exists, you need to perform the database refreshing operation! Environment: SUSE Linux Enterprise Server 11 sp1 (x86_64) requires that the database be upgraded from 11.2.0.3.0 to 11.2.0.3.7 PSU (latest), Patch: unzip with oracle user unzipping: oracle @ tb-dinggou3 :~ /Softs> unzip p16619892_112030_Linux-x86-64.zip oracle @ tb-dinggou3 :~ /Softs> ls16619892 p16619892_112030_Linux-x86-64.ziporacle @ tb-dinggou3 :~ /Softs> cd 16619892/oracle @ tb-dinggou3 :~ /Softs/16619892> ls13343438 13696216 13923374 14275605 14727310 16056266 16619892 patchmd. xml README.html README.txt this PSU has requirements for OPatch. You must use an OPatch patch later than 11.2.0.3.0. The OPatch patch number is 6880880. So we need to download this OPatch Patch: p6880880_112000_Linux-x86-64.zip and then OPatch replacement: oracle @ tb-dinggou3 :~ /Softs> cd $ ORACLE_HOMEoracle @ tb-dinggou3:/opt/oracle/product/11gR2/db> mv OPatch OPatch_bakoracle @ tb-dinggou3: /opt/oracle/product/11gR2/db> unzip p6880880_112000_Linux-x86-64.zip oracle @ tb-dinggou3:/opt/oracle/product/11gR2/db> opatch versionOPatch Version: 11.2.0.3.4 patch conflict check: oracle @ tb-dinggou3 :~ /Softs/16619892> opatch prereq CheckConflictAgainstOHWithDetail-ph. /Oracle Interim Patch Installer version 11.2.0.3.4Copyright (c) 2012, Oracle Corporation. all rights reserved. PREREQ session Oracle Home:/opt/oracle/product/11gR2/dbCentral Inventory:/opt/oraInventory from:/opt/oracle/product/11gR2/db/oraInst. locOPatch version: 11.2.0.3.4OUI version: 11.2.0.3.0Log file location:/opt/ora Cle/product/11gR2/db/export toollogs/opatch/opatch2013-08-20_04-52-55AM_1.log Invoking prereq "Warn" Prereq "checkconflictagainstohwithdetail" passed. OPatch succeeded. No patch conflict. Patch application: oracle @ tb-dinggou3 :~ /Softs/16619892> opatch applyOracle Interim Patch Installer version 11.2.0.3.4Copyright (c) 2012, Oracle Corporation. all rights reserved. oracle Home:/opt/oracle/product/11gR2/dbCentral Inventory:/opt/oraInventory from:/opt/oracle/product/11gR2/db/oraInst. locOPatch version: 11.2.0.3.4OUI version: 11.2.0.3.0Log file location:/opt/oracle/product/11gR2/db/export toollogs/opatch/opatch2013-08-20 _ 04-53-08AM_1.log Verifying environment and timing Ming prerequisite checks... OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 16056266 16619892 Do you want to proceed? [Y | n] yUser Responded with: YAll checks passed. provide your email address to be informed of security issues, install andinitiate Oracle Configuration Manager. easier for you if you use your MyOracle Support Email address/User Name. visit http://www.oracle.com/support/policies.html For details. email address/User Name: You have not provided an email address for notification of security issues. do you wish to remain uninformed of security issues ([Y] es, [N] o) [N]: y Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/opt/oracle/product/11gR2/db') Is the local system ready for patching? [Y | n] yUser Responded with: YBacking up files... applying sub-patch '000000' to oh'/opt/oracle/product/11gR2/db' Patching component oracle. rdbms. rsf, 11.2.0.3.0... patching component oracle. rdbms, 11.2.0.3.0... patching component oracle. rdbms. dbscripts, 11.2.0.3.0... verifying the update... applying sub-patch '000000' to oh'/opt/oracle/product/11gR2/db' Patching component oracle. rdbms. rsf, 11.2.. 0.3.0... patching component oracle. rdbms, 11.2.0.3.0... patching component oracle. sdo. locator, 11.2.0.3.0... patching component oracle. sysman. console. db, 11.2.0.3.0... patching component oracle. sysman. oms. core, 10.2.0.4.4... verifying the update... applying sub-patch '000000' to oh'/opt/oracle/product/11gR2/db' ApplySession: Optional component (s) [oracle. network. cman, 11.2.0.3.0] not present I N the Oracle Home or a higher version is found. patching component oracle. rdbms. rsf, 11.2.0.3.0... patching component oracle. rdbms, 11.2.0.3.0... patching component oracle. rdbms. dbscripts, 11.2.0.3.0... patching component oracle. network. rsf, 11.2.0.3.0... patching component oracle. network. listener, 11.2.0.3.0... patching component oracle. sysman. console. db, 11.2.0.3.0... verifying the update... appl Ying sub-patch '000000' to oh'/opt/oracle/product/11gR2/db' ApplySession: Optional component (s) [oracle. precomp. lang, 11.2.0.3.0] not present in the Oracle Home or a higher version is found. patching component oracle. network. client, 11.2.0.3.0... patching component oracle. network. rsf, 11.2.0.3.0... patching component oracle. precomp. common, 11.2.0.3.0... patching component oracle. rdbms, 11.2.0. 3. 0... patching component oracle. rdbms. dbscripts, 11.2.0.3.0... patching component oracle. rdbms. rman, 11.2.0.3.0... patching component oracle. rdbms. rsf, 11.2.0.3.0... patching component oracle. rdbms. util, 11.2.0.3.0... verifying the update... applying sub-patch '000000' to oh'/opt/oracle/product/11gR2/db' Patching component oracle. rdbms, 11.2.0.3.0... patching component oracle. rdbms. dbscripts, 1 1.2.0.3.0... patching component oracle. rdbms. rsf, 11.2.0.3.0... patching component oracle. sdo. locator, 11.2.0.3.0... patching component oracle. sysman. console. db, 11.2.0.3.0... patching component oracle. sysman. oms. core, 10.2.0.4.4... verifying the update... applying sub-patch '000000' to oh'/opt/oracle/product/11gR2/db' ApplySession: Optional component (s) [oracle. network. cman, 11.2.0.3.0] not pr Esent in the Oracle Home or a higher version is found. patching component oracle. network. listener, 11.2.0.3.0... patching component oracle. network. rsf, 11.2.0.3.0... patching component oracle. ovm, 11.2.0.3.0... patching component oracle. rdbms, 11.2.0.3.0... patching component oracle. rdbms. rman, 11.2.0.3.0... patching component oracle. rdbms. rsf, 11.2.0.3.0... patching component oracle. sdo. locator, 11.2.0.3.0... patching component oracle. rdbms. deconfig, 11.2.0.3.0... verifying the update... applying sub-patch '000000' to oh'/opt/oracle/product/11gR2/db' ApplySession: Optional component (s) [oracle. precomp. lang, 11.2.0.3.0] not present in the Oracle Home or a higher version is found. patching component oracle. marvel, 11.2.0.3.0... patching component oracle. precomp. common, 11.2.0.3.0... patc Hing component oracle. rdbms, 11.2.0.3.0... patching component oracle. rdbms. rman, 11.2.0.3.0... patching component oracle. rdbms. rsf, 11.2.0.3.0... patching component oracle. sysman. agent, 10.2.0.4.3... patching component oracle. sysman. console. db, 11.2.0.3.0... patching component oracle. sysman. repository. core, 10.2.0.4.4... patching component oracle. xdk, 11.2.0.3.0... patching component oracle. xdk. pa Rser. java, 11.2.0.3.0... patching component oracle. xdk. rsf, 11.2.0.3.0... verifying the update... 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 '/opt/oracle/product/11gR2/db/precomp/lib/env_precomp.mk: 2160: warning: ignoring old comman Ds for target 'pcscfg. cfg '/opt/oracle/product/11gR2/db/precomp/lib/ins_precomp.mk: 19: warning: overriding commands for target' pcscfg. cfg '/opt/oracle/product/11gR2/db/precomp/lib/env_precomp.mk: 2160: warning: ignoring old commands for target' pcscfg. cfg '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 _ Emagent. mk: 113: warning: overriding commands for target 'nmosudo' ins _ emagent. mk: 52: warning: ignoring old commands for target 'nmosudo'/opt/oracle/product/11gR2/db/sysman/lib/ins_emagent.mk: 113: warning: overriding commands for target 'nmosudo'/opt/oracle/product/11gR2/db/sysman/lib/ins_emagent.mk: 52: warning: ignoring old commands for target 'nmosudo 'Composite patch 16619892 successfully applied. OPatch Session completed with warnings. Log file location:/opt/oracle/product/11gR2/db/export toollogs/opatch/opatch2013-08-20_04-53-08AM_1.log OPatch completed with warnings. Patch upgrade check oracle @ tb-dinggou3 :~ /Softs/16619892> opatch lsinventoryOracle Interim Patch Installer version 11.2.0.3.4Copyright (c) 2012, Oracle Corporation. all rights reserved. oracle Home:/opt/oracle/product/11gR2/dbCentral Inventory:/opt/oraInventory from:/opt/oracle/product/11gR2/db/oraInst. locOPatch version: 11.2.0.3.4OUI version: 11.2.0.3.0Log file location:/opt/oracle/product/11gR2/db/export toollogs/opatch/opatch2013-08-20_04-58-27AM_1.log Lsinventory Output file location: /opt/oracle/product/11gR2/db/export toollogs/opatch/lsinv/lsinventory2013-08-20_04-58-27AM.txt export Installed Top-level Products (1 ): oracle Database 11g 11.2.0.3.0There are 1 products installed in this Oracle Home. interim patches (1): Patch 16619892: applied on Tue Aug 20 04:56:34 CST 2013 Unique Patch ID: 16346737 Patch description: "Database Patch Set Update: 11.2.0.3.7 (16619892) "Created on 23 Jun 2013, 09:03:20 hrs PST8PDTSub-patch 16056266;" Database Patch Set Update: 11.2.0.3.6 (16056266) "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: 13593999,135 66938, 10350832,141 38130, 12919564,135 61951, 13624984 13588248,130 80778, 13914613,138 04294, 14258925,128 73183, 13645875 14472647,128 80299, 14664355,129 98795, 14409183,137 12781, 14469008 13492735,142 63036, 12857027,134 96884, 13015379,142 63073, 13742433 13732226,163 14469, 16368108,129 05058, 6690853,137 limit 34, 12849688 12950644,137 listen 35, 13464002,130 63120, 13534412,128 79027, 13958038 14613900,125 85543, 13790109,125 35346, 16382448,125 88744, 11877623 12395918,138 14739, 13786142,128 47466, 13649031,138 55490, 13981051 12582664,127 97765, 14262913,129 23168, 16279401,129 12137, 13612575 13384182,134 66801, 13484963,142 07163, 13724193,137 36918, 11063191 16694777,130 70939, 12797420,158 69211, 13041324,162 79211, 16314467 16314468,129 76376, 11708510,136 80405, 13742437,130 36910, 14589750 000038, 13737746,137 41373, 14644185,158 96521, 14398795 13579992,130 01379, 16344871,130 99577, 9873405,137 limit 36, 14275605 9858539,148 41812, 11715084,162 limit 99, 14040433,970 3627, 12662040 12617123,165 30565, 14207317,128 45115, 12764337,133 54082, 14459552 13397104,139 13630, 12964067,129 83611, 13550185,127 80983, 13810393 12583611,145 listen 75, 15862016,134 76583, 13489024,118 40910, 13903046 15862017,135 listen 59, 16294378,137 18279, 14088346,136 57605, 13448206 16314466,144 80676, 13419660,136 32717, 14668670,140 63281, 14110275 13430938,134 67683, 13420224,138 12031, 14548763,162 99830, 12646784 14512189,127 55116, 14035825,136 16375, 13427062,128 61463, 12834027 15862021,136 32809, 13377816,130 36331, 14727310,166 19892, 13685544 13499128,158 62018, 13584130,161 75381, 12829021,158 62019, 12794305 14546673,127 91981, 13561750,135 03598, 13787482,101 33521, 12718090 13848402,133 99435, 14023636,909 5696, 13860201,124 01111, 13257247 13362079,141 76879, 12917230,160 14985, 13923374,142 20725, 13524899 14480675,163 06019, 13559697,129 74860, 9706792,129 40620, 14480674 98318, 13916709,130 73133, 14076523,137 94244, 13340388 12731940,135 28551, 13366202,128 94807, 13343438,134 54210, 12748240 14205448,133 85346, 14127231,158 53081, 14273397,144 67061, 12971775 13923995,145 71027, 13582702,139 07462, 10242202,134 93847, 13857111 13035804,135 44396, 16382353,854 7978, 14226599,167 94241, 14062795 13035360,129 25089, 12693626,133 32439, 14038787,110 71989, 14062796 16794243,129 13474, 14841409,143 90252, 16314470,133 70330, 13059165 14062797,140 62794, 12959852,123 36982, 13358781,129 60925, 16703112 9659614,145 46638, 13699124,139 36424, 14301592,167 94240, 13338048 12938841,126 58411, 12620823,126 56535, 14062793,126 78920, 13038684 14062792,138 07411, 16742095,167 94238, 15862022,125 94032, 13250244 12612118,976 1357, 14053457,137 12764, 14052474,139 11821, 13457582 7509451,135 27323, 13791364,158 62020, 13910420,127 80098, 13502183 13696216,137 05338, 10263668,148 38558, 16794242,158 62023, 16056266 16794239,158 62024, 13554409,136 45917, 13103913,127 72404, 13011409,140 63280 109opatch succeeded.