1.更新opatch包
1.1 chown oracle.oinstall p6880880_112000_Linux-x86-64_opatch.zip
1.2 unzip p6880880_112000_Linux-x86-64_opatch.zip
解压生成OPatch文件夹
1.3 替换$ORACLE_HOME/OPatch
rm -rf $ORACLE_HOME/OPatch
mv OPatch $ORACLE_HOME/
(为方便使用修改Oracle环境变量
export OPATCH_HOME=/u01/app/oracle/product/11.2.0/db_1/OPatch
export PATH=$HOME/bin:$ORACLE_HOME/bin:$GRID_HOME/bin:$OPATCH_HOME:$PATH
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib:$OPATCH_HOME/jlib
)
1.4 验证OPatch版本号
opatch version
OPatch Version: 11.2.0.3.19
OPatch succeeded.
2.解压补丁包
2.1 unzip p28204707_112040_Linux-x86-64.zip
在当前目录下生成文件夹 28204707
2.2 修改补丁使用权限 chown -R oracle.oinstall 28204707
3 打补丁前检查
3.1 关闭数据库
sqlplus / as sysdba
shutdown immediate
关闭监听
lsnrctl stop
3.2 补丁信息检查
cd 28204707
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.19
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2019-01-01_14-55-44PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
4.打补丁
4.1 进入补丁目录
cd 28204707
4.2 打补丁
opatch apply
依次输入
y
y
5.更新数据字典
@?/rdbms/admin/catbundle psu apply
6.补丁后验证
opatch lspatches
28204707;Database Patch Set Update : 11.2.0.4.181016 (28204707)
OPatch succeeded.
opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.19
OUI ve