Oracle recommends that the password for the APEX administrator be changed on new installations, or on migrations from runtime to developers mode. They state that in an upgrade scenario the existing password is preserved. That being said, there are times you need to change the password outside of these situations, and the process is fairly simple.
UPDATE: We now have a video walkthrough of this process below. The full text walkthrough and screenshots are below it.[youtube]http://www.youtube.com/watch?v=knXRhQ0zbcE[/youtube]
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:
- Change to the working directory into which the APEX system was extracted to when it was installed. In our screenshot the apex files were extracted to d:\apex
- Start the SQL/PLUS and connect to the database that APEX is installed against as SYS with the SYSDBA role.
- run the apxxepwd.sql or apxchpwd.sql script. This varies depending on version. Below are screenshots for versions 3.0.1 and version 3.2
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.