My Oracle Support Banner

LogMiner Related Privileges Are Missing from SYSTEM_PRIVILEGE_MAP After Upgrade to 12.1.0.1 (Doc ID 2197180.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Information in this document applies to any platform.

Purpose

The following LogMiner related privilege should be listed while querying system_privilege_map in 12.1:

select * from system_privilege_map where name like '%LOGMINING';

PRIVILEGE NAME PROPERTY
---------- ---------------------------------------- ----------
-389 LOGMINING 0

But, due to unpublished Bug 16684631 -LOGMINING PRIVILEGE NOT DISPLAYED IN SYSTEM_PRIVILEGE_MAP OF AN UPGRADED DB, the query above does not return this row for a database that was upgraded to 12.1.0.1.

When faced with the consequences of unpublished Bug 16684631, you have at least two options to chose from as workarounds.

1) Upgrade the affected 12.1.0.1 database to 12.1.0.2 using an in-place upgrade approach, since the associated upgrade scripts of 12.1.0.2 do add the LOGMINING system privilege to the target database.
2) Manually add the LOGMINING system privilege to the affected 12.1.0.1 database.

This document provides a manual set of commands to use to add the missing LOGMINING system privilege metadata into a database that was upgraded to 12.1.0.1 using the in-place upgrade approach.

Scope

 Applies only to 12.1.0.1 databases that were upgraded from a previous version using an in-place upgrade approach.

Details

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
Purpose
Scope
Details
References

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