My Oracle Support Banner

Ora-06512: At "Dvsys.Authorize_event", Line 55 when Database Vault was Disabled (Doc ID 557996.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version: 9.2.0.8 to 11.1.0.6
Information in this document applies to any platform.

Symptoms

You are getting the following errors (or very similar) on all DDL even if you disabled Database Vault

ORA-00604: error occurred at recursive SQL level 1
ORA-04045: errors during recompilation/revalidation of DVSYS.DBMS_MACUTL
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "DVSYS.AUTHORIZE_EVENT", line 55
ORA-06512: at line 13
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "DVSYS.AUTHORIZE_EVENT", line 55
ORA-06512: at line 13

Changes

This error can potentially be the result of many actions but are mainly due to not following documented procedures to properly disable Database Vault when applying patches or doing other maintenance operations.

Comment: If this error happens while Database Vault is Enabled it has another cause and it may be due to a problem in the Database Vault (triggers) themselves and in that case typically happens with one particular type of DDL statement, while this case deals with a Disabled Database Vault and errors on ALL DDL comands.

Cause

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
  Symptoms
  Changes
  Cause
  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.