环境:
DB:11.2.0.4
1.下载相应的opatch
我这里下载的是p6880880_112000_LINUX.zip
下载地址:
https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=xj7vwgg3z_25&_afrLoop=180296094575766
需要mos账号
2.解压
上传到服务器,单独存放到临时目录
[root@epidbhn soft]# mkdir pat
[root@epidbhn soft]# mv p6880880_112000_Linux-x86-64.zip ./pat/
[root@epidbhn pat]# unzip p6880880_112000_Linux-x86-64.zip
修改权限
[root@epidbhn pat]# chown -R oracle:oinstall ./pat/
3.升级
备份原来的目录
su - oracle
[oracle@epidbhn db_1]$ cd $ORACLE_HOME
[oracle@epidbhn db_1]$ mv OPatch bak_OPatch
将步骤2解压的目录拷贝到ORACLE_HOME目录
[oracle@epidbhn pat]$ mv OPatch /u01/app/oracle/product/11.2.0.4/db_1/
4.查看升级情况
[oracle@epidbhn OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.32
Copyright (c) 2021, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.4/db_1/oraInst.loc
OPatch version : 11.2.0.3.32
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2021-11-30_10-52-25AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/lsinv/lsinventory2021-11-30_10-52-25AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: epidbhn
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.