ORA-28086: The data redaction policy expression has an error


Error:


 ERROR at line 1:
ORA-28086: The data redaction policy expression has an error.
ORA-06512: at "SYS.DBMS_REDACT_INT", line 3
ORA-06512: at "SYS.DBMS_REDACT", line 42
ORA-06512: at line 1

When we try to run same as sys user it is working perfectly fine, but as a normal user it is failing with below errors.




No Privileges issue because AVO user had DBA Privilege ..

Versions confirmed as being affected

Fixed:

The fix for 20693579 is first included in


Cause :


To BottomTo Bottom

Bug 20693579  DBMS_REDACT.ADD_POLICY fails with ORA-28086 when CURSOR_SHARING is force

 This note gives a brief overview of bug 20693579.
 The content was last updated on: 17-FEB-2017
 Click here for details of each of the sections below.

Affects:

Product (Component)Oracle Server (Rdbms)
Range of versions believed to be affectedVersions >= 12.1 but BELOW 12.2
Versions confirmed as being affected
Platforms affectedGeneric (all / most platforms affected)

Fixed:

The fix for 20693579 is first included in

Interim patches may be available for earlier versions - click here to check.

Symptoms:

Related To:

Description

Creating a Data Redaction policy may fails with an
   ORA-28086: The data redaction policy expression has an error.
when CURSOR_SHARING is set to FORCE using
   alter system set cursor_sharing=force;
when using a simple Policy Expression such as '1=1', or a Policy Expression involving any constants.
 
Eg:
 connect scott/tiger
 create table tt (c1 number,c2 varchar2(50));
 
 connect / as sysdba
 alter system set cursor_sharing=force;
 alter system flush buffer_cache;
 alter system flush shared_pool;
 
 begin
  dbms_redact.add_policy(
    object_schema=>'SCOTT'
   ,object_name=>'TT'
   ,column_name=>'C1'
   ,policy_name=>'P1'
   ,function_type=>DBMS_REDACT.FULL
   ,expression=>'1=1');
 end;
 /
 
 ^
 ORA-28086: The data redaction policy expression has an error.
 
Workaround
 None
Thanks
Anil 

Comments

  1. sneha20 December 2018 at 04:36

    If the cursor_sharing=FORCE, then this issue might occur. I am using Oracle database version -11.2.0.4. I have changed the cursor_sharing='EXACT' value and it works fine.



    SQL> sho parameter cursor

    NAME TYPE
    ------------------------------------ -------------------------
    VALUE
    ------------------------------
    cursor_bind_capture_destination string
    memory+disk
    cursor_sharing string
    FORCE
    cursor_space_for_time boolean
    FALSE
    open_cursors integer
    5000
    session_cached_cursors integer

    NAME TYPE
    ------------------------------------ -------------------------
    VALUE
    ------------------------------
    5000
    SQL> alter session set cursor_sharing='EXACT';

    Session altered.

    ReplyDelete

Post a Comment

Popular posts from this blog

Useful OEM Queries to get Target details from OEM Repository

List Targets with TNS Listener ports configured : SELECT mgmt$target.host_name , mgmt$target.target_name , mgmt$target.target_type , mgmt$target_properties.property_name , mgmt$target_properties.property_value FROM mgmt$target , mgmt$target_properties WHERE ( mgmt$target.target_name = mgmt$target_properties.target_name ) AND ( mgmt$target.target_type = mgmt$target_properties.target_type ) and ( mgmt$target.target_type = 'oracle_listener' ) and ( mgmt$target_properties.property_name = 'Port' ); Devora02       LISTENER_ora02                       oracle_listener Port 1529 Devora01       LISTENER_ora01                       oracle_listener Port 1529 Devora04       LISTENER_ora04                       oracle_listener Port 1529 List Machine_Names, CPU Count & Database Verion for Licensing SELECT mgmt$target.host_name , mgmt$target_properties.property_name , mgmt$target_properties.property_value FROM mgmt$target , mgmt$target_properties WHERE ( mgmt$
Read more

ORA-65139: Mismatch between XML metadata file and data file

Error: CDB$ROOT@EBTUPRDC> CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse; CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse * ERROR at line 1: ORA-65139: Mismatch between XML metadata file and data file /u05/odb/ORADATA_1/EBTUSPRDC/datafile/system.1531.807800993 for value of fcpsb (2230502002 in the plug XML file, 2230505492 in the data file) Fix: Don't open Non-CDB database until we complete pdb creation other wise we will get above error. Shutdown immediate; startup mount; alter database open read only; create xml file. shutdown immediate; Connect to CDB and Create Pluggable database .
Read more

WARNING: Subscription for node down event still pending' in Listener Log

Image
These messages are related to the Oracle TNS Listener's default subscription to the Oracle Notification Service (ONS). In a non-RAC environment it is recommended to disable this subscription.   This feature was introduced in Oracle 10g. SOLUTION Set the following parameter in the listener.ora: SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF Where <listener_name> should be replaced with the actual listener name configured in the LISTENER.ORA file. SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name> parameter is to be placed by itself on an empty line. It will be necessary to restart or reload the listener following the addition of this parameter. This will prevent the messages from being written to the log file and may also prevent the TNS Listener from hanging periodically.  See (10g only) NOTE 340091.1 Intermittent TNS Listener Hang, New Child Listener Process Forked Please Note: Setting SUBSCRIBE_FOR_NODE_DOWN_<listener_n
Read more