oracle 11g psu步骤,11.2.0.4.X升级PSU步骤(linux)

步骤,11.2.0.4.X升级PSU步骤(linux)"/>

oracle 11g psu步骤,11.2.0.4.X升级PSU步骤(linux)

Oracle Grid Infrastructure

11.2.0.4.x Patch Set Update SUPPLEMENTAL README

11.2.0.4.X升级步骤(linux)

一、OPatch版本与PSU补丁

1、OPatch版本：opatch112036-p6880880_112000_linux-x86-64.zip

2、PSU补丁：p18706472_112040_linux-x86-64.zip

二、OPatch

Utility Information

1、OPatch版本信息

2、You

must use the OPatch utility version 11.2.0.3.6 or later to apply

this patch.

查看升级包中的README,按要求更新OPatch版本.获取最新OPatch并解压到/oracle/pkg目录

3、用root用户解压缩,并给于777权限

unzip

opatch112036-p6880880_112000_linux-x86-64.zip

chmod -R 777 OPatch/

三、PSU升级包

1、根据你的需要选择相应的PSU补丁

2、每个补丁只针对特定的数据库版本，你要找到对应的数据库版本

3、点击上面的版本号，会自动跳到Oracle

Support下载页面

四、解压升级包

1、用root用户解压缩,并给于755权限

unzip p18706472_112040_linux-x86-64.zip

chmod -R 755 18706472/

五、解锁

1、Run

the pre root script. If this is a GI Home, as the root user

execute:

ROOT用户执行

/oracle/asm/crs/install/rootcrs.pl -unlock

六、升级GI补丁

七、升级DB补丁

八、执行POST-ROOT 脚本

1、Run

the post script. As the root user execute:

(ROOT用户执行)

$GI_HOME/rdbms/install/rootadd_rdbms.sh

2、If

this is a GI Home, as the root user execute:

$GI_HOME/crs/install/rootcrs.pl -patch

九、升级数据库

1、The

following steps load modified SQL files into the database. For an

Oracle RAC environment, perform these steps on only one

node.

For each database instance running on the Oracle home

being patched, connect to the database using SQL*Plus. Connect as

SYSDBA and run the catbundle.sql script as follows:

(如果存在DB数据库跑以下脚本)

su - oracle

sqlplus / as sysdba

@?/rdbms/admin/catbundle.sql psu apply

十、升级后察看是否升级成功

1、opatch

lsinventory

2、opatch

lspatches

[oracle@rac2 OPatch]$ ./opatch lspatches

18522509;Database Patch Set Update : 11.2.0.4.3

(18522509)

18522515;OCW Patch Set Update : 11.2.0.4.3

(18522515)

3、select

* from DBA_REGISTRY_HISTORY;

SQL> select

ACTION_TIME,ACTION,NAMESPACE,VERSION,BUNDLE_SERIES,COMMENTS FROM

DBA_REGISTRY_HISTORY;

ACTION_TIME ACTION NAMESPACE VERSION BUNDLE_SER COMMENTS

------------------------------ ---------- ----------

---------- ----------

--------------------------------------------------

04-OCT-14 11.56.41.605822

PM APPLY SERVER 11.2.0.4 PSU Patchset

11.2.0.2.0

10-DEC-14 10.28.19.445695

PM APPLY SERVER 11.2.0.4 PSU PSU

11.2.0.4.3

10-DEC-14 11.22.46.107371

PM APPLY SERVER 11.2.0.4 PSU PSU

11.2.0.4.3

十一、升级失败后回滚操作