PSU 安装11g RAC 11.2.0.3.0 to 11.2.0.3.1_if you have unzipped this patch to an empty-优快云博客

http://space.itpub.net/9664900/viewspace-720261

前言

环境介绍：

两台主机，操作系统Enterprise Linux Server release 5.5 32bit、

Oracle 11gR2(11.2.0.3.0),RAC,ASM

数据库名：racdb

实例名：racdb1,racdb2

CRS_HOME：/home/grid/app/11.2.0.3/grid

DB_HOME：/oracle/app/oracle/product/11.2.0.3/dbhome_1

PSU介绍详见Metalink文档：

Patch Set Updates for Oracle Products [ID 854428.1]

各数据库版本PSU版本更新文档：

Oracle Recommended Patches -- Oracle Database [ID 756671.1]

根据metalink文档的信息，升级PSU到11.2.0.3.1需要下载两个Patch：13343438、13348650

根据文档的说明，其中Patch：13348650已包括了Patch：13343438文件，所以只需下载Patch:13348650

关于Patch：13348650介绍详见文档：

Bug 13348650 - 11.2.0.3.1 Grid Infrastructure Patch Set Update (GI PSU) [ID 13348650.8]

关于Patch：13348650介绍详见文档：

Bug 13343438 - 11.2.0.3.1 Patch Set Update (PSU) [ID 13343438.8]

在以上两个文档中需要重点关注“Known Issues”部分，看一下在安装PSU之前对补丁的相关说明及注意事项，有没有相关的补丁需要额外安装。

g X@3G"m01 PSU安装过程
6[1MH2M~#H)[k~01.1 备份HOME目录及数据库ITPUB个人空间nR(N*DK9{+QR6L
略

1.2 解压补丁文件
G,I;`-q8~L!L5H,n0[oracle@rac1 soft]$unzip p13348650_112030_LINUX.zip

[grid@rac1 p13348650]$ pwd

/soft/p13348650

[grid@rac1 p13348650]$ ls

13343438 13348650

1.3 检查OPatch版本信息
n]l a}RFu0以下来自Patch13348650 README文档原文：

You must use the OPatch utility version 11.2.0.1.8 or later to apply this patch. Oracle recommends that you use the latest released OPatch for 11.2 releases, which is available for download from My Oracle Support patch 6880880 by selecting ARU link for the 11.2.0.0.0 release. It is recommended that you download the Opatch utility and the patch in a shared location to be able to access them from any node in the cluster for the patch application on each node.

---要安装这个patch，OPatch的版本必须在11.2.0.1.8或更高，如果达不到要求，则到官方下载最新的版本，下载ID为6880880

我的版本是11.2.0.3.0，已满足要求。

[grid@rac1 soft]$cd /home/grid/app/11.2.0.3/grid/OPatch

[grid@rac1 OPatch]$./opatch version

OPatch Version: 11.2.0.3.0

OPatch succeeded.

1.4 OCM Configuration
'g^2wxk2C0以下来自Patch13348650 README文档原文：

The OPatch utility will prompt for your OCM (Oracle Configuration Manager) response file when it is run. You should enter a complete path of OCM response file if you already have created this in your environment.

If you do not have the OCM response file (ocm.rsp), then you should run the following command to create it.

As the Grid home owner execute:

%<ORACLE_HOME>/OPatch/ocm/bin/emocmrsp

You can also invoke opatch auto with the -ocmrf <OCM response file path> option to run opatch auto in silent mode.

分别在两个节点上操作：

[grid@rac1 soft]$cd /home/grid/app/11.2.0.3/grid

[grid@rac1 grid]$/home/grid/app/11.2.0.3/grid/OPatch/ocm/bin/emocmrsp

[grid@rac1 grid]$ ls -lsa ocm.rsp

4 -rw-r--r-- 1 grid oinstall 621 Mar 24 13:06 ocm.rsp

1.5 检查相关补丁冲突ITPUB个人空间R-{"qQ8Y#e p.g8K2v
结合Patch13348650 README文档的介绍，检查步骤有以下几个：

opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/13343438 –oh $GRID_HOME

opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/13343438 –oh $DB_HOME

opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/13348650 –oh $GRID_HOME

opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>13348650/custom/server/13348650 –oh $DB_HOME

我的环境中，详细过程如下：

su - grid

cd /soft/p13348650

[grid@rac1 p13348650]$/home/grid/app/11.2.0.3/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./13343438 -oh /home/grid/app/11.2.0.3/grid

Oracle Interim Patch Installer version 11.2.0.3.0

PREREQ session

Oracle Home : /home/grid/app/11.2.0.3/grid

Central Inventory : /oracle/app/oraInventory

from : /home/grid/app/11.2.0.3/grid/oraInst.loc

OPatch version : 11.2.0.3.0

OUI version : 11.2.0.3.0

Log file location : /home/grid/app/11.2.0.3/grid/cfgtoollogs/opatch/opatch2012-03-24_13-15-38PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[grid@rac1 p13348650]$/home/grid/app/11.2.0.3/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./13348650 -oh /home/grid/app/11.2.0.3/grid

Oracle Interim Patch Installer version 11.2.0.3.0

PREREQ session

Oracle Home : /home/grid/app/11.2.0.3/grid

Central Inventory : /oracle/app/oraInventory

from : /home/grid/app/11.2.0.3/grid/oraInst.loc

OPatch version : 11.2.0.3.0

OUI version : 11.2.0.3.0

Log file location : /home/grid/app/11.2.0.3/grid/cfgtoollogs/opatch/opatch2012-03-24_13-19-06PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

su - oracle

cd /soft/p13348650

[oracle@rac1 p13348650]$ /oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./13343438 -oh /oracle/app/oracle/product/11.2.0.3/dbhome_1

Oracle Interim Patch Installer version 11.2.0.3.0

PREREQ session

Oracle Home : /oracle/app/oracle/product/11.2.0.3/dbhome_1

Central Inventory : /oracle/app/oraInventory

from : /oracle/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc

OPatch version : 11.2.0.3.0

OUI version : 11.2.0.3.0

Log file location : /oracle/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2012-03-24_13-17-53PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

[oracle@rac1 p13348650]$ /oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./13348650/custom/server/13348650 -oh /oracle/app/oracle/product/11.2.0.3/dbhome_1

Oracle Interim Patch Installer version 11.2.0.3.0

PREREQ session

Oracle Home : /oracle/app/oracle/product/11.2.0.3/dbhome_1

Central Inventory : /oracle/app/oraInventory

from : /oracle/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc

OPatch version : 11.2.0.3.0

OUI version : 11.2.0.3.0

Log file location : /oracle/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2012-03-24_13-21-38PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

通过以上的检查，未发现补丁冲突。

1.6 通过OPatch 工具自动安装PSUITPUB个人空间#VH(y Iu9Z
以下来自Patch13348650 README文档原文：

To patch GI home and all Oracle RAC database homes of the same version:

opatch auto <UNZIPPED_PATCH_LOCATION> -ocmrf <ocm response file>

To patch only the GI home:

#opatch auto <UNZIPPED_PATCH_LOCATION> -oh <GI_HOME> -ocmrf <ocm response file>

To patch one or more Oracle RAC database homes:

#opatch auto <UNZIPPED_PATCH_LOCATION> -oh <path to RAC database1 home>, <path of the RAC database1 home> -ocmrf <ocm response file>

我这里的<UNZIPPED_PATCH_LOCATION> = /soft/p13348650

整个安装过程中，数据库、CRS会自动停止和启动，不需要人工干预。

1.6.1 对GI/CRS安装PSU

第一个节点：

su - root

[root@rac1 ~]# /oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch/opatch auto /soft/p13348650 -oh /home/grid/app/11.2.0.3/grid -ocmrf /home/grid/app/11.2.0.3/grid/ocm.rsp

Executing /usr/bin/perl /oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch/crs/patch112.pl -patchdir /soft -patchn p13348650 -oh /home/grid/app/11.2.0.3/grid -ocmrf /home/grid/app/11.2.0.3/grid/ocm.rsp -paramfile /home/grid/app/11.2.0.3/grid/crs/install/crsconfig_params

opatch auto log file location is /oracle/app/grid/product/11.2.0.3/dbhome_1/OPatch/crs/../../cfgtoollogs/opatchauto2012-03-24_13-37-42.log

Detected Oracle Clusterware install

Using configuration parameter file: /home/grid/app/11.2.0.3/grid/crs/install/crsconfig_params

Enter 'yes' if you have unzipped this patch to an empty directory to proceed (yes/no):yes

Successfully unlock /home/grid/app/11.2.0.3/grid

patch /soft/p13348650/13343438 apply successful for home /home/grid/app/11.2.0.3/grid

patch /soft/p13348650/13348650 apply successful for home /home/grid/app/11.2.0.3/grid

ACFS-9300: ADVM/ACFS distribution files found.

ACFS-9312: Existing ADVM/ACFS installation detected.

ACFS-9314: Removing previous ADVM/ACFS installation.

ACFS-9315: Previous ADVM/ACFS components successfully removed.

ACFS-9307: Installing requested ADVM/ACFS software.

ACFS-9308: Loading installed ADVM/ACFS drivers.

ACFS-9321: Creating udev for ADVM/ACFS.

ACFS-9323: Creating module dependencies - this may take some time.

ACFS-9154: Loading 'oracleoks.ko' driver.

ACFS-9154: Loading 'oracleadvm.ko' driver.

ACFS-9154: Loading 'oracleacfs.ko' driver.

ACFS-9327: Verifying ADVM/ACFS devices.

ACFS-9156: Detecting control device '/dev/asm/.asm_ctl_spec'.

ACFS-9156: Detecting control device '/dev/ofsctl'.

ACFS-9309: ADVM/ACFS installation correctness verified.

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

第二个节点：

su - root

[root@rac2 soft]# /home/grid/app/11.2.0.3/grid/OPatch/opatch auto /soft/p13348650 -oh /home/grid/app/11.2.0.3/grid -ocmrf /home/grid/app/11.2.0.3/grid/ocm.rsp

Executing /usr/bin/perl /home/grid/app/11.2.0.3/grid/OPatch/crs/patch112.pl -patchdir /soft -patchn p13348650 -oh /home/grid/app/11.2.0.3/grid -ocmrf /home/grid/app/11.2.0.3/grid/ocm.rsp -paramfile /home/grid/app/11.2.0.3/grid/crs/install/crsconfig_params

opatch auto log file location is /home/grid/app/11.2.0.3/grid/OPatch/crs/../../cfgtoollogs/opatchauto2012-03-24_14-16-00.log

Detected Oracle Clusterware install

Using configuration parameter file: /home/grid/app/11.2.0.3/grid/crs/install/crsconfig_params

Enter 'yes' if you have unzipped this patch to an empty directory to proceed (yes/no):yes

Successfully unlock /home/grid/app/11.2.0.3/grid

patch /soft/p13348650/13343438 apply successful for home /home/grid/app/11.2.0.3/grid

patch /soft/p13348650/13348650 apply successful for home /home/grid/app/11.2.0.3/grid

ACFS-9300: ADVM/ACFS distribution files found.

ACFS-9312: Existing ADVM/ACFS installation detected.

ACFS-9314: Removing previous ADVM/ACFS installation.

ACFS-9315: Previous ADVM/ACFS components successfully removed.

ACFS-9307: Installing requested ADVM/ACFS software.

ACFS-9308: Loading installed ADVM/ACFS drivers.

ACFS-9321: Creating udev for ADVM/ACFS.

ACFS-9323: Creating module dependencies - this may take some time.

ACFS-9154: Loading 'oracleoks.ko' driver.

ACFS-9154: Loading 'oracleadvm.ko' driver.

ACFS-9154: Loading 'oracleacfs.ko' driver.

ACFS-9327: Verifying ADVM/ACFS devices.

ACFS-9156: Detecting control device '/dev/asm/.asm_ctl_spec'.

ACFS-9156: Detecting control device '/dev/ofsctl'.

ACFS-9309: ADVM/ACFS installation correctness verified.

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

1.6.2 对DB安装PSU

ITPUB个人空间3y&]{$H4@i
第一个节点：

su - root

[root@rac1 ~]# /oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch/opatch auto /soft/p13348650 -oh /oracle/app/oracle/product/11.2.0.3/dbhome_1 -ocmrf /home/grid/app/11.2.0.3/grid/ocm.rsp

Executing /usr/bin/perl /oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch/crs/patch112.pl -patchdir /soft -patchn p13348650 -oh /oracle/app/oracle/product/11.2.0.3/dbhome_1 -ocmrf /home/grid/app/11.2.0.3/grid/ocm.rsp -paramfile /home/grid/app/11.2.0.3/grid/crs/install/crsconfig_params

opatch auto log file location is /oracle/app/grid/product/11.2.0.3/dbhome_1/OPatch/crs/../../cfgtoollogs/opatchauto2012-03-24_13-54-34.log

Detected Oracle Clusterware install

Using configuration parameter file: /home/grid/app/11.2.0.3/grid/crs/install/crsconfig_params

Enter 'yes' if you have unzipped this patch to an empty directory to proceed (yes/no):yes

patch /soft/p13348650/13343438 apply successful for home /oracle/app/oracle/product/11.2.0.3/dbhome_1

patch /soft/p13348650/13348650/custom/server/13348650 apply successful for home /oracle/app/oracle/product/11.2.0.3/dbhome_1

第二个节点：

su - root

[root@rac2 soft]# /oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch/opatch auto /soft/p13348650 -oh /oracle/app/oracle/product/11.2.0.3/dbhome_1 -ocmrf /home/grid/app/11.2.0.3/grid/ocm.rsp

opatch auto log file location is /oracle/app/grid/product/11.2.0.3/dbhome_1/OPatch/crs/../../cfgtoollogs/opatchauto2012-03-24_15-31-13.log

Detected Oracle Clusterware install

Using configuration parameter file: /home/grid/app/11.2.0.3/grid/crs/install/crsconfig_params

Enter 'yes' if you have unzipped this patch to an empty directory to proceed (yes/no):yes

patch /soft/p13348650/13343438 apply successful for home /oracle/app/oracle/product/11.2.0.3/dbhome_1

patch /soft/p13348650/13348650/custom/server/13348650 apply successful for home /oracle/app/oracle/product/11.2.0.3/dbhome_1

1.6.3 在数据库中执行psu apply

ITPUB个人空间*H^\*oUea
[oracle@rac2 dbhome_1]$ cd $ORACLE_HOME/rdbms/admin

[oracle@rac2 admin]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Sat Mar 24 15:39:00 2012

SQL> conn /as sysdba;

Connected.

SQL> @catbundle.sql psu apply

PL/SQL procedure successfully completed.

Generating apply and rollback scripts...

Check the following file for errors:

/oracle/app/grid/cfgtoollogs/catbundle/catbundle_PSU_RACDB_GENERATE_2012Mar24_15_40_03.log

Apply script. /oracle/app/oracle/product/11.2.0.3/dbhome_1/rdbms/admin/catbundle_PSU_RACDB_APPLY.sql

Rollback script. /oracle/app/oracle/product/11.2.0.3/dbhome_1/rdbms/admin/catbundle_PSU_RACDB_ROLLBACK.sql

PL/SQL procedure successfully completed.

Executing script. file...

SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT

SQL> SELECT '/oracle/app/grid/cfgtoollogs/catbundle/' || 'catbundle_PSU_' || name || '_APPLY_' || TO_CHAR(SYSDATE, 'YYYYMonDD_hh24_mi_ss', 'NLS_DATE_LANGUAGE=''AMERICAN''') || '.log' AS spool_file FROM v$database;

SQL> SPOOL &spool_file

SQL> exec dbms_registry.set_session_namespace('SERVER')

PL/SQL procedure successfully completed.

SQL> ALTER SESSION SET current_schema = SYS;

Session altered.

SQL> PROMPT Updating registry...

Updating registry...

SQL> INSERT INTO registry$history

2 (action_time, action,

3 namespace, version, id,

4 bundle_series, comments)

5 VALUES

6 (SYSTIMESTAMP, 'APPLY',

7 SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),

8 '11.2.0.3',

9 1,

10 'PSU',

11 'PSU 11.2.0.3.1');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SPOOL off

SQL> SET echo off

Check the following log file for errors:

/oracle/app/grid/cfgtoollogs/catbundle/catbundle_PSU_RACDB_APPLY_2012Mar24_15_40_17.log

SQL> SQL> SQL>

1.6.4 升级Catalog数据库

ITPUB个人空间 H`,V![QcS#R6]
如果存在catalog数据库，则需对其进行升级

$ rman catalogusername/password@alias

RMAN> UPGRADE CATALOG;

1.6.5 验证PSU安装信息

@ ~6g/eoR(|01.6.5.1 GI/CRS PSU安装验证
q v rc&uAbu~-Yx0第一个节点：

su - grid

[grid@rac1 soft]$ cd /home/grid/app/11.2.0.3/grid/OPatch

[grid@rac1 OPatch]$ ./opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.0

Oracle Home : /home/grid/app/11.2.0.3/grid

Central Inventory : /oracle/app/oraInventory

from : /home/grid/app/11.2.0.3/grid/oraInst.loc

OPatch version : 11.2.0.3.0

OUI version : 11.2.0.3.0

Log file location : /home/grid/app/11.2.0.3/grid/cfgtoollogs/opatch/opatch2012-03-24_13-57-18PM_1.log

Lsinventory Output file location : /home/grid/app/11.2.0.3/grid/cfgtoollogs/opatch/lsinv/lsinventory2012-03-24_13-57-18PM.txt

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

Installed Top-level Products (1):

Oracle Grid Infrastructure 11.2.0.3.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 13348650 : applied on Sat Mar 24 13:48:28 CST 2012

Unique Patch ID: 14292105

Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.1 (13348650)"

Created on 14 Jan 2012, 08:23:42 hrs PST8PDT

Bugs fixed:

13348650, 13039908, 12794268, 13011520, 12784559, 12758736, 13077654

13001901, 13074261, 12971251, 12538907, 13066371, 12857064, 12897651

12897902, 12896850, 12726222, 12829429, 12728585, 13396284, 12899169

13079948, 13111013, 12876314, 12867511, 13090686, 12925041, 12995950

13085732, 12848480, 12829917, 12990582, 12849377, 12934171, 12975811

12917897, 12914824, 13082238, 13334158, 12947871, 12950823, 13355963

12878750, 13001955, 13002015, 11836951, 12965049, 13024624, 12765467

12791719, 12885323, 13345868, 13019958, 13255295, 12810890, 12782756

12823042, 12825835, 12932852, 12695029, 12873909, 13263435, 13038806

12820045, 12842804, 12827493, 13396356, 13045518, 12765868, 12834777

13068077, 12772345, 12823838

Patch 13343438 : applied on Sat Mar 24 13:45:07 CST 2012

Unique Patch ID: 14292105

Patch description: "Database Patch Set Update : 11.2.0.3.1 (13343438)"

Created on 4 Jan 2012, 05:00:38 hrs PST8PDT

Bugs fixed:

12998795, 13466801, 13492735, 12834027, 12620823, 13035804, 13362079

12718090, 13528551, 13041324, 13343438, 12917230, 12847466, 9703627

12797765, 12950644, 12905058, 13499128, 12861463, 9873405, 12938841

Rac system comprising of multiple nodes

Local node = rac1

Remote node = rac2

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

OPatch succeeded.

su - grid

[grid@rac2 soft]$ cd /home/grid/app/11.2.0.3/grid/OPatch

[grid@rac2 OPatch]$ ./opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.0

Oracle Home : /home/grid/app/11.2.0.3/grid

Central Inventory : /oracle/app/oraInventory

from : /home/grid/app/11.2.0.3/grid/oraInst.loc

OPatch version : 11.2.0.3.0

OUI version : 11.2.0.3.0

Log file location : /home/grid/app/11.2.0.3/grid/cfgtoollogs/opatch/opatch2012-03-24_15-28-56PM_1.log

Lsinventory Output file location : /home/grid/app/11.2.0.3/grid/cfgtoollogs/opatch/lsinv/lsinventory2012-03-24_15-28-56PM.txt

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

Installed Top-level Products (1):

Oracle Grid Infrastructure 11.2.0.3.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 13348650 : applied on Sat Mar 24 15:25:49 CST 2012

Unique Patch ID: 14292105

Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.1 (13348650)"