ORA-47323 Database Vault Rule Visible In OEM But Cannot Delete It. (Doc ID 1549491.1)

Last updated on MAY 10, 2013

Applies to:

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

Symptoms

A Database Vault Rule is visible in OEM but it cannot be deleted.  Using SQLPlus and SQLDev to delete the rule displays the same failure:

begin
   DVSYS.DBMS_MACADM.DELETE_RULE('Aspen_RO');                                                                                  
end;

OEM error report:
ORA-47323: error deleting Rule Aspen_RO, ORA-24147: rule DV$5050. does not exist
ORA-06512: at "DVSYS.DBMS_MACUTL", line 38
ORA-06512: at "DVSYS.DBMS_MACUTL", line 388
ORA-06512: at "DVSYS.DBMS_MACADM", line 2427
ORA-24147: rule DV$5050. does not exist
ORA-06512: at line 2


Attempting to recreate the rule also failed with:

begin
   DVSYS.DBMS_MACADM.CREATE_RULE(
   rule_name => 'Aspen_RO',
   rule_expr => '1=0');
end;
/

Error report:
ORA-47322: error creating Rule Aspen_RO, ORA-47320: Rule Aspen_RO already defined
ORA-06512: at "DVSYS.DBMS_MACUTL", line 38
ORA-06512: at "DVSYS.DBMS_MACUTL", line 388
ORA-06512: at "DVSYS.DBMS_MACADM", line 2334
ORA-47320: Rule Aspen_RO already defined
ORA-06512: at line 2

 
 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms