My Oracle Support Banner

Installing APEX Gets ORA-47280: Realm Object ROLE APEX_GRANTS_FOR_NEW_USERS_ROLE already defined in Realm Oracle System Privilege and Role Management Realm (Doc ID 2789908.1)

Last updated on JULY 06, 2021

Applies to:

Oracle Application Express (APEX) - Version 18.2.0 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On : APEX 18.2.0+ version, Administration

When attempting to install it (new or upgrade)
the following error occurs.

ERROR
-----------------------
ORA-47280: Realm Object ROLE,.APEX_GRANTS_FOR_NEW_USERS_ROLE already defined in
Realm Oracle System Privilege and Role Management Realm
ORA-06512: at line 9
ORA-06512: at line 30


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Try to install the APEX
2. Get errors in screen and at the log

Changes

 

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


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