dba_registry_history与dba_registry_sqlpatch和OJVM补丁

Question

是否应该列出所有已安装的修补程序并因此也列出OJVM修补程序？

或者OJVM补丁只在dba_registry_history-view中列出？

Answer 1

如果数据库得到了正确的修补，DBA_REGISTRY_SQLPATCH应该列出OJVM修补程序。下面的输出来自我的一个沙箱环境：

SQL> select DESCRIPTION, ACTION, STATUS, ACTION_TIME from dba_registry_sqlpatch;

DESCRIPTION                                                       ACTION          STATUS          ACTION_TIME
----------------------------------------------------------------- --------------- --------------- --------------------
Database PSU 12.1.0.2.190716, Oracle JavaVM Component (JUL2019)   APPLY           SUCCESS         2019-10-01 15:31:58
DATABASE PATCH SET UPDATE 12.1.0.2.190716                         APPLY           SUCCESS         2019-10-01 15:31:59

SQL> select comments from dba_registry_history;

COMMENTS
--------------------------------------------------------------------------------
RDBMS_12.1.0.2.0DBPSU_LINUX.X64_161210