Unlock Oracle APEX Admin Account

There are some cases where user forget the password of admin account of Oracle Application Express Account.

Step1: Go to Command Prompt

Step2: Connect to Sysdba account of oracle database

Step3:  Execute following query

select username from dba_users where username like 'APEX%' order by 1;

 As i have APEX 19.1 installed it show the versions. 

Step4: Now you need to switch to APEX_SCHEMA which required resetting of password

SQL> alter session set current_Schema = APEX_190100

Step5: Unlock your admin account with following code.

 begin
      wwv_flow_security.g_security_group_id := 10;
      wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('ADMIN');
     commit;
end;