--OCW补丁在GRID补丁包中，readme中描述为CRS/RDBMS，以RU19.20为例，对应的目录为 35320149

--检查OPatch版本
opatch version

--检查数据库软件版本
opatch lspatches

--检查数据库补丁情况
SET PAGESIZE 1000
SET SERVEROUT ON
SET LONG 2000000
COLUMN action_time FORMAT A12
COLUMN action FORMAT A10
COLUMN comments FORMAT A30
COLUMN description FORMAT A60
COLUMN namespace FORMAT A20
COLUMN status FORMAT A10N status FORMAT A10
SELECT TO_CHAR(action_time, 'YYYY-MM-DD') AS action_time,
action,
status,
description,
patch_id 
FROM sys.dba_registry_sqlpatch 
ORDER by action_time;

--检查组件情况
col comp_id for a10
col version for a11
col status for a10
col comp_name for a37
select comp_id,comp_name,version,status from dba_registry;

--关闭数据库及监听

--验证Oracle Inventory
opatch lsinventory -detail -oh $ORACLE_HOME

--检查补丁冲突
opatch prereq CheckConflictAgainstOHWithDetail -ph ./

--升级opatch
--升级db
--升级ojvm
--升级ocw  该补丁为集群组件补丁，没有使用集群组件可以不打，有强迫症的话就打吧

--打开数据库及监听

--加载变化的SQL到数据库(时间较长，30分钟左右)
su - oracle
cd $ORACLE_HOME/OPatch
./datapatch -verbose

--编译无效对象
sqlplus / as sysdba
@$ORACLE_HOME/rdbms/admin/utlrp.sql

--查看版本变化
col ACTION for a8
col status for a10
set line 200
col ACTION_TIME for a30
col DESCRIPTION for a60
select patch_id,action,status,action_time,description from dba_registry_sqlpatch;

--检查组件情况
col comp_id for a10
col version for a11
col status for a10
col comp_name for a37
select comp_id,comp_name,version,status from dba_registry;

--查看升级情况
opatch lspatches

--35320149;OCW RELEASE UPDATE 19.20.0.0.0 (35320149)
--35354406;OJVM RELEASE UPDATE: 19.20.0.0.230718 (35354406)
--35320081;Database Release Update : 19.20.0.0.230718 (35320081)