升级PSU 11.2.0.3.15补丁

此次升级PSU 11.2.0.3.15,opatch version需11.2.3.0.5以上
You must use the OPatch utility version 11.2.0.3.5 or later to apply this patch. Oracle recommends that you use the latest released OPatch version 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.
如果opatch version低于11.2.0.3.5可以到MOS上下载最新版本的6880880补丁。
1、查询当前grid infrastructure与rdbms OPatch版本(两节点执行)
[grid@jzh1 ~]$ $ORACLE_HOME/OPatch/opatch version

OPatch Version: 11.2.0.3.6

OPatch succeeded.

[oracle@jzh1 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 11.2.0.3.6

OPatch succeeded.

2、停止CRS集群(root用户两节点执行)
[root@jzh1 ~]# cd /u01/app/11.2.0/grid/product/11.2.0/db_1/crs/install/
[root@jzh1 install]# ./rootcrs.pl -unlock

3、应用grid补丁(两节点grid用户执行)
[grid@jzh1 patch]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /patch/20760997/
[grid@jzh1 patch]$ $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /patch/17592127/

4、应用DB补丁前执行脚本(oracle用户两节点执行)
[grid@jzh1 patch]$ su - oracle
Password: 
[oracle@jzh1 ~]$ /patch/17592127/custom/server/17592127/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
/patch/17592127/custom/server/17592127/custom/scripts/prepatch.sh completed successfully.

5、应用DB补丁(oracle用户两节点执行)
[oracle@jzh1 ~]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /patch/17592127/custom/server/17592127/
[oracle@jzh1 ~]$ $ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /patch/20760997/

6、应用DB补丁后执行脚本(oracle用户两节点执行)
[oracle@jzh1 ~]$ /patch/17592127/custom/server/17592127/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME

7、使用root用户执行脚本(两节点执行)
[root@jzh1 ~]# /u01/app/11.2.0/grid/product/11.2.0/db_1/rdbms/install/rootadd_rdbms.sh 

8、使用root用户执行脚本启动crs(两节点执行)
[root@jzh1 ~]# /u01/app/11.2.0/grid/product/11.2.0/db_1/crs/install/rootcrs.pl -patch
Using configuration parameter file: /u01/app/11.2.0/grid/product/11.2.0/db_1/crs/install/crsconfig_params
CRS-4123: Oracle High Availability Services has been started.

9、执行脚本更新DB补丁记录(sysdba用户登陆数据库)
SQL> @catbundle.sql psu apply
PL/SQL procedure successfully completed.
Function created.
Function created.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.

10、检查补丁状态
查询DB补丁记录
SQL> col action_time for a30      
SQL> col version for a15
SQL> col id for 99
SQL> col action for a10
SQL> col namespace for a10
SQL> col COMMENTS for a20
SQL> col BUNDLE_SERIES for a15
SQL> select * from registry$history;

ACTION_TIME                    ACTION     NAMESPACE  VERSION          ID COMMENTS             BUNDLE_SERIES
------------------------------ ---------- ---------- --------------- --- -------------------- ---------------
18-MAY-15 06.00.37.558947 AM   APPLY      SERVER     11.2.0.3          0 Patchset 11.2.0.2.0  PSU
31-JUL-15 11.45.37.745581 AM   APPLY      SERVER     11.2.0.3         15 PSU 11.2.0.3.15      PSU

2 rows selected.

11、查询补丁状态grid用户执行(两节点执行)
[grid@jzh1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
17592127;Grid Infrastructure Patch Set Update : 11.2.0.3.9 (HAS Components)
20760997;Database Patch Set Update : 11.2.0.3.15 (20760997)
[grid@jzh1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory

12、查询补丁状态oracle用户执行(两节点执行)
[oracle@jzh1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
20760997;Database Patch Set Update : 11.2.0.3.15 (20760997)
17592127;Grid Infrastructure Patch Set Update : 11.2.0.3.9 (HAS Components)
[oracle@jzh1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory




请使用浏览器的分享功能分享到微信等