Knowledge Base

 
Problem description:

You have locked your APEX administrator account by mistyping the account’s password too often. As other persons are also using the account, you don’t want to use the “apxchpwd”-script.

 
Problem resolution:

If you just want to unlock the account instead of completely resetting the password, you can use the following PL/SQL block to establish this task:

begin
    wwv_flow_security.g_security_group_id := <APEX_WORKSPACE_ID>;
    wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('<APEX_ACCOUNT_NAME>');
    commit;
end;
/

 
Example:

1. Query the id for the “INTERNAL” workspace:
   

   SQL> SELECT workspace_id FROM apex_workspaces WHERE workspace = 'INTERNAL';
   
   WORKSPACE_ID
   ------------
             10
   
   SQL>
   

    

2. Query the APEX schema’s name for your version:
   

   SQL> select username from dba_users where username like 'APEX%' order by 1;
   
   USERNAME
   ------------------------------
   APEX
   APEX_040200
   APEX_PUBLIC_USER
   
   SQL>
   

    

3. Switch your session to the APEX-schema:
   

   SQL> alter session set current_schema = APEX_040200;                      
   
   Session altered.
   
   SQL>
   

    

4. Unlock your ADMIN account with the following code:
   

   SQL> begin
     2    wwv_flow_security.g_security_group_id := 10;
     3    wwv_flow_fnd_user_api.UNLOCK_ACCOUNT('ADMIN');
     4    commit;
     5  end;
     6  /
   
   PL/SQL procedure successfully completed.
   
   SQL>