关闭

Oracle10gRAC(102040)打PSU 102044

934人阅读 评论(0) 收藏 举报
分类:

给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

 

 

 

 

 

 

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:424859次
    • 积分:6256
    • 等级:
    • 排名:第3927名
    • 原创:230篇
    • 转载:9篇
    • 译文:0篇
    • 评论:70条