Reset INTERNAL password in APEX 3.0

Well, it can happen… You use so many different passwords that you forget one of them.
If you forget your APEX password of the INTERNAL workspace, here’s what you can do:

1. Connect to your database AS SYS DBA (or a user with high privileges): sqlplus sys as sysdba

2. SQL> alter user FLOWS_030000 account unlock;

3. Connect to your database as FLOWS_030000: sqlplus flows_030000/password@your_db

4. Run following procedure from SQL>
   begin www.flow_api.set_security_group_id (p_security_group_id => 10); www.flow_fnd_user_api.create_fnd_user( p_user_name => 'admin1', p_email_address => 'email@ae.com', p_web_password => 'admin1'); end; / commit;

5. Connect again AS SYS DBA

6. SQL> alter user FLOWS_030000 account lock;

That should have fixed your problem. Try again to login into APEX.