APEXblog.nl - Tips and Tricks

About This Blog:
I (Richard Weug) started this blog primary for myself to save all kinds of Apex tips and tricks in one place. To use it as a place to write down how I used some coding in my own projects, but also to copy and paste all kinds of articles I find on the Internet. (So I never have to wonder on what website did I read about??? When I see something interesting I collect the content so I have my own archive/knowlegde base.

View my profile on LinkedIn


Installation & Configuration


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

Not available at this time