Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center