mopatch oracle_Oracle OPatch工具和Patch

下载安装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, Orac