My Oracle Support Banner

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

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