Patch 28998679: COMMENTS MISSING FROM DICTIONARY IN PDB
Back in 2019 I logged a bug against the database for missing comments in the dictionary view in pluggable database (see: https://carsandcode.com/2019/02/17/oracle-broke-dictionary-in-12-2-pdbs/).
In October last year the database team finally released a fix! However, that fix is specific to the 19.16 version of the database... When I tried to apply it to my 19.17 database I got the following:
[oracle@databaseserver DB:dbacon /dba/resources/software_downloads/2022-11-19_dict_comments_patch_for_19.16/28998679]
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.32
Copyright (c) 2023, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/19.0.0.0/dbhome_1