My Oracle Support Banner

Complete Steps To Validate LogMiner Invalid Objects If After Installation of A New PSU or Bundle Patch One or More LogMiner Object Remain in Invalid Status (Doc ID 2539889.1)

Last updated on DECEMBER 10, 2019

Applies to:

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

Goal

LogMiner objects can be found in INVALID status in dba_objects view after the installation of a new PSU or Bundle Patch.
Datapatch can also report errors for LogMiner related objects and the patch installation might complete with errors.
One of the possible errors reported during datapatch execution could be:

but there could be different compilation errors reported as well.

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
References

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