How To Unlock The APEX Instance Administrator (ADMIN) Account
(Doc ID 2064246.1)
Last updated on JULY 14, 2022
Applies to:Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Application Express (APEX) - Version 3.2.0 and later
Information in this document applies to any platform.
*** Check for relevance on Mar-11-2016 ***
APEX has a feature, whereby if configured, an account can be locked after several failed attempts of logins. This is all fine if the account is either an 'End User', 'Developer' or 'Workspace Administrator' as the APEX Instance Administrator can login into the APEX Instance Admin page and manually unlock the account.
However, what happens if the Instance Administrator account is actually locked and thus the Instance Administrator cannot log into the APEX Instance to unlock themselves. So, how do you unlock and APEX Instance Administrator account?
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
|Before you apply any of the follow solutions make sure you are connected to the right database.|
|Option 1: Use apxchpwd.sql|
|Option 2: Use the apxchpwd.sql to Create a New Admin User|
Option 3: Use the SQL Plus and the APEX_UTIL API