Die Quellen für den Artikel kommen von https://mikedietrichde.com/ und von https://support.oracle.com.

MOS Note: 2118136.2 hier gibt es die Patches!!!

MOS Note: 742060.1 - Release Schedule of Current Database Releases

MOS Note:742060.1 - The Single Source of Truth

MOS Note:161818.1 - Releases Support Status Summary

Lifetime Support Policy Brochure: http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf

Es gibt seit 12.2 zwei Update Patch Varianten

Updates (RU) z.B. 19.7.0 and Revisions (RUR) 19.3.2 ! Nur im RU sind alle Sicherheitspatches enthalten!

Oracle Database - Overview of Database Patch Delivery Methods for 12.2.0.1 and greater
(Doc ID 2337415.1)

Most Important Notes

MOS Note: 742060.1
Release Schedule of Current Database Releases
https://support.oracle.com/epmos/faces/DocumentDisplay?id=742060.1
MOS Note: 2285040.1
Release Update Introduction and FAQ
https://support.oracle.com/epmos/faces/DocumentDisplay?id=2285040.1
MOS Note: 756671.1
Master Note for Database Proactive Patch Program
https://support.oracle.com/epmos/faces/DocumentDisplay?id=756671.1
MOS Note: 1962125.1
Oracle Database - Overview of Database Patch Delivery Methods for 12.1.0.2 and lower
https://support.oracle.com/epmos/faces/DocumentDisplay?id=1962125.1
MOS Note 2337415.1
Oracle Database - Overview of Database Patch Delivery Methods for 12.2.0.1 and greater
https://support.oracle.com/epmos/faces/DocumentDisplay?id=2337415.1
MOS Note: 2118136.2
Assistant: Download Reference for Oracle Database/GI PSU, SPU(CPU), Bundle Patches

Basic Facts | Patch Inventory

$ opatch lsinventory

Tells you what is installed in your software home
DBMS_QOPATCH package provides access to
• Patches installed in the Oracle Home
• FAQ on Queryable Patch Inventory (MOS Note: 1530108.1)
DBA_REGISTRY_SQLPATCH
• View detailing information about SQL patches installed in the database

Recommendation | Out-of-Place Patching

Finding the Right Patches | Quarterly

https://www.oracle.com/security-alerts/

Quarterly Release Update Patch Reference

• Oracle Database 19c Proactive Patch Information MOS Note: 2521164.1

• Database 18 Proactive Patch Information MOS Note: 2369376.1

• Database 12.2.0.1 Proactive Patch Information MOS Note: 2285557.1

• Database 12.1.0.2 Proactive Patch Information MOS Note: 2285558.1

• Database 11.2.0.4 Proactive Patch Information MOS Note: 2285559.1

Recommendation | OJVM

Wenn OJVM installiert ist, dann sollte jedes Patch mitgenommen werden (MOS Note: 2217053.1)!

Achtung in der Regel ist die Anleitung falsch, ein startup upgrade ist nicht erforderlich!

OJVM kann deaktiviert werden siehe (MOS Note: 1929745.1)

Wichtig: https://mikedietrichde.com/2020/03/31/ojvm-and-the-mitigation-patch-things-to-know-in-2020/

Jedoch muss es bei jedem Datenbank-Patch vorab aktiviert werden!

Java deinstallation:

https://mikedietrichde.com/2017/08/07/javavm-xml -clean-oracle-database-11-2-12-2/

Safe repair/reinstall of the JVM Component in 11.2 and up MOS Note: 2314363.1

Repairing/Reinstalling JVM To A Multitenant Database (CDB and all PDBs) MOS Note: 2262919.1

opatch

MOS Note: 274526.1 – How To Download And Install The Latest OPatch(6880880) Version

Download always the newest OPatch
• Opatch download via patch 6880880
Be aware of "opatch util cleanup"
• https://mikedietrichde.com/2020/04/17/opatch-alert-beaware-of-cleanup-issues-and-the-jdk-version/

Patch Download Assistant

Always use the Patch Download Assistant note MOS Note: 2118136.2