Complete guide to change or reset internal admin password of oracle apex

There is an authentication mechanism of Oracle Apex for confirming security of its content. For securing, Oracle Apex has one main workspace named INTERNAL with username ADMIN and it's password.

If you forget the password of ADMIN's username for INTERNAL workspace, then you are in a big trouble.

Don't worry! here are two ways to change or reset internal admin password:

1. By executing apxchpwd.sql script.
2. By executing some manual script

Follow these steps to execute apxchpwd.sql script.

1. Open command prompt (cmd) or terminal.

2. Go to your apex (cd e:\oraclexe\apex) directory.

3. Login to database as sysdba.

4. Type @apxchpwd.sql and press enter. Then follow the steps that comes.

Follow these steps to execute some manual script.

1. Open command prompt (cmd) or terminal.

2. Login to database as sysdba.

3. Change schema to your apex schema. Script to help you,

ALTER SESSION SET CURRENT_SCHEMA = APEX_190200;

NB: Here, "APEX_190200" is your apex schema.

4. Then run this query to get userid of admin username.

SELECT RTRIM (MIN (user_id)) user_id
  FROM wwv_flow_fnd_user
 WHERE security_group_id = 10 AND user_name = UPPER ('ADMIN');

5. To change or reset password of ADMIN username,

UPDATE wwv_flow_fnd_user
   SET web_password = 'Apexpassword1#'
 WHERE user_name = 'ADMIN' AND user_id = '1820122815444026';

NB: Here, "1820122815444026" is the userid that you get from previous query.

6. To unlock the ADMIN username execute the script below.

BEGIN
   WWV_FLOW_SECURITY.g_security_group_id := 10;
   WWV_FLOW_FND_USER_API.unlock_account ('ADMIN');
   COMMIT;
END;

If you use Toad or SQL Developer then you can start from step 4 by direct login your apex schema. 

Tested on 5.0, 5.1, 18.1, 18.2, 19.1 and 19.2 version of Oracle Apex.

Think it helps you. Good Luck.