ORACLE 10204 for linux as 4 CPU patch install

CPU全称为 Critical Patch Update，简而言之就是补丁集，网址http://www.oracle.com/technology/deploy/security/critical-patch-updates/cpuapr2009.html有ORACLE补丁集的信息，下载CPU patch需要metalink账号，下面是 linux as 4 ORACLE 10204 CPU patch 安装过程。
1、主机及Oracle版本信息：
[quote][ora10g@mctest ~]$ uname -a
Linux mctest 2.6.9-22.EL #1 Mon Sep 19 18:20:28 EDT 2005 i686 i686 i386 GNU/Linux

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production[/quote]

2、配置环境变量
[quote][ora10g@mctest ~]$ export PATH=$PATH:/usr/ccs/bin
[ora10g@mctest ~]$ which opatch
/oracle/app/product/10.2.0/db_1/OPatch/opatch
[/quote]

3、上转并解压安装包
[quote][ora10g@mctest tmp]$ unzip p8290506_10204_Linux-x86.zip
[ora10g@mctest tmp]$ cd 8290506[/quote]

注意：如果第一次安装cpu patch需执行一些赋权操作，root执行cpu_root.sh即可
[quote][ora10g@mctest 8290506]$ su
Password:
# sh cpu_root.sh[/quote]
[quote][ora10g@mctest 8290506]$ opatch napply -skip_subset -skip_duplicate
Invoking OPatch 10.2.0.4.2

Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.

Setting N-Apply implicit patch base-directory to /tmp/8290506
UTIL session

Oracle Home : /oracle/app/product/10.2.0/db_1
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /oracle/app/product/10.2.0/db_1/oui
Log file location : /oracle/app/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2009-07-10_18-24-28PM.log

Invoking utility "napply"
Checking conflict among patches...
Checking if Oracle Home has components required by patches...
Checking skip_duplicate
Checking skip_subset
Checking conflicts against Oracle Home...
OPatch continues with these patches: 7155248 7155249 7155250 7155251 7155252 7155253 7155254 7197583 7375611 7375613 7375617 7609057 7609058 8290506 8309587 8309592 8309623 8309632 8309637 8309639 8309642

Do you want to proceed? [y|n]
y
User Responded with: Y

Running prerequisite checks...

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/product/10.2.0/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch 'NApply' for restore. This might take a while...
Execution of 'sh /tmp/8290506/7197583/custom/scripts/pre -apply 7197583 ':

Return Code = 0
Execution of 'sh /tmp/8290506/8290506/custom/scripts/pre -apply 8290506 ':

Return Code = 0

Applying patch 7155248...

ApplySession applying interim patch '7155248' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7155248' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/lib/env_rdbms.mk"
ApplySession adding interim patch '7155248' to inventory

Verifying the update...
Inventory check OK: Patch ID 7155248 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155248 are present in Oracle Home.

Applying patch 7155249...

ApplySession applying interim patch '7155249' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7155249' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtdefr.plb"
ApplySession adding interim patch '7155249' to inventory

Verifying the update...
Inventory check OK: Patch ID 7155249 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155249 are present in Oracle Home.

Applying patch 7155250...

ApplySession applying interim patch '7155250' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7155250' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/kupp.o"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtbpp.plb"
ApplySession adding interim patch '7155250' to inventory

Verifying the update...
Inventory check OK: Patch ID 7155250 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155250 are present in Oracle Home.

Applying patch 7155251...

ApplySession applying interim patch '7155251' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7155251' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/kwqn.o"
ApplySession adding interim patch '7155251' to inventory

Verifying the update...
Inventory check OK: Patch ID 7155251 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155251 are present in Oracle Home.

Applying patch 7155252...

ApplySession applying interim patch '7155252' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7155252' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/ctc.o"
ApplySession adding interim patch '7155252' to inventory

Verifying the update...
Inventory check OK: Patch ID 7155252 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155252 are present in Oracle Home.

Applying patch 7155253...

ApplySession applying interim patch '7155253' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7155253' for rollback. This might take a while...

Patching component oracle.sysman.repository.core, 10.2.0.4.0a...
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/RsrcMonitorMsg.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/RsrcMonitorMsgID.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/rsrcmgr/RsrcmgrMonController.class"

Patching component oracle.sysman.console.db, 10.2.0.4.0...
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_instance/_sitemap/_healthgif.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_instance/_sitemap/_healthgif$__jsp_StaticText.class"
ApplySession adding interim patch '7155253' to inventory

Verifying the update...
Inventory check OK: Patch ID 7155253 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155253 are present in Oracle Home.

Applying patch 7155254...

ApplySession applying interim patch '7155254' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7155254' for rollback. This might take a while...

Patching component oracle.sysman.repository.core, 10.2.0.4.0a...
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/MemoryController.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SessionDetailsController.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SitemapController.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/emo/perf/bean/sesn/SessionDetails.class"

Patching component oracle.sysman.console.db, 10.2.0.4.0...
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_instance/_sitemap/_health.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_instance/_sitemap/_health$__jsp_StaticText.class"
ApplySession adding interim patch '7155254' to inventory

Verifying the update...
Inventory check OK: Patch ID 7155254 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7155254 are present in Oracle Home.

Applying patch 7197583...

ApplySession applying interim patch '7197583' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7197583' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/cpu/view_recompile/recompile_precheck_jan2008cpu.sql"
Copying file to "/oracle/app/product/10.2.0/db_1/cpu/view_recompile/view_recompile_jan2008cpu.sql"
ApplySession adding interim patch '7197583' to inventory

Verifying the update...
Inventory check OK: Patch ID 7197583 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7197583 are present in Oracle Home.

Applying patch 7375611...

ApplySession applying interim patch '7375611' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7375611' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/qccpub.o"
ApplySession adding interim patch '7375611' to inventory

Verifying the update...
Inventory check OK: Patch ID 7375611 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7375611 are present in Oracle Home.

Applying patch 7375613...

ApplySession applying interim patch '7375613' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7375613' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtdmsu.plb"
ApplySession adding interim patch '7375613' to inventory

Verifying the update...
Inventory check OK: Patch ID 7375613 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7375613 are present in Oracle Home.

Applying patch 7375617...

ApplySession applying interim patch '7375617' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7375617' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtbstr.plb"
ApplySession adding interim patch '7375617' to inventory

Verifying the update...
Inventory check OK: Patch ID 7375617 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7375617 are present in Oracle Home.

Applying patch 7609057...

ApplySession applying interim patch '7609057' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7609057' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Updating jar file "/oracle/app/product/10.2.0/db_1/rdbms/jlib/qsma.jar" with "/rdbms/jlib/qsma.jar/oracle/qsma/QsmaDataManager.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/rdbms/jlib/qsma.jar" with "/rdbms/jlib/qsma.jar/oracle/qsma/QsmaDataReports.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/rdbms/jlib/qsma.jar" with "/rdbms/jlib/qsma.jar/oracle/qsma/QsmaFileManager.class"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/dbmssum.sql"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtsum.plb"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtsms.plb"
ApplySession adding interim patch '7609057' to inventory

Verifying the update...
Inventory check OK: Patch ID 7609057 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7609057 are present in Oracle Home.

Applying patch 7609058...

ApplySession applying interim patch '7609058' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '7609058' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/kkxe.o"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtjob.plb"
ApplySession adding interim patch '7609058' to inventory

Verifying the update...
Inventory check OK: Patch ID 7609058 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 7609058 are present in Oracle Home.

Applying patch 8290506...

ApplySession applying interim patch '8290506' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '8290506' for rollback. This might take a while...

Patching component oracle.rdbms.rsf, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/cpu/CPUApr2009/rollback_all.lst"
Copying file to "/oracle/app/product/10.2.0/db_1/cpu/CPUApr2009/rollback_new.lst"

Patching component oracle.rdbms, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/cpu/CPUApr2009/catcpu.sql"
Copying file to "/oracle/app/product/10.2.0/db_1/cpu/CPUApr2009/catcpu_rollback.sql"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/bundledata_CPU.xml"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/catbundle.sql"
ApplySession adding interim patch '8290506' to inventory

Verifying the update...
Inventory check OK: Patch ID 8290506 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8290506 are present in Oracle Home.

Applying patch 8309587...

ApplySession applying interim patch '8309587' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '8309587' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/kkxs.o"
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/kzvdve.o"
ApplySession adding interim patch '8309587' to inventory

Verifying the update...
Inventory check OK: Patch ID 8309587 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8309587 are present in Oracle Home.

Applying patch 8309592...

ApplySession applying interim patch '8309592' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '8309592' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/sldbg.o"
ApplySession adding interim patch '8309592' to inventory

Verifying the update...
Inventory check OK: Patch ID 8309592 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8309592 are present in Oracle Home.

Applying patch 8309623...

ApplySession applying interim patch '8309623' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '8309623' for rollback. This might take a while...

Patching component oracle.rdbms, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtaqds.plb"
ApplySession adding interim patch '8309623' to inventory

Verifying the update...
Inventory check OK: Patch ID 8309623 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8309623 are present in Oracle Home.

Applying patch 8309632...

ApplySession applying interim patch '8309632' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '8309632' for rollback. This might take a while...

Patching component oracle.ovm, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/owmctrg.plb"
ApplySession adding interim patch '8309632' to inventory

Verifying the update...
Inventory check OK: Patch ID 8309632 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8309632 are present in Oracle Home.

Applying patch 8309637...

ApplySession applying interim patch '8309637' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '8309637' for rollback. This might take a while...

Patching component oracle.ovm, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/owmadmb.plb"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/owmadms.plb"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/owmasrtb.plb"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/owmltb.plb"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/owmutlb.plb"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/owmutls.plb"
ApplySession adding interim patch '8309637' to inventory

Verifying the update...
Inventory check OK: Patch ID 8309637 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8309637 are present in Oracle Home.

Applying patch 8309639...

ApplySession applying interim patch '8309639' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '8309639' for rollback. This might take a while...

Patching component oracle.network.rsf, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libn10.a" with "lib/libn10.a/nacom.o"

Patching component oracle.rdbms, 10.2.0.4.0...
ApplySession adding interim patch '8309639' to inventory

Verifying the update...
Inventory check OK: Patch ID 8309639 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8309639 are present in Oracle Home.

Applying patch 8309642...

ApplySession applying interim patch '8309642' to OH '/oracle/app/product/10.2.0/db_1'
Backing up files affected by the patch '8309642' for rollback. This might take a while...

Patching component oracle.network.listener, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/network/lib/libnlsnr10.a" with "network/lib/libnlsnr10.a/nsglgr.o"
Updating archive file "/oracle/app/product/10.2.0/db_1/network/lib/libnlsnr10.a" with "network/lib/libnlsnr10.a/nsglro.o"
ApplySession adding interim patch '8309642' to inventory

Verifying the update...
Inventory check OK: Patch ID 8309642 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 8309642 are present in Oracle Home.
Running make for target iextjob
Running make for target iextjobo
Running make for target ioracle
Running make for target client_sharedlib
Running make for target itnslsnr

--------------------------------------------------------------------------------
**********************************************************************
** ATTENTION **
** **
** Please note that this Patch Installation is **
** not complete until all the Post Installation instructions **
** noted in the Readme accompanying this patch, have been **
** successfully completed. **
** **
**********************************************************************

--------------------------------------------------------------------------------


--------------------------------------------------------------------------------
********************************************************************************
********************************************************************************
** ATTENTION **
** **
** Please note that the Security Patch Installation (Patch Deinstallation) is **
** not complete until all the Post Installation (Post Deinstallation) **
** instructions noted in the Readme accompanying this patch, have been **
** successfully completed. **
** **
********************************************************************************
********************************************************************************

--------------------------------------------------------------------------------

Execution of 'sh /tmp/8290506/8290506/custom/scripts/post -apply 8290506 ':

Return Code = 0

The local system has been patched and can be restarted.

UtilSession: N-Apply done.

OPatch succeeded.[/quote]
执行sql脚本
[quote]cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql cpu apply
SQL> QUIT
cd $ORACLE_HOME/cpu/view_recompile
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @recompile_precheck_jan2008cpu.sql
SQL> QUIT
cd $ORACLE_HOME/cpu/view_recompile
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP UPGRADE
SQL> @view_recompile_jan2008cpu.sql
SQL> SHUTDOWN;
SQL> STARTUP;
SQL> QUIT
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql[/quote]

查看当前cpu安装情况

[quote][ora10g@mctest admin]$ opatch lsinventory
Invoking OPatch 10.2.0.4.2

Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.


Oracle Home : /oracle/app/product/10.2.0/db_1
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /oracle/app/product/10.2.0/db_1/oui
Log file location : /oracle/app/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2009-07-10_18-49-54PM.log

Lsinventory Output file location : /oracle/app/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2009-07-10_18-49-54PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (2):

Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home.


Interim patches (21) :

Patch 8309642 : applied on Fri Jul 10 18:31:42 CST 2009
Created on 10 Mar 2009, 12:11:20 hrs PST8PDT
Bugs fixed:
8309642

Patch 8309639 : applied on Fri Jul 10 18:31:35 CST 2009
Created on 9 Mar 2009, 12:18:10 hrs PST8PDT
Bugs fixed:
8309639

Patch 8309637 : applied on Fri Jul 10 18:31:28 CST 2009
Created on 4 Mar 2009, 22:47:17 hrs PST8PDT
Bugs fixed:
8309637

Patch 8309632 : applied on Fri Jul 10 18:31:22 CST 2009
Created on 4 Mar 2009, 22:47:12 hrs PST8PDT
Bugs fixed:
8309632

Patch 8309623 : applied on Fri Jul 10 18:31:16 CST 2009
Created on 4 Mar 2009, 22:47:08 hrs PST8PDT
Bugs fixed:
8309623

Patch 8309592 : applied on Fri Jul 10 18:31:10 CST 2009
Created on 4 Mar 2009, 22:46:59 hrs PST8PDT
Bugs fixed:
8309592

Patch 8309587 : applied on Fri Jul 10 18:31:01 CST 2009
Created on 4 Mar 2009, 22:46:51 hrs PST8PDT
Bugs fixed:
8309587

Patch 8290506 : applied on Fri Jul 10 18:30:46 CST 2009
Created on 17 Mar 2009, 17:48:36 hrs PST8PDT
Bugs fixed:
8290506, 7375644, 7150470, 7592346

Patch 7609058 : applied on Fri Jul 10 18:30:40 CST 2009
Created on 7 Dec 2008, 22:38:07 hrs PST8PDT
Bugs fixed:
7609058

Patch 7609057 : applied on Fri Jul 10 18:30:31 CST 2009
Created on 7 Dec 2008, 22:40:46 hrs PST8PDT
Bugs fixed:
7609057

Patch 7375617 : applied on Fri Jul 10 18:30:24 CST 2009
Created on 16 Sep 2008, 00:51:28 hrs PST8PDT
Bugs fixed:
7375617

Patch 7375613 : applied on Fri Jul 10 18:30:18 CST 2009
Created on 16 Sep 2008, 00:51:25 hrs PST8PDT
Bugs fixed:
7375613

Patch 7375611 : applied on Fri Jul 10 18:30:11 CST 2009
Created on 16 Sep 2008, 00:51:22 hrs PST8PDT
Bugs fixed:
7375611

Patch 7197583 : applied on Fri Jul 10 18:30:00 CST 2009
Created on 20 Jun 2008, 07:14:55 hrs PST8PDT
Bugs fixed:
7197583

Patch 7155254 : applied on Fri Jul 10 18:29:48 CST 2009
Created on 9 Jun 2008, 03:09:21 hrs PST8PDT
Bugs fixed:
7155254

Patch 7155253 : applied on Fri Jul 10 18:27:57 CST 2009
Created on 9 Jun 2008, 03:07:12 hrs PST8PDT
Bugs fixed:
7155253

Patch 7155252 : applied on Fri Jul 10 18:26:16 CST 2009
Created on 20 Jun 2008, 07:25:15 hrs PST8PDT
Bugs fixed:
7155252

Patch 7155251 : applied on Fri Jul 10 18:26:05 CST 2009
Created on 20 Jun 2008, 07:24:32 hrs PST8PDT
Bugs fixed:
7155251

Patch 7155250 : applied on Fri Jul 10 18:25:56 CST 2009
Created on 20 Jun 2008, 07:23:48 hrs PST8PDT
Bugs fixed:
7155250

Patch 7155249 : applied on Fri Jul 10 18:25:47 CST 2009
Created on 20 Jun 2008, 07:19:39 hrs PST8PDT
Bugs fixed:
7155249

Patch 7155248 : applied on Fri Jul 10 18:25:41 CST 2009
Created on 20 Jun 2008, 07:18:50 hrs PST8PDT
Bugs fixed:
7155248


--------------------------------------------------------------------------------

OPatch succeeded.[/quote]

当然卸载cpu patch，可用以下命令
[quote][ora10g@mctest 8290506]$ opatch nrollback -idFile $ORACLE_HOME/cpu/CPUApr2009/rollback_all.lst
Invoking OPatch 10.2.0.4.2

Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.

UTIL session

Oracle Home : /oracle/app/product/10.2.0/db_1
Central Inventory : /oracle/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /oracle/app/product/10.2.0/db_1/oui
Log file location : /oracle/app/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2009-07-10_18-17-09PM.log

Invoking utility "nrollback"
Following patches are not present in the Oracle Home.
7375644, 7592346, 8309587, 8309592, 8309623, 8309632, 8309637, 8309639, 8309642

Patches will be rolled back in the following order:
7155248 7155249 7155250 7155251 7155252 7155253 7155254 7197583 7375617 7375613 7375611 7609057 7609058 8290506

Running prerequisite checks...
The following patch(es) will be rolled back: 7155248 7155249 7155250 7155251 7155252 7155253 7155254 7197583 7375617 7375613 7375611 7609057 7609058 8290506

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.


Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/product/10.2.0/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files affected by the patch 'NRollback' for restore. This might take a while...
Execution of 'sh /oracle/app/product/10.2.0/db_1/.patch_storage/7197583_Jun_20_2008_07_14_55/original_patch/custom/scripts/pre -rollback 7197583 ':

Return Code = 0
Execution of 'sh /oracle/app/product/10.2.0/db_1/.patch_storage/8290506_Mar_17_2009_17_48_36/original_patch/custom/scripts/pre -rollback 8290506 ':

Return Code = 0

Rolling back patch 7155248...

RollbackSession rolling back interim patch '7155248' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.rdbms, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/lib/env_rdbms.mk"
RollbackSession removing interim patch '7155248' from inventory

Rolling back patch 7155249...

RollbackSession rolling back interim patch '7155249' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.rdbms, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtdefr.plb"
RollbackSession removing interim patch '7155249' from inventory

Rolling back patch 7155250...

RollbackSession rolling back interim patch '7155250' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/kupp.o"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtbpp.plb"
RollbackSession removing interim patch '7155250' from inventory

Rolling back patch 7155251...

RollbackSession rolling back interim patch '7155251' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/kwqn.o"
RollbackSession removing interim patch '7155251' from inventory

Rolling back patch 7155252...

RollbackSession rolling back interim patch '7155252' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/ctc.o"
RollbackSession removing interim patch '7155252' from inventory

Rolling back patch 7155253...

RollbackSession rolling back interim patch '7155253' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.sysman.repository.core, 10.2.0.4.0a...
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/RsrcMonitorMsg.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/RsrcMonitorMsgID.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/rsrcmgr/RsrcmgrMonController.class"

Patching component oracle.sysman.console.db, 10.2.0.4.0...
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_instance/_sitemap/_healthgif.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_instance/_sitemap/_healthgif$__jsp_StaticText.class"
RollbackSession removing interim patch '7155253' from inventory

Rolling back patch 7155254...

RollbackSession rolling back interim patch '7155254' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.sysman.repository.core, 10.2.0.4.0a...
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/MemoryController.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SessionDetailsController.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/db/adm/inst/SitemapController.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emDB.jar" with "/sysman/jlib/emDB.jar/oracle/sysman/emo/perf/bean/sesn/SessionDetails.class"

Patching component oracle.sysman.console.db, 10.2.0.4.0...
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_instance/_sitemap/_health.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/sysman/jlib/emjsp.jar" with "/sysman/jlib/emjsp.jar/_database/_instance/_sitemap/_health$__jsp_StaticText.class"
RollbackSession removing interim patch '7155254' from inventory

Rolling back patch 7197583...

RollbackSession rolling back interim patch '7197583' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.rdbms, 10.2.0.4.0...
Deleting file "/oracle/app/product/10.2.0/db_1/cpu/view_recompile/recompile_precheck_jan2008cpu.sql"
Deleting file "/oracle/app/product/10.2.0/db_1/cpu/view_recompile/view_recompile_jan2008cpu.sql"
RollbackSession removing interim patch '7197583' from inventory

Rolling back patch 7375617...

RollbackSession rolling back interim patch '7375617' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.rdbms, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtbstr.plb"
RollbackSession removing interim patch '7375617' from inventory

Rolling back patch 7375613...

RollbackSession rolling back interim patch '7375613' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.rdbms, 10.2.0.4.0...
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtdmsu.plb"
RollbackSession removing interim patch '7375613' from inventory

Rolling back patch 7375611...

RollbackSession rolling back interim patch '7375611' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/qccpub.o"
RollbackSession removing interim patch '7375611' from inventory

Rolling back patch 7609057...

RollbackSession rolling back interim patch '7609057' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.rdbms, 10.2.0.4.0...
Updating jar file "/oracle/app/product/10.2.0/db_1/rdbms/jlib/qsma.jar" with "/rdbms/jlib/qsma.jar/oracle/qsma/QsmaDataManager.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/rdbms/jlib/qsma.jar" with "/rdbms/jlib/qsma.jar/oracle/qsma/QsmaDataReports.class"
Updating jar file "/oracle/app/product/10.2.0/db_1/rdbms/jlib/qsma.jar" with "/rdbms/jlib/qsma.jar/oracle/qsma/QsmaFileManager.class"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/dbmssum.sql"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtsum.plb"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtsms.plb"
RollbackSession removing interim patch '7609057' from inventory

Rolling back patch 7609058...

RollbackSession rolling back interim patch '7609058' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.rdbms, 10.2.0.4.0...
Updating archive file "/oracle/app/product/10.2.0/db_1/lib/libserver10.a" with "lib/libserver10.a/kkxe.o"
Copying file to "/oracle/app/product/10.2.0/db_1/rdbms/admin/prvtjob.plb"
RollbackSession removing interim patch '7609058' from inventory

Rolling back patch 8290506...

RollbackSession rolling back interim patch '8290506' from OH '/oracle/app/product/10.2.0/db_1'

Patching component oracle.rdbms.rsf, 10.2.0.4.0...
Deleting file "/oracle/app/product/10.2.0/db_1/cpu/CPUApr2009/rollback_all.lst"
Deleting file "/oracle/app/product/10.2.0/db_1/cpu/CPUApr2009/rollback_new.lst"

Patching component oracle.rdbms, 10.2.0.4.0...
Deleting file "/oracle/app/product/10.2.0/db_1/cpu/CPUApr2009/catcpu.sql"
Deleting file "/oracle/app/product/10.2.0/db_1/cpu/CPUApr2009/catcpu_rollback.sql"
Deleting file "/oracle/app/product/10.2.0/db_1/rdbms/admin/bundledata_CPU.xml"
Deleting file "/oracle/app/product/10.2.0/db_1/rdbms/admin/catbundle.sql"
RollbackSession removing interim patch '8290506' from inventory
Running make for target iextjob
Running make for target iextjobo
Running make for target ioracle

--------------------------------------------------------------------------------
**********************************************************************
** ATTENTION **
** **
** Please note that this Patch Installation is **
** not complete until all the Post Installation instructions **
** noted in the Readme accompanying this patch, have been **
** successfully completed. **
** **
**********************************************************************

--------------------------------------------------------------------------------


--------------------------------------------------------------------------------
********************************************************************************
********************************************************************************
** ATTENTION **
** **
** Please note that the Security Patch Installation (Patch Deinstallation) is **
** not complete until all the Post Installation (Post Deinstallation) **
** instructions noted in the Readme accompanying this patch, have been **
** successfully completed. **
** **
********************************************************************************
********************************************************************************

--------------------------------------------------------------------------------

Execution of 'sh /oracle/app/product/10.2.0/db_1/.patch_storage/8290506_Mar_17_2009_17_48_36/original_patch/custom/scripts/post -rollback 8290506 ':

Return Code = 0

The local system has been patched and can be restarted.

UtilSession: N-Rollback done.

OPatch succeeded.[/quote]