Archive

Archive for August, 2013

How To unlock APEX admin without changing the password

August 3rd, 2013 Matthias Pölzinger 1 comment

 
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>
    
Categories: Uncategorized Tags: