下载11.2.0.3.5 PSU 和OPatch software
PSU
OPatch
关闭数据库和监听
[oracle@zwc ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 18 15:36:10 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> !lsnrctl stop LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 18-FEB-2013 15:36:24 Copyright (c) 1991, 2011, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zwc.database.com)(PORT=1521))) The command completed successfully
开始打PSU补丁
[oracle@zwc oracle]$ opatch version OPatch Version: 11.2.0.3.3 OPatch succeeded. [oracle@zwc oracle]$ opatch napply -oh $ORACLE_HOME -local /u01/app/oracle/14727310 Oracle Interim Patch Installer version 11.2.0.3.3 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc OPatch version : 11.2.0.3.3 OUI version : 11.2.0.3.0 Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2013-02-18_15-40-51PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle 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 = '/u01/app/oracle/product/11.2.0/db_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '13343438' to OH '/u01/app/oracle/product/11.2.0/db_1' 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 '13696216' to OH '/u01/app/oracle/product/11.2.0/db_1' 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 '13923374' to OH '/u01/app/oracle/product/11.2.0/db_1' ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] not present in 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... Applying sub-patch '14275605' to OH '/u01/app/oracle/product/11.2.0/db_1' 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 '14727310' to OH '/u01/app/oracle/product/11.2.0/db_1' Patching component oracle.rdbms, 11.2.0.3.0... Patching component oracle.rdbms.dbscripts, 11.2.0.3.0... Patching component oracle.rdbms.deconfig, 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.sysman.console.db, 11.2.0.3.0... Patching component oracle.sysman.oms.core, 10.2.0.4.4... 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' /u01/app/oracle/product/11.2.0/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg' /u01/app/oracle/product/11.2.0/db_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg' /u01/app/oracle/product/11.2.0/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg' Composite patch 14727310 successfully applied. OPatch Session completed with warnings. Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2013-02-18_15-40-51PM_1.log OPatch completed with warnings.
验证
[oracle@zwc oracle]$ opatch lspatches 14727310;Database Patch Set Update : 11.2.0.3.5 (14727310)
11.2.0.3.5 PSU包括11.2.0.3.1,11.2.0.3.2,11.2.0.3.3,11.2.0.3.4
[oracle@zwc oracle]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.3
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.3
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2013-02-18_15-46-39PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2013-02-18_15-46-39PM.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 14727310 : applied on Mon Feb 18 15:43:18 CST 2013
Unique Patch ID: 15663328
Patch description: "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Created on 27 Dec 2012, 00:06:30 hrs PST8PDT
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, 13593999, 10350832, 14138130, 12919564, 13624984, 13588248
13080778, 13804294, 14258925, 12873183, 13645875, 12880299, 14664355
14409183, 12998795, 14469008, 13719081, 13492735, 12857027, 14263036
14263073, 13742433, 13732226, 12905058, 13742434, 12849688, 12950644
13742435, 13464002, 12879027, 13534412, 14613900, 12585543, 12535346
12588744, 11877623, 12847466, 13649031, 13981051, 12582664, 12797765
14262913, 12923168, 13612575, 13384182, 13466801, 13484963, 11063191
13772618, 13070939, 12797420, 13041324, 12976376, 11708510, 13742437
13026410, 13737746, 13742438, 13326736, 13001379, 13099577, 14275605
13742436, 9873405, 9858539, 14040433, 12662040, 9703627, 12617123
12845115, 12764337, 13354082, 13397104, 12964067, 13550185, 12780983
12583611, 14546575, 13476583, 15862016, 11840910, 13903046, 15862017
13572659, 13718279, 13657605, 13448206, 13419660, 14480676, 13632717
14063281, 13430938, 13467683, 13420224, 14548763, 12646784, 14035825
12861463, 12834027, 15862021, 13377816, 13036331, 14727310, 13685544
13499128, 15862018, 12829021, 15862019, 12794305, 14546673, 12791981
13503598, 13787482, 10133521, 12718090, 13399435, 14023636, 12401111
13257247, 13362079, 12917230, 13923374, 14480675, 13524899, 13559697
14480674, 13916709, 14076523, 13773133, 13340388, 13366202, 13528551
12894807, 13343438, 13454210, 12748240, 14205448, 13385346, 15853081
12971775, 13035804, 13544396, 13035360, 14062795, 12693626, 13332439
14038787, 14062796, 12913474, 14841409, 14390252, 13370330, 14062797
13059165, 14062794, 12959852, 13358781, 12345082, 12960925, 9659614
13699124, 14546638, 13936424, 13338048, 12938841, 12658411, 12620823
12656535, 14062793, 12678920, 13038684, 14062792, 13807411, 12594032
13250244, 15862022, 9761357, 12612118, 13742464, 14052474, 13457582
13527323, 15862020, 12780098, 13502183, 13705338, 13696216, 10263668
15862023, 13554409, 15862024, 13103913, 13645917, 14063280, 13011409
--------------------------------------------------------------------------------
OPatch succeeded.
执行PSU脚本
[oracle@zwc ~]$ lsnrctl start LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 18-FEB-2013 15:55:17 Copyright (c) 1991, 2011, Oracle. All rights reserved. Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait... TNSLSNR for Linux: Version 11.2.0.3.0 - Production System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/diag/tnslsnr/zwc/listener/alert/log.xml Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zwc.database.com)(PORT=1521))) Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=zwc.database.com)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production Start Date 18-FEB-2013 15:55:18 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/diag/tnslsnr/zwc/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zwc.database.com)(PORT=1521))) Services Summary... Service "ZWC" has 1 instance(s). Instance "ZWC", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [oracle@zwc ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 18 15:55:21 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 1653518336 bytes Fixed Size 2228904 bytes Variable Size 1191185752 bytes Database Buffers 452984832 bytes Redo Buffers 7118848 bytes Database mounted. Database opened.
cd $ORACLE_HOME/rdbms/admin sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> STARTUP SQL> @catbundle.sql psu apply SQL> QUIT
SQL> select * from dba_registry_history; ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SERIES COMMENTS ------------------------------ ------- ---------- ---------- ---------- --------------- ------------------- 17-SEP-11 10.21.11.595816 AM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.0 23-JAN-13 02.08.53.165848 PM APPLY SERVER 11.2.0.3 0 PSU Patchset 11.2.0.2.0 18-FEB-13 05.56.44.633809 PM APPLY SERVER 11.2.0.3 5 PSU PSU 11.2.0.3.5