Oracle10gRAC(102040)打PSU 102044
来源:互联网 发布:2003网络歌手名单大全 编辑:程序博客网 时间:2024/06/02 20:23
给10GRAC(102040)打PSU 102044
VMware workstation下安装
Vmware version: 9
OS:ORACLE LINUX 5.6_64位
DATABASE: 10201_64位
1.要求
1.1前提:RAC已经升到了102040
To install the PSU 10.2.0.4.4 patch, theOracle home must have the 10.2.0.4.0 Database patch set installed. SubsequentPSU patches can be installed on Oracle Database 10.2.0.4.0 or any PSU with alower 5th numeral version than the one being installed. For example, PSU10.2.0.4.4 can be installed on 10.2.0.4.0, 10.2.0.4.1, 10.2.0.4.2, and10.2.0.4.3.
查看目前数据库的版本
o10n1->sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Productionon Wed Dec 4 09:48:56 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise EditionRelease 10.2.0.4.0 - 64bit Production
With the Partitioning, Real ApplicationClusters, OLAP, Data Mining
and Real Application Testing options
SQL> select * from V$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise EditionRelease 10.2.0.4.0 - 64bi
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
1.2 Opatch 版本要求10.2.0.4.7以及以上
You must use the OPatch 10.2 version10.2.0.4.7 or later to apply this patch. Oracle recommends that you use thelatest released OPatch 10.2,
环境变量增加Opatch
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:/usr/sbin:$PATH
o10n1->opatch version
Invoking OPatch 10.2.0.4.2
OPatch Version: 10.2.0.4.2
OPatch succeeded.
需要升级
解压:
# unzip p6880880_102000_Linux-x86-64.zip
然后直接替换$ORACLE_HOME下的OPatch
o10n1->opatch version
Invoking OPatch 10.2.0.5.1
OPatch Version: 10.2.0.5.1
OPatch succeeded.
2.打PSU补丁
首先得将ASM,监听,数据库停掉
[root@o10n1 ~]# srvctl stop database -dbamuta
[root@o10n1 ~]# srvctl stop listener -no10n1
[root@o10n1 ~]# srvctl stop listener -no10n2
[root@o10n1 ~]# srvctl stop asm -n o10n1
[root@o10n1 ~]# srvctl stop asm -n o10n2
打PSU
o10n1->cd 9352164/
o10n1->opatch apply
SQL> @?/rdbms/admin/catbundle.sql psuapply
SQL> @?/rdbms/admin/utlrp.sql
验证102044PSU是否打上:
o10n1->opatch lsinventory -bugs_fixed|egrep -i 'PSU|DATABASE PATCH SET UPDATE'
8576156 9352164 Wed Dec 04 11:33:30 CST2013 DATABASE PSU 10.2.0.4.1 (INCLUDESCPUJUL2009)
8833280 9352164 Wed Dec 04 11:33:30 CST2013 DATABASE PSU 10.2.0.4.2 (INCLUDESCPUOCT2009)
9119284 9352164 Wed Dec 04 11:33:30 CST2013 DATABASE PSU 10.2.0.4.3 (INCLUDESCPUJAN2010)
9352164 9352164 Wed Dec 04 11:33:30 CST2013 DATABASE PSU 10.2.0.4.4 (INCLUDESCPUAPR2010)
SQL> l
1* select action,comments from registry$history
SQL> /
ACTION COMMENTS
------------------------------------------------------------
UPGRADE Upgraded from 10.2.0.1.0
APPLY PSU 10.2.0.4.4
APPLY PSU 10.2.0.4.4
- Oracle10gRAC(102040)打PSU 102044
- 11g打psu
- 一次打PSU的感触
- windows 2008上打PSU
- 手动打PSU的步骤
- Oracle RAC 11.2.0.4打PSU
- RHEL5.8 11g数据库 打PSU
- 先打11.2.0.3.8这个PSU,后建库
- 一次打11.2.0.3.8 PSU时遇到的问题
- oracle从11.0.2.4.0打PSU 11.0.2.4.8
- PSU打oracle的时候显示已经succeed
- 11.2 RAC , patch auto 方式打psu补丁
- 11.2.0.4双节点RAC打PSU 170814 步骤
- Linux+oracle10gRAC更改VIP
- oracle 11g 单实例打11.2.0.3.4 P14275605 PSU
- Oracle Database 11.2.0.3 打11.2.0.3.5 Patch Set Update(PSU)补丁
- Oracle Database 11.2.0.3 打11.2.0.3.5 Patch Set Update(PSU)补丁
- 11.2.0.3.0 打PSU补丁--自动方式(p14727347_112030_AIX64-5L.zip )
- 针对UI给出的背景颜色和透明度#ba9163 35%透明度该如何设置
- Java Heap sapce 与 Java PermGen space
- Element type "action" must be followed by either attribute specifications, ">" or "/>".
- GOODSTUDY
- hadoop介绍以及高人指点的学习方法
- Oracle10gRAC(102040)打PSU 102044
- Andorid API TestDemo 解析
- 从几个sample来学习Java堆,方法区,Java栈和本地方法栈
- 个人编写代码小的技巧(持续记录)
- 高效jQuery的奥秘
- win7 mysql 免安装版 配置注册问题
- mysql 运维小TIPS
- 中兴3G模块ID和端口号说明
- jquery之超简单的div显示和隐藏特效demo