oracle 11.2.0.4 补丁安装

Reference

1. Oracle Grid Infrastructure 11.2.0.4.x Patch Set Update SUPPLEMENTAL README (Doc ID 1641136.1)
2. https://w.cnblogs.com/jyzhao/p/4905246.html#2

0、环境信息

• IP：192.168.37.61、192.168.37.65
• OS: redhat 6.5
• DB:11.2.0.4
• opatch:11.2.0.3.27
• psu: p31718723_112040_Linux-x86-64.zip
• GRID_HOME: /u01/app/11.2.0/grid
• ORACLE_HOME: /u01/app/oracle/product/11.2.0/dbhome_1

1、备份家目录

mkdir -p /u01/app/software/psu/backup
cd /u01/app/software/psu/backup
tar -pcvf grid_home.tar /u01/app/11.2.0/grid
tar -pcvf db_home.tar /u01/app/oracle/product/11.2.0/dbhome_1
tar -pcvf inv.tar /u01/app/oraInventory

2、传输补丁文件和最新OPatch

使用 xftp 传输至 /u01/software/psu/ 目录即可

3、更新OPatch

更新OPatch

## as root 
cd /u01/app/11.2.0/grid
ll | grep OPatch
mv OPatch/ OPatch_20210225
cp /u01/software/psu/p6880880_112000_Linux-x86-64.zip ./
unzip p6880880_112000_Linux-x86-64.zip
chown -R grid. OPatch
chmod -R 755 OPatch


## as oracle
su - oracle
cd $ORACLE_HOME
mv OPatch OPatch_20210225
cp /u01/software/psu/p6880880_112000_Linux-x86-64.zip ./
unzip p6880880_112000_Linux-x86-64.zip
chmod -R 755 OPatch

检查opatch版本

[root@zdata-db01 grid]# su - grid
[grid@zdata-db01 ~]$ opatch version
OPatch Version: 11.2.0.3.27

OPatch succeeded.


[root@zdata-db01 ~]# su - oracle
[oracle@zdata-db01 ~]$ opatch version
OPatch Version: 11.2.0.3.27

OPatch succeeded.

4、解压补丁文件

# as grid 
cd /u01/software/psu/
unzip p31718723_112040_Linux-x86-64.zip

5、检查补丁冲突

su - grid
cd /u01/software/psu/31718723
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

su - oracle
cd /u01/software/psu/31718723/31537677
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

grid 用户执行结果

[grid@zdata-db01 31718723]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.27
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

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.27
OUI version       : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2021-02-25_13-39-41PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

oracle 用户执行结果

[oracle@zdata-db01 31537677]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.27
Copyright (c) 2021, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version    : 11.2.0.3.27
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2021-02-25_13-41-00PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

6、停止数据库和本地crs服务

su - oracle
$ORACLE_HOME/bin/srvctl stop instance -d odsdb -i odsdb1
su – root
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -unlock

7、手动更新补丁

grid install psu

$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/software/psu/31718723

db install psu

$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /u01/software/psu/31718723/31537677

$<UNZIPPED_PATCH_LOCATION>/<patch>/custom/server/<patch>/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>
$<ORACLE_HOME>/OPatch/opatch napply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/<patch>/custom/server/<patch>
$<UNZIPPED_PATCH_LOCATION>/<patch>/custom/server/<patch>/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME>

execute rootcrs.pl

su – root
/u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh 
/u01/app/11.2.0/grid/crs/install/rootcrs.pl -patch

8、升级字典和编译失效对象

su - oracle
export ORACLE_SID=<sid_name>
sqlplus / as sysdba
@?/rdbms/admin/catbundle.sql psu apply
@?/rdbms/admin/utlrp.sql

9、验证补丁更新结果

set lines 200
col action for a20
col version for a30
select to_char(action_time,'yyyy-mm-dd'), action,version from dba_registry_history;