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 🙂