给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