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版本信息：

引用

[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

2、配置环境变量

引用

[ora10g@mctest ~]$ export PATH=$PATH:/usr/ccs/bin
[ora10g@mctest ~]$ which opatch
/oracle/app/product/10.2.0/db_1/OPatch/opatch

3、上转并解压安装包

引用

[ora10g@mctest tmp]$ unzip p8290506_10204_Linux-x86.zip
[ora10g@mctest tmp]$ cd 8290506

注意：如果第一次安装cpu patch需执行一些赋权操作，root执行cpu_root.sh即可

引用

[ora10g@mctest 8290506]$ su
Password:
[root@mctest 8290506]# sh cpu_root.sh

引用

[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.

执行sql脚本

引用

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

查看当前cpu安装情况

引用

[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.

当然卸载cpu patch，可用以下命令

引用

[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.