My Oracle Support Banner

How To Unlock The APEX Instance Administrator (ADMIN) Account (Doc ID 2064246.1)

Last updated on AUGUST 01, 2019

Applies to:

Oracle Application Express (APEX) - Version 3.2.0 to 5.0.3.00.03
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
*** Check for relevance on Mar-11-2016 ***

Goal

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?
 

Solution

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
Goal
Solution
 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
 
References


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