Oracle Patch升级_PSU安装11g RAC 11.2.0.3.0 to 11.2.0.3.1

前言

环境介绍：
[color=mediumturquoise]两台主机，操作系统Enterprise Linux Server release 5.5 32bit、
[color=mediumturquoise]Oracle 11gR2(11.2.0.3.0),RAC,ASM
[color=mediumturquoise]数据库名：racdb
[color=mediumturquoise]实例名：racdb1,racdb2
[color=mediumturquoise]CRS_HOME：/home/grid/app/11.2.0.3/grid
[color=mediumturquoise]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之前对补丁的相关说明及注意事项，有没有相关的补丁需要额外安装。

1 PSU安装过程
1.1 备份HOME目录及数据库
略
1.2 解压补丁文件
[oracle@rac1 soft]$ unzip p13348650_112030_LINUX.zip
[grid@rac1 p13348650]$ pwd
/soft/p13348650
[grid@rac1 p13348650]$ ls
13343438 13348650
1.3 检查OPatch版本信息
以下来自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
以下来自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:
%/OPatch/ocm/bin/emocmrsp
You can also invoke opatch auto with the -ocmrf 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 检查相关补丁冲突
结合Patch13348650 README文档的介绍，检查步骤有以下几个：
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /13343438 –oh $GRID_HOME
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /13343438 –oh $DB_HOME
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /13348650 –oh $GRID_HOME
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 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
Copyright (c) 2012, Oracle Corporation. All rights reserved.
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
Copyright (c) 2012, Oracle Corporation. All rights reserved.
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
Copyright (c) 2012, Oracle Corporation. All rights reserved.
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
Copyright (c) 2012, Oracle Corporation. All rights reserved.
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 工具自动安装PSU
以下来自Patch13348650 README文档原文：
To patch GI home and all Oracle RAC database homes of the same version:
opatch auto -ocmrf

To patch only the GI home:
#opatch auto -oh -ocmrf

To patch one or more Oracle RAC database homes:
#opatch auto -oh , -ocmrf

我这里的 = /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

第一个节点：
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

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_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

[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
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn /as sysdba;
Connected.
SQL> @catbundle.sql psu apply
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
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数据库

如果存在catalog数据库，则需对其进行升级
$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;

1.6.5 验证PSU安装信息

1.6.5.1 GI/CRS PSU安装验证
第一个节点：
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
Copyright (c) 2012, Oracle Corporation. All rights reserved.
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
Copyright (c) 2012, Oracle Corporation. All rights reserved.

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)"
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 15:20:15 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 = rac2
Remote node = rac1
--------------------------------------------------------------------------------
OPatch succeeded.

1.6.5.2 数据库软件PSU安装验证

第一个节点：
su – oracle
[oracle@rac1 soft]$ cd /oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch
[oracle@rac1 soft]$ ./opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
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_14-10-52PM_1.log
Lsinventory Output file location : /oracle/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2012-03-24_14-10-52PM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (4) :

Patch 13348650 : applied on Sat Mar 24 13:58:22 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

Patch 13343438 : applied on Sat Mar 24 13:57:05 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

Patch (online) 13588248: applied on Sat Mar 24 12:19:57 CST 2012
Unique Patch ID: 14543926
Created on 3 Feb 2012, 13:50:52 hrs PST8PDT
Bugs fixed:
13588248

Patch 13656236 : applied on Sat Mar 24 11:35:16 CST 2012
Unique Patch ID: 14539314
Created on 13 Mar 2012, 13:20:01 hrs PST8PDT
Bugs fixed:
13370330, 13004894
Rac system comprising of multiple nodes
Local node = rac1
Remote node = rac2
-------------------------------------------------------------------------------
OPatch succeeded.

第二个节点：
su – oracle
[oracle@rac2 soft]$ cd /oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch
[oracle@rac2 soft]$ ./opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
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_15-38-18PM_1.log
Lsinventory Output file location : /oracle/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2012-03-24_15-38-18PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (4) :

Patch 13348650 : applied on Sat Mar 24 15:35:42 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

Patch 13343438 : applied on Sat Mar 24 15:34:05 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

Patch (online) 13588248: applied on Sat Mar 24 12:19:57 CST 2012
Unique Patch ID: 14543926
Created on 3 Feb 2012, 13:50:52 hrs PST8PDT
Bugs fixed:
13588248

Patch 13656236 : applied on Sat Mar 24 11:35:16 CST 2012
Unique Patch ID: 14539314
Created on 13 Mar 2012, 13:20:01 hrs PST8PDT
Bugs fixed:
13370330, 13004894

Rac system comprising of multiple nodes
Local node = rac2
Remote node = rac1
--------------------------------------------------------------------------------
OPatch succeeded.

1.6.5.3 数据库实例PSU安装验证

SQL> select action,comments from registry$history;

ACTION COMMENTS
------------------------------ --------------------------------------------------
VIEW INVALIDATE view invalidation
UPGRADE Upgraded from 11.2.0.1.0
APPLY PSU 11.2.0.3.1