下载安装psu补丁（one-off的不用更新数据字典，直接apply即可）

mos里输入latest opatch下载最新的OPatch工具和patch 27734982 下载需要的补丁

https://updates.oracle.com/download/6880880.html

2.下载之后上传到环境中，然后将之前的OPatch重命名，将下载的OPatch移动到ORACLE_HOME下

3.然后opatch version查看当前的版本和查看数据字典里面的版本

SQL>  select action_time,version,comments from dba_registry_history;

ACTION_TIME               VERSION            COMMENTS
------------------------------ -------------------- -------------------------
10-SEP-19 03.37.01.011112 PM   11.2.0.4         Patchset 11.2.0.2.0

4.然后cd到下载的补丁里$ cd 27734982/ 先冲突检测

$/u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

没有问题即可关实例、关监听开始应用

[oracle@dandb 27734982]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply

Oracle Interim Patch Installer version 11.2.0.3.25
Copyright (c) 2019, 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.25
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2019-09-11_23-14-47PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   17478514  18031668  18522509  19121551  19769489  20299013  20760982  21352635  21948347  22502456  23054359  24006111  24732075  25869727  26609445  26392168  26925576  27338049  27734982  

Do you want to proceed? [y|n]
y
User Responded with: Y


5、安装因权限问题报错，将那个报错的文件赋予权限chmod 775，回退

./OPatch rollback -id 27734982   即回退到打27734982补丁之前

6.然后继续安装

[oracle@dandb 27734982]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply

Patching component oracle.rdbms.rman, 11.2.0.4.0...
Composite patch 27734982 successfully applied.
Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2019-09-11_23-30-38PM_1.log

OPatch succeeded.

7.升级数据字典

[oracle@dandb ~]$ cd /u01/app/oracle/product/11.2.0/db_1/rdbms/admin

[oracle@dandb admin]$ sqlplus / as sysdba

SQL>startup

SQL>@catbundle.sql psu apply
.
.
.
Commit complete.

SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_MUCHEN_APPLY_2019Sep11_23_56_35.log
SQL>

7.查看数据字典里面的版本

SQL>  select action_time,version,comments from dba_registry_history;

SQL> select action_time,version,comments from dba_registry_history;

ACTION_TIME                              VERSION              COMMENTS
---------------------------------------- -------------------- ----------------------------------------
10-SEP-19 03.37.01.011112 PM             11.2.0.4             Patchset 11.2.0.2.0
11-SEP-19 11.56.58.942033 PM             11.2.0.4             PSU 11.2.0.4.180717