Skip to content

DESCRIPTION.md

Latest commit

 

History

History
27 lines (21 loc) · 1.38 KB

DESCRIPTION.md

File metadata and controls

27 lines (21 loc) · 1.38 KB

Executive Summary

The DBA Registry SQL Patch report tracks the history of SQL patches applied to the database. In modern Oracle versions (12c+), binary patches (applied via opatch) often require a post-install SQL step (applied via datapatch). This report confirms that the SQL portion of the patch was applied successfully.

Business Challenge

  • Patch Verification: "The binary patch is installed, but did the datapatch utility run successfully?"
  • Audit Trail: "When was the 'Release Update 19.18' applied to this database?"
  • Troubleshooting: "Why are we seeing errors related to a patch that was supposed to be fixed?" (Maybe the SQL step failed).

Solution

This report queries DBA_REGISTRY_SQLPATCH.

Key Features:

  • Patch ID: The Oracle bug number associated with the patch.
  • Action: APPLY or ROLLBACK.
  • Status: SUCCESS or WITH ERRORS.
  • Description: A brief description of what the patch fixes.

Architecture

The report queries DBA_REGISTRY_SQLPATCH.

Key Tables:

  • DBA_REGISTRY_SQLPATCH: The inventory of SQL patches.

Impact

  • Compliance: Proves that security patches have been fully implemented (both binary and SQL).
  • Stability: Prevents "half-patched" states where the binaries are new but the data dictionary is old.
  • Version Control: Provides a clear timeline of database software changes.