itspace
- 浏览: 960811 次
- 性别:
- 来自: 杭州
-
文章分类
最新评论
-
孤星119：
好熟悉的数据库字段啊， 上家公司做的项目每天都跟这些字段打招呼 ...
Oracle exp compress参数引起的空间浪费 -
itspace：
quxiaoyong 写道遇到个问题，网上一搜，全他妈这篇文章 ...
数据库连接错误ORA-28547 -
quxiaoyong：
遇到个问题，网上一搜，全他妈这篇文章。你转来转去的有意思吗？
数据库连接错误ORA-28547 -
hctech：
关于version count过高的问题，不知博主是否看过ey ...
某客户数据库性能诊断报告 -
itspace：
invalid 写道写的不错，我根据这个来安装，有点理解错误了 ...
AIX 配置vncserver
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版本信息：
2、配置环境变量
3、上转并解压安装包
注意：如果第一次安装cpu patch需执行一些赋权操作，root执行cpu_root.sh即可
执行sql脚本
查看当前cpu安装情况
当然卸载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
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
[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
[ora10g@mctest tmp]$ cd 8290506
注意：如果第一次安装cpu patch需执行一些赋权操作，root执行cpu_root.sh即可
引用
[ora10g@mctest 8290506]$ su
Password:
[root@mctest 8290506]# sh cpu_root.sh
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.
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
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.
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.
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.
0
顶
顶
0
踩
踩
分享到：
发表评论
-
buffer cache 的内部结构
2020-03-18 14:21 521BUFFER CACHE作为数据块的 ... -
Oracle OMC介绍
2020-03-18 13:19 441Oracle管理云服务（OMC）的大数据平台，自动收集的企业 ... -
参加Oracle勒索病毒防范专题培训会议
2019-09-27 17:15 4242019年7月22日，受邀参加Oracle勒索病毒防范专题培训 ... -
记一次内存换IO的Oracle优化
2019-09-27 16:50 787某客户数据库从P595物理 ... -
如何定位Oracle SQL执行计划变化的原因
2019-07-03 14:49 1366性能优化最难的是能够 ... -
如何定位Oracle SQL执行计划变化的原因
2018-10-30 09:24 1185性能优化最难的是能够 ... -
数据库性能优化目标
2018-10-08 10:59 478从数据库性能优化的场 ... -
数据库无法打开的原因及解决办法
2018-10-05 20:45 1927数据库的启动是一个相当复杂的过程。比如，Oracle在启动之前 ... -
怎么样彻底删除数据库？
2018-09-18 11:10 556Oracle提供了drop database命令用来删除数据库 ... -
Oracle减少日志量的方法
2018-09-10 10:17 816LGWR进程将LOG BUFFER中的 ... -
如何快速关闭数据库
2018-09-09 13:14 1198“一朝被蛇咬，十年怕井绳”。在没被“蛇”咬之前，很多DBA喜欢 ... -
关于《如何落地智能化运维》PPT
2018-05-17 10:19 1092在DTCC 2018发表《如何落地智能化运维》演讲，主要内容如 ... -
记录在redhat5.8平台安装oracle11.2容易忽视的几个问题
2018-05-11 19:58 534问题一：ping不通问题 在虚拟机上安装好linux系统后， ... -
《Oracle DBA实战攻略》第一章
2018-05-11 10:42 896即日起，不定期更新《OracleDBA实战攻略》一书电子版，请 ... -
Oracle 12c新特性
2018-05-11 10:33 859查询所有pdb [oracle@gj4 ~]$ sqlplu ... -
关于修改memory_target的值后数据库无法启动的问题
2017-02-28 12:24 3930操作系统：RHEL6.5 数据库版本：11.2.0.4 ... -
10g rac安装error while loading shared libraries libpthread.so.0 问题
2017-02-28 12:22 63511g rac安装在二节点跑脚本一般会报此错误： 解决这个问 ... -
记一次Oracle会话共享模式故障处理过程
2017-02-27 19:16 760故障简述 XXX第八人民医院HIS数据库7月13日11点左右从 ... -
RESMGR:cpu quantum等待事件处理过程
2017-02-27 18:23 2489由于数据库上线过程中出现大量的RESMGR:cpu quant ... -
谈谈log file sync
2014-03-19 14:18 1680数据库中的log file sync等待事件指的是，当user ...
相关推荐
ORACLE9i For RedHat Linux AS4 释放版安装手册
亲测，在虚拟机里安装RedHat 4 ，在RedHat上安装oracle10g 数据库
oracle9i for linux 安装过程
Oracle 10G For Linux AS4 安装手册
Oracle ebs 11.5 for linux as4 安装心得，学习学习
由于orcale补丁由网站:http://metalink.oracle.com 提供，但是此网站需要有付费账号才能登录访问。但为了方便大家学习，我全提供出来，除了p3948480_9206_LINUX,因为它有三百多兆，你们自己上google找。 下面是补丁...
oracle10g for as4 install 在rhel4上安装oracle10g
Linux rpm for fedora 7 oracle 10g install oracle 10g Linux rpm for fedora 7 oracle 10g install oracle 10g
oracle11.5.10.2安装及克隆
Oracle 10g for LinuxAS5.2 X86-32安装文档
RED HAT linux AS 4 下oracle9i的安装 RED HAT linux AS 4 下oracle9i的安装
Install Oracle 11g at Linux AS4.0
压缩包中，包含了Linux上oracle 11g r2 的客户端安装包和安装文档
Oracle数据库并非免费或开源软件，如用于商业目的需要向经销商购买软件使用许可证。...该手册是在RedHat Linux AS4环境下安装Oracle9.2.0.4的简明手册，只作内部参考而用，权威的技术支持请查阅oracle官方文档资料。
教你在linux系统上安装oracle10g
Oracle 18c for linux7 rac 部署文档
oracle的11g和12c，在Linux上的安装过程，经过反复验证，可以参考使用。
linux as4上安装Oracle10
Oracle EBS11.5.10 FOR linux中文patch 的安装方法
oracle 10g 软件p6810189_10204_Linux-x86-64适用于Linux 64位系统，文件分割成 2个 压缩包，必须集齐2个 文件后才能一起解压一起使用： p6810189_10204_Linux-x86-64.part2.rar ... p6810189_10204_Linux-x86-64.part...