How To Unlock The APEX Instance Administrator (ADMIN) Account
(Doc ID 2064246.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Application Express (formerly HTML DB) - Version 3.2.0 to 5.0.3.00.03
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 SQL Plus and the APEX_UTIL API|