重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: 12c R2集群环境应用PSU [打印本页]

---

作者: miss_puff    时间: 2017-8-2 16:30
标题: 12c R2集群环境应用PSU
1、环境说明

OS版本：Oracle Linux 7.3

DB版本：12.2.0.1.0 64bit

数据库运行环境：RAC

psu补丁程序： 26123830（12.2.0.1.170718）

注意：

（1）应用PSU之前，确保磁盘至少有5G的可用空间，否则环境检查的时候会失败，提示如下

Reason: Failed during Analysis:CheckNApplyReport Failed, [ Prerequisite Status: FAILED, Prerequisite output:

The details are:

Failed during Analysis: CheckSystemSpaceFailed, [ Prerequisite Status: FAILED, Prerequisite output:

The details are:

（2）应用PSU之前，确保PSU包所属owner为grid且有775的权限，因为应用PSU过程中会切换到grid用户执行脚本。

以下实验以节点1为例，节点2同理

2、opatch 工具检查

（1）grid

[grid@rac01 OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.6

OPatch succeeded.

[grid@rac01 OPatch]$

（2）oracle

[oracle@rac01 OPatch]$ ./opatch version

OPatch Version: 12.2.0.1.6

OPatch succeeded.

[oracle@rac01 OPatch]$

3、opatch检查

（1）grid

[grid@rac01 OPatch]$ ./opatch lsinv

Oracle Interim Patch Installer version 12.2.0.1.6

Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home      : /u01/app/grid/product/12.2.0/grid

Central Inventory : /u01/app/grid/oraInventory

   from           :/u01/app/grid/product/12.2.0/grid/oraInst.loc

OPatch version   : 12.2.0.1.6

OUI version      : 12.2.0.1.4

Log file location :/u01/app/grid/product/12.2.0/grid/cfgtoollogs/opatch/opatch2017-08-01_14-44-14PM_1.log

Lsinventory Output file location :/u01/app/grid/product/12.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-08-01_14-44-14PM.txt

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

Local Machine Information::

Hostname: rac01

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 12c                                      12.2.0.1.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in thisOracle Home.

Patch level status of Cluster nodes :

PatchingLevel                  Nodes

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

0                               rac01,rac02

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

OPatch succeeded.

（2）oracle

[oracle@rac01 OPatch]$ ./opatch lsinv

Oracle Interim Patch Installer version 12.2.0.1.6

Copyright (c) 2017, Oracle Corporation.  All rights reserved.

Oracle Home      : /u01/app/oracle/product/12.2.0/db_2

Central Inventory : /u01/app/grid/oraInventory

   from          : /u01/app/oracle/product/12.2.0/db_2/oraInst.loc

OPatch version   : 12.2.0.1.6

OUI version      : 12.2.0.1.4

Log file location :/u01/app/oracle/product/12.2.0/db_2/cfgtoollogs/opatch/opatch2017-08-01_14-45-02PM_1.log

Lsinventory Output file location :/u01/app/oracle/product/12.2.0/db_2/cfgtoollogs/opatch/lsinv/lsinventory2017-08-01_14-45-02PM.txt

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

Local Machine Information::

Hostname: rac01

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 12c                                                 12.2.0.1.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in thisOracle Home.

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

OPatch succeeded.

4、OPatch升级

说明：应用该psu要求OPatch工具版本为12.2.0.1.7或更高

（1）上传最新OPatch工具

登录/注册后可看大图