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

Last updated on JANUARY 04, 2010

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

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