升级补丁软件opatch(6880880)

环境:

DB:11.2.0.4

1.下载相应的opatch
我这里下载的是p6880880_112000_LINUX.zip

RAC环境下,grid软件下的OPatch升级也是使用同样的安装包

多个节点的情况下，可以在一个节点部署好,然后scp -r拷贝OPatch目录到另外的机器,注意修改权限.

 

 

 

下载地址:

https://support.oracle.com/epmos/faces/PatchSearchResults?_adf.ctrl-state=xj7vwgg3z_25&_afrLoop=180296094575766

需要mos账号

 

 

 

 

2.解压
上传到服务器,单独存放到临时目录
[root@hxl soft]# mkdir pat
[root@hxl soft]# mv p6880880_112000_Linux-x86-64.zip ./pat/
[root@hxl pat]# unzip p6880880_112000_Linux-x86-64.zip
修改权限
[root@hxl pat]# chown -R oracle:oinstall ./pat/

 

3.升级
备份原来的目录
su - oracle
[oracle@hxl db_1]$ cd $ORACLE_HOME
[oracle@hxl db_1]$ mv OPatch bak_OPatch

将步骤2解压的目录拷贝到ORACLE_HOME目录

[oracle@hxl pat]$ mv OPatch /u01/app/oracle/product/11.2.0.4/db_1/

 

 

4.查看升级情况

./opatch version

[oracle@hxl 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: hxl
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.

 

 

#########################################grid软件OPatch升级########################################

1.解压并修改权限
[root@rac01 pat]# pwd
/soft/pat
[root@rac01 pat]# unzip p6880880_122010_Linux-x86-64.zip
[root@rac01 pat]# chown -R grid:oinstall ./OPatch/

2.备份grid软件下的OPatch
su - root
[root@rac01 ~]# cd /u01/grid/grid_home/12.2.0.1
[root@rac01 12.2.0.1]# mv OPatch bak_OPatch

 

3.拷贝刚才新版本的OPatch到grid软件目录

注意这里是使用root账号操作
[root@rac01 12.2.0.1]# pwd
/u01/grid/grid_home/12.2.0.1
[root@rac01 12.2.0.1]# mv /soft/pat/OPatch ./

 

4.查看

./opatch version

[grid@rac01 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.40
Copyright (c) 2023, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/grid/grid_home/12.2.0.1
Central Inventory : /u01/grid/oraInventory
   from           : /u01/grid/grid_home/12.2.0.1/oraInst.loc
OPatch version    : 12.2.0.1.40
OUI version       : 12.2.0.1.4