热门标签 | HotTags
当前位置:  开发笔记 > 前端 > 正文

Oracle10gRAC打补丁p13343471

--查看当前补丁情况[Oracle@rac1OPatch]$pwdoptora10gproductdatabaseOPatch[Oracle@rac1OPatch]$.opatchlsinventoryInvokingOPatch10.2.0.4.9OracleInterimPatchInstallerversion10.2.0.4.9-Copyright(c)2009,OracleCorporation

--查看当前补丁情况 [Oracle@rac1 OPatch]$ pwd /opt/ora10g/product/database/OPatch [Oracle@rac1 OPatch]$ ./opatch lsinventory Invoking OPatch 10.2.0.4.9 Oracle Interim Patch Installer version 10.2.0.4.9- Copyright (c) 2009, Oracle Corporation

--查看当前补丁情况
[Oracle@rac1 OPatch]$ pwd
/opt/ora10g/product/database/OPatch
[Oracle@rac1 OPatch]$ ./opatch lsinventory
Invoking OPatch 10.2.0.4.9
Oracle Interim Patch Installer version 10.2.0.4.9-


Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /opt/ora10g/product/database
Central Inventory : /opt/ora10g/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.9
OUI version : 10.2.0.5.0
OUI location : /opt/ora10g/product/database/oui
Log file location : /opt/ora10g/product/database/cfgtoollogs/opatch/opatch2012-09-13_23-19-14PM.log
Patch history file: /opt/ora10g/product/database/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /opt/ora10g/product/database/cfgtoollogs/opatch/lsinv/lsinventory2012-09-13_23-19-14PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4 10.2.0.5.0a
There are 2 products installed in this Oracle Home.
Interim patches (1) :
Patch 12880299 : applied on Wed Sep 12 01:15:39 CST 2012
Unique Patch ID: 14803344
Created on 3 May 2012, 20:16:10 hrs PST8PDT
Bugs fixed:
12880299
Rac system comprising of multiple nodes
Local node = rac1
Remote node = rac2
--------------------------------------------------------------------------------
OPatch succeeded.
--apply patch
[Oracle@rac1 OPatch]$ cd /tmp/13343471/
[Oracle@rac1 13343471]$ pwd
/tmp/13343471
[Oracle@rac1 13343471]$ /opt/ora10g/product/database/OPatch/opatch apply
Invoking OPatch 10.2.0.4.9
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /opt/ora10g/product/database
Central Inventory : /opt/ora10g/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.9
OUI version : 10.2.0.5.0
OUI location : /opt/ora10g/product/database/oui
Log file location : /opt/ora10g/product/database/cfgtoollogs/opatch/opatch2012-09-13_23-21-41PM.log
Patch history file: /opt/ora10g/product/database/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '13343471' to OH '/opt/ora10g/product/database'
ApplySession failed: ApplySession failed to prepare the system.
Patch 13343471 requires OPatch version 10.2.0.5.0.
The OPatch version being used (10.2.0.4.9) doesn't meet the minimum version required by the patch(es). Please download latest OPatch from My Oracle Support.
System intact, OPatch will not attempt to restore the system
OPatch failed with error code 73
[Oracle@rac1 13343471]$ /opt/ora10g/product/database/OPatch/opatch version
Invoking OPatch 10.2.0.4.9
OPatch Version: 10.2.0.4.9
OPatch succeeded.
--升级OPatch
[Oracle@rac1 OPatch]$ ./opatch version
Invoking OPatch 10.2.0.5.1
OPatch Version: 10.2.0.5.1
OPatch succeeded.
--再次apply patch
--注:停止所有节点的资源和CRS(很奇怪,不停止所有节点的CRS的话,在打补丁的期间,当前节点会自动重启,很奇怪啊啊啊~)
[Oracle@rac1 13343471]$ pwd
/tmp/13343471
[Oracle@rac1 13343471]$ /opt/ora10g/product/database/OPatch/opatch apply
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /opt/ora10g/product/database
Central Inventory : /opt/ora10g/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.5.0
OUI location : /opt/ora10g/product/database/oui
Log file location : /opt/ora10g/product/database/cfgtoollogs/opatch/opatch2012-09-14_00-01-54AM.log
Patch history file: /opt/ora10g/product/database/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '13343471' to OH '/opt/ora10g/product/database'
Running prerequisite checks...
Patch 13343471: Optional component(s) missing : [ Oracle.rdbms.dv, 10.2.0.5.0 ] , [ oracle.rdbms.dv.oc4j, 10.2.0.5.0 ] , [ oracle.network.cman, 10.2.0.5.0 ]
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes.
This node is part of an Oracle Real Application Cluster.
Remote nodes: 'rac2'
Local node: 'rac1'
elease shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/opt/ora10g/product/database')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '13343471' for restore. This might take a while...
Backing up files affected by the patch '13343471' for rollback. This might take a while...
Execution of 'sh /tmp/13343471/custom/scripts/pre -apply 13343471 ':
Return Code = 0
Patching component Oracle.rdbms, 10.2.0.5.0...
... ...
Patching in rolling mode.
The node 'rac2' will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on 'rac2'.
(Oracle Home = '/opt/ora10g/product/database')
Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes 'rac2'
Apply-related files are:
FP = "/opt/ora10g/product/database/.patch_storage/13343471_Dec_20_2011_19_32_16/rac/copy_files.txt"
DP = "/opt/ora10g/product/database/.patch_storage/13343471_Dec_20_2011_19_32_16/rac/copy_dirs.txt"
MP = "/opt/ora10g/product/database/.patch_storage/13343471_Dec_20_2011_19_32_16/rac/make_cmds.txt"
RC = "/opt/ora10g/product/database/.patch_storage/13343471_Dec_20_2011_19_32_16/rac/remote_cmds.txt"
Instantiating the file "/opt/ora10g/product/database/.patch_storage/13343471_Dec_20_2011_19_32_16/rac/copy_files.txt.instantiated" by replacing $Oracle_HOME in "/opt/ora10g/product/database/.patch_storage/13343471_Dec_20_2011_19_32_16/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
... ...
The node 'rac2' has been patched. You can restart Oracle instances on it.
There were relinks on remote nodes. Remember to check the binary size and timestamp on the nodes 'rac2' .
The following make commands were invoked on remote nodes:
'cd /opt/ora10g/product/database/rdbms/lib; /usr/bin/make -f ins_rdbms.mk client_sharedlib Oracle_HOME=/opt/ora10g/product/database
cd /opt/ora10g/product/database/rdbms/lib; /usr/bin/make -f ins_rdbms.mk iOracle ORACLE_HOME=/opt/ora10g/product/database
cd /opt/ora10g/product/database/plsql/lib; /usr/bin/make -f ins_plsql.mk iwrap Oracle_HOME=/opt/ora10g/product/database
cd /opt/ora10g/product/database/network/lib; /usr/bin/make -f ins_net_client.mk client_sharedlib Oracle_HOME=/opt/ora10g/product/database
cd /opt/ora10g/product/database/precomp/lib; /usr/bin/make -f ins_precomp.mk proc Oracle_HOME=/opt/ora10g/product/database
cd /opt/ora10g/product/database/rdbms/lib; /usr/bin/make -f ins_rdbms.mk irman Oracle_HOME=/opt/ora10g/product/database
'
OPatch succeeded.
--查看补丁安装情况
[Oracle@rac1 ~]$ cd /opt/ora10g/product/database/OPatch
[Oracle@rac1 OPatch]$ ./opatch lsinventory
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /opt/ora10g/product/database
Central Inventory : /opt/ora10g/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.5.0
OUI location : /opt/ora10g/product/database/oui
Log file location : /opt/ora10g/product/database/cfgtoollogs/opatch/opatch2012-09-14_00-15-26AM.log
Patch history file: /opt/ora10g/product/database/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /opt/ora10g/product/database/cfgtoollogs/opatch/lsinv/lsinventory2012-09-14_00-15-26AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4 10.2.0.5.0a
There are 2 products installed in this Oracle Home.
Interim patches (2) :
Patch 13343471 : applied on Fri Sep 14 00:06:40 CST 2012
Unique Patch ID: 14268542
Created on 20 Dec 2011, 19:32:16 hrs PST8PDT
Bugs fixed:
6402302, 10269717, 10327190, 11693109, 8865718, 10017048, 9024850
8394351, 8546356, 8224558, 13489660, 9360157, 9770451, 9020537, 9772888
8650138, 8664189, 8488233, 10091698, 10092858, 12551710, 7519406
13349665, 10132870, 8771916, 9109487, 7509714, 9171933, 10173237
9532911, 10139235, 10159846, 10068982, 8350262, 11792865, 7119382
7361418, 10306945, 8666117, 11724962, 11725006, 6157713, 10214450
9184754, 8966823, 8544696, 9320130, 9767674, 9323583, 7026523, 9399589
8277300, 9672816, 13343467, 9726739, 9499302, 8412426, 10165083, 10208905
12419392, 6651220, 9150282, 9145204, 9659614, 9949948, 11076894, 10327179
8882576, 7612454, 7111619, 7450366, 9711859, 11893577, 9714832, 9735237
8970313, 6011045, 11814891, 10162036, 10248542, 9952230, 9469117, 13359623
9952270, 9842573, 13343471, 8660422, 10324526, 11066597, 12419258
9322219, 8636407, 9713537, 12828105, 10010310, 9390484, 9824435, 12925532
9963497, 9032322, 12862186, 12551700, 12862187, 12551701, 10249537
12551702, 12551703, 9586877, 8211733, 12551704, 10076669, 6694396
9548269, 12551705, 12551706, 9337325, 12551707, 8354642, 7602341, 12551708
9308296, 12827745, 9072105, 8528171, 10157402, 12565867, 11737047
Patch 12880299 : applied on Wed Sep 12 01:15:39 CST 2012
Unique Patch ID: 14803344
Created on 3 May 2012, 20:16:10 hrs PST8PDT
Bugs fixed:
12880299
Rac system comprising of multiple nodes
Local node = rac1
Remote node = rac2
--------------------------------------------------------------------------------
OPatch succeeded.
注:安装此次补丁是希望解决我的rac节点无故重启的问题,可是在安装补丁的同时也出现重启节点的现象,很是难以理解。
不过在安装此补丁后,节点重启问题依然没有得到解决。
推荐阅读
  • Oracle Database 10g许可授予信息及高级功能详解
    本文介绍了Oracle Database 10g许可授予信息及其中的高级功能,包括数据库优化数据包、SQL访问指导、SQL优化指导、SQL优化集和重组对象。同时提供了详细说明,指导用户在Oracle Database 10g中如何使用这些功能。 ... [详细]
  • 本文介绍了在开发Android新闻App时,搭建本地服务器的步骤。通过使用XAMPP软件,可以一键式搭建起开发环境,包括Apache、MySQL、PHP、PERL。在本地服务器上新建数据库和表,并设置相应的属性。最后,给出了创建new表的SQL语句。这个教程适合初学者参考。 ... [详细]
  • 在说Hibernate映射前,我们先来了解下对象关系映射ORM。ORM的实现思想就是将关系数据库中表的数据映射成对象,以对象的形式展现。这样开发人员就可以把对数据库的操作转化为对 ... [详细]
  • Lodop中特殊符号打印设计和预览样式不同的问题解析
    本文主要解析了在Lodop中使用特殊符号打印设计和预览样式不同的问题。由于调用的本机ie引擎版本可能不同,导致在不同浏览器下样式解析不同。同时,未指定文字字体和样式设置也会导致打印设计和预览的差异。文章提出了通过指定具体字体和样式来解决问题的方法,并强调了以打印预览和虚拟打印机测试为准。 ... [详细]
  • 推荐一个ASP的内容管理框架(ASP Nuke)的优势和适用场景
    本文推荐了一个ASP的内容管理框架ASP Nuke,并介绍了其主要功能和特点。ASP Nuke支持文章新闻管理、投票、论坛等主要内容,并可以自定义模块。最新版本为0.8,虽然目前仍处于Alpha状态,但作者表示会继续更新完善。文章还分析了使用ASP的原因,包括ASP相对较小、易于部署和较简单等优势,适用于建立门户、网站的组织和小公司等场景。 ... [详细]
  • 本文介绍了如何使用Power Design(PD)和SQL Server进行数据库反向工程的方法。通过创建数据源、选择要反向工程的数据表,PD可以生成物理模型,进而生成所需的概念模型。该方法适用于SQL Server数据库,对于其他数据库是否适用尚不确定。详细步骤和操作说明可参考本文内容。 ... [详细]
  • 在数据分析工作中,我们通常会遇到这样的问题,一个业务部门由若干业务组构成,需要筛选出每个业务组里业绩前N名的业务员。这其实是一个分组排序的 ... [详细]
  • 本文介绍了如何使用php限制数据库插入的条数并显示每次插入数据库之间的数据数目,以及避免重复提交的方法。同时还介绍了如何限制某一个数据库用户的并发连接数,以及设置数据库的连接数和连接超时时间的方法。最后提供了一些关于浏览器在线用户数和数据库连接数量比例的参考值。 ... [详细]
  • 本文介绍了adg架构设置在企业数据治理中的应用。随着信息技术的发展,企业IT系统的快速发展使得数据成为企业业务增长的新动力,但同时也带来了数据冗余、数据难发现、效率低下、资源消耗等问题。本文讨论了企业面临的几类尖锐问题,并提出了解决方案,包括确保库表结构与系统测试版本一致、避免数据冗余、快速定位问题等。此外,本文还探讨了adg架构在大版本升级、上云服务和微服务治理方面的应用。通过本文的介绍,读者可以了解到adg架构设置的重要性及其在企业数据治理中的应用。 ... [详细]
  • 本文介绍了使用postman进行接口测试的方法,以测试用户管理模块为例。首先需要下载并安装postman,然后创建基本的请求并填写用户名密码进行登录测试。接下来可以进行用户查询和新增的测试。在新增时,可以进行异常测试,包括用户名超长和输入特殊字符的情况。通过测试发现后台没有对参数长度和特殊字符进行检查和过滤。 ... [详细]
  • 本文详细介绍了MysqlDump和mysqldump进行全库备份的相关知识,包括备份命令的使用方法、my.cnf配置文件的设置、binlog日志的位置指定、增量恢复的方式以及适用于innodb引擎和myisam引擎的备份方法。对于需要进行数据库备份的用户来说,本文提供了一些有价值的参考内容。 ... [详细]
  • 使用Ubuntu中的Python获取浏览器历史记录原文: ... [详细]
  • 本文由编程笔记小编整理,介绍了PHP中的MySQL函数库及其常用函数,包括mysql_connect、mysql_error、mysql_select_db、mysql_query、mysql_affected_row、mysql_close等。希望对读者有一定的参考价值。 ... [详细]
  • 本文介绍了Oracle数据库中tnsnames.ora文件的作用和配置方法。tnsnames.ora文件在数据库启动过程中会被读取,用于解析LOCAL_LISTENER,并且与侦听无关。文章还提供了配置LOCAL_LISTENER和1522端口的示例,并展示了listener.ora文件的内容。 ... [详细]
  • Spring特性实现接口多类的动态调用详解
    本文详细介绍了如何使用Spring特性实现接口多类的动态调用。通过对Spring IoC容器的基础类BeanFactory和ApplicationContext的介绍,以及getBeansOfType方法的应用,解决了在实际工作中遇到的接口及多个实现类的问题。同时,文章还提到了SPI使用的不便之处,并介绍了借助ApplicationContext实现需求的方法。阅读本文,你将了解到Spring特性的实现原理和实际应用方式。 ... [详细]
author-avatar
黯嘫吢碎1984rv
这个家伙很懒,什么也没留下!
PHP1.CN | 中国最专业的PHP中文社区 | DevBox开发工具箱 | json解析格式化 |PHP资讯 | PHP教程 | 数据库技术 | 服务器技术 | 前端开发技术 | PHP框架 | 开发工具 | 在线工具
Copyright © 1998 - 2020 PHP1.CN. All Rights Reserved | 京公网安备 11010802041100号 | 京ICP备19059560号-4 | PHP1.CN 第一PHP社区 版权所有