Unlock Apex admin account

You can find the lock accounts from the following query.

SELECT * FROM APEX_050000.WWV_FLOW_FND_USER A WHERE ACCOUNT_LOCKED = 'Y';

So, in order to unlock the admin user. Login with SYS and execute the following PL/SQL block.

BEGIN
   APEX_UTIL.SET_SECURITY_GROUP_ID(P_SECURITY_GROUP_ID => 10);
   APEX_UTIL.UNLOCK_ACCOUNT(P_USER_NAME => 'ADMIN');
   COMMIT;
END;

You can also update the admin password by specifying the appropriate parameters.

UPDATE APEX_050000.WWV_FLOW_FND_USER
SET    WEB_PASSWORD = 'NEWPASSWORD'
WHERE  USER_NAME = 'ADMIN'
AND    USER_ID = 1660989562102010;

COMMIT;

I hope this will help you 🙂

Caglar's Oracle Blog