Installation & Configuration

Print
21
Feb

Reset the Apex administrator password

Written by Richard Weug. Posted in Installation

In this article you will see how easy it is to change the administrator password for Apex.

You will need to be able to logon as SYS with SYSDBA rights in order to do this.

For all installations perform the following first:

1:  Change to the working directory into which the APEX system was extracted to when it was installed. In our (linux) environment the apex files were extracted to /opt/apex

2: Start the SQL/PLUS and connect to the database that APEX is installed against as SYS with the SYSDBA role.

user@server: /opt/apex$     sqlplus sys as sysdba

3: run the apxxepwd.sql or apxchpwd.sql script. This varies depending on version.

For 3.0.1 you use apxxepwd.sql, for 3.2 and higher you can use the apxchpwd.sql script.

SQL> @@apxchpwd.sql

This will prompt you for a new ADMIN account password.

After this, the ADMIN account password will be changed. The first time the ADMIN logs on after this, they will be required to reset the password.

Original article from:  http://www.mandsconsulting.com/resetting-oracle-apex-admin-password-video-walkthrough-tutorial