Oracle RAC 11.2.0.4.6 PSU AUTO

最新推荐文章于 2024-09-23 21:31:27 发布

世界上最好的靳先生

最新推荐文章于 2024-09-23 21:31:27 发布

阅读量360

点赞数

分类专栏： Oracle 文章标签： Oracle Rac

本文链接：https://blog.youkuaiyun.com/cxy_sakura/article/details/84066192

版权

Oracle 专栏收录该内容

2 篇文章

订阅专栏

本文档详细介绍了如何在Oracle RAC环境中，逐步完成11.2.0.4.6 PSU补丁的升级过程，包括下载补丁、权限设置、OPatch升级、创建OCM文件、安装前检查、补丁应用以及检查最终版本等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.下载补丁并上传至所有Cluster-Server Nodes上(本案例2个节点)

[root@hua1 psu]# ls
p20996923_112040_Linux-x86-64.zip p6880880_112000_Linux-x86-64.zip PatchSearch.xml

[root@hua2 psu]# ls
__MACOSX p6880880_112000_Linux-x86-64.zip
p20996923_112040_Linux-x86-64.zip PatchSearch.xml

2.补丁目录赋权

[root@hua1 src]# chmod grid:oinstall psu/ -R

[root@hua2 src]# chmod grid:oinstall psu/ -R

3.升级OPatch工具（所有节点均需执行）

Grid:

[grid@hua1~]$ /u01/app/11.2.0/grid/OPatch/opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

[grid@hua1 ~]$ mv /u01/app/11.2.0/grid/OPatch /u01/app/11.2.0/grid/OPatch.bakunzip

[grid@hua1 ~]$ unzip /tmp/psu/p6880880_112000_Linux-x86-64.zip -d /u01/app/11.2.0/grid/

[grid@hua1 ~]$ /u01/app/11.2.0/grid/OPatch/opatch version

OPatch Version: 11.2.0.3.6

OPatch succeeded.

Oracle:

[oracle@hua1 ~]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

[oracle@hua1 ~]$ mv /u01/app/oracle/product/11.2.0/db_1/OPatch /u01/app/oracle/product/11.2.0/db_1/OPatch.bak

[oracle@hua1 ~]$ unzip /tmp/psu/p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11.2.0/db_1

[oracle@hua1 ~]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch version

OPatch Version: 11.2.0.3.6

OPatch succeeded

4.创建OCM文件(所有节点均需执行)

[grid@hua1~]$ cd /u01/app/11.2.0/grid/OPatch/ocm/bin/

[grid@hua1 bin]$ ./emocmrsp

OCM Installation Response Generator 10.3.4.0.0 - Production

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

The OCM configuration response file (ocm.rsp) was successfully created.

[grid@hua1 bin]$ ls -l ocm.rsp

-rw-r--r-- 1 grid oinstall 621 Jul 13 15:09 ocm.rsp

5.安装前检查当前补丁包是否可以Apply

[grid@hua1~]$ /u01/app/11.2.0/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /tmp/psu/20996923/

Oracle Interim Patch Installer version 11.2.0.3.6

PREREQ session

Oracle Home : /u01/app/11.2.0/grid

Central Inventory : /u01/app/oraInventory

from : /u01/app/11.2.0/grid/oraInst.loc

OPatch version : 11.2.0.3.6

OUI version : 11.2.0.4.0

Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2015-07-13_14-51-51PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

6.OPatch apply(所有节点均需执行)(无需关闭任何组件及资源！)

[root@hua1 psu]# /u01/app/11.2.0/grid/OPatch/opatch auto /usr/local/src/psu/20485808/ -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp

Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /tmp/psu -patchn 20485808 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2015-07-13_15-30-18.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2015-07-13_15-30-18.report.log

2015-07-13 15:30:18: Starting Clusterware Patch Setup

Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...

Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

patch /tmp/psu/20485808/20299013 apply successful for home /u01/app/oracle/product/11.2.0/db_1

patch /tmp/psu/20485808/20420937/custom/server/20420937 apply successful for home /u01/app/oracle/product/11.2.0/db_1

Stopping CRS...

Stopped CRS successfully

patch /tmp/psu/20485808/20299013 apply successful for home /u01/app/11.2.0/grid

patch /tmp/psu/20485808/20420937 apply successful for home /u01/app/11.2.0/grid

patch /tmp/psu/20485808/20299019 apply successful for home /u01/app/11.2.0/grid

Starting CRS...

Installing Trace File Analyzer

CRS-4123: Oracle High Availability Services has been started.

Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...

Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.

注：在解压p6880880_112000_Linux-x86-64.zip后会生成p6880880_112000_Linux-x86-64文件夹，OPatch会在这个文件夹下，要记得mv拿出来到家目录下

7.检查DB补丁版本

SQL> select * from dba_registry_history;

ACTION_TIME ACTION NAMESPACE VERSION ID BUNDL COMMENTS

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

24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0

25-NOV-14 12.13.42.990375 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0

8.更新数据字典补丁版本

[oracle@hua1 ~]$ sqlplus "/as sysdba"

SQL>@?/rdbms/admin/catbundle psu apply

9.检查DB补丁版本

SQL> select * from dba_registry_history;

ACTION_TIME ACTION NAMESPACE VERSION ID BUNDL COMMENTS

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

24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0

25-NOV-14 12.13.42.990375 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0

13-JUL-15 05.40.27.157018 PM APPLY SERVER 11.2.0.4 6 PSU PSU 11.2.0.4.6