My Oracle Support Banner

Queryable Patch Inventory -- SQL Interface to view, compare, validate database patches (Doc ID 1585814.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.

Goal

Oracle Database 12c, provides access to the OPatch inventory information from within the database using PL/SQL and SQL interface. Some of the usecases to  leverage Queryable patch inventory are illustrated here

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Introduction
 Usecases
 Displaying Details of Single Patch
 Determine Patches Install Status
 Determine Patches Pre-req and Overlay
 Pre-req
 Overlay
 Compare Patch Levels among RAC Instances
 Get RAC instance specific patch details
  Compare Patches in RAC
 Compare Patch Levels: Reference (Gold) Patch Level
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.