下载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
From:http://blog.csdn.net/staricqxyz/article/details/8588022