Unable To Install APEX Because of DB Vault Violation - ORA-47426: The object or its parent object belongs to a Database Vault policy. (Doc ID 2584457.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Symptoms

1. New Attempt to install APEX 18.2 into a 12.2.0.1 DB where DB Vault is enabled

2. Installation log shows:

a. # Creating APEX_GRANTS_FOR_NEW_USERS_ROLE
#
declare
*
ERROR at line 1:
ORA-47426: The object or its parent object belongs to a Database Vault policy.
ORA-06512: at line 9
ORA-06512: at line 27

b. Later on see this error:

grant select on WWV_FLOW_PRIVATE_TO_ADMIN to APEX_ADMINISTRATOR_ROLE
  *
ERROR at line 1:
ORA-01917: user or role 'APEX_ADMINISTRATOR_ROLE' does not exist

c. . Later on this error near the end:

exit sql.sqlcode rollback
Errors found. Drop APEX_180200 before re-starting the installation.
#
# Actions in Phase 1:
#
  ok 1 - BEGIN | 0.00
  ok 2 - Creating FLOWS_FILES | 0.00
  ok 3 - Creating APEX_PUBLIC_USER | 0.00
  not ok 4 - Creating APEX_GRANTS_FOR_NEW_USERS_ROLE | 0.00
  # Message: ORA-47426: The object or its parent object belongs to a Database Vault policy. ORA-06512: at line 9
  # ORA-06512: at line 27

Changes

 None

Cause

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