Step by Step Guidance to Reset Internal Admin Password on Oracle APEX

This article will give you step by step guidance to reset INTERNAL ADMIN's password on Oracle APEX. Oracle Application Express (APEX) 5 has an authentication mechanism for securing its content by providing one main workspace with its username and password. Oracle Application Express (APEX) will be automatic installed along with Oracle Database Express Edition (XE). Main workspace on Oracle APEX is INTERNAL. It will require username and password to login. The username is ADMIN and the password is the words defined at installation process. Sometimes we might forget the ADMIN’s password of INTERNAL workspace, that is a big problem. Some of us will consider to reinstalling the Oracle APEX, but it’s not an easy things to be done because some of schema dependencies need to be considered. Another way if we forget the INTERNAL workspace password is reinstalling the Oracle Database Express itself, but we must do a data backup before doing this otherwise our important data will be lost.

Don’t worry this article will help recover your ADMIN’s password on INTERNAL workspace. In case we forget the password we can restore it by executing apxchpwd script located on specific Oracle APEX folder locations. Here are step by step tutorial how to reset ADMIN’s password of INTERNAL workspace:

1. Identify the location of apex directory (e.g. c:\oraclexe\apex).

2. Open command prompt (cmd).

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

4. Login to database as sysdba.

5. Execute "@apxchpwd.sql", you just need to hit an enter key until the question to enter ADMIN’s password.

6. Type new ADMIN’s password (contains 8 characters, at least 1 number and 1 special character) follows by hit an enter key. That’s it you already done to change the ADMIN’s password on INTERNAL workspace.

7. Now it’s time to check the results. From your web browser, open APEX login page (e.g. http://localhost:8080/apex/), login to INTERNAL workspace with ADMIN user and your new password follows by click the login button.

8. Follow the instruction to change the password again. You must do this step as the final steps for resetting the password.

Congratulations You're Done! That was eight steps for resetting INTERNAL ADMIN’s password.

Thank You - Bobsis

No comments

Powered by Blogger.