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 laterOracle 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 |