Resetting Oracle APEX Admin Password - Video Walkthrough Tutorial

By M&S Consulting (Kevin) on May 20th, 2009
Filed Under Technical Tips // Tags: ,

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 Preview Image

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 screenshot the apex files were extracted to d:\apex
    Working Directory Screenshot

    Working Directory Screenshot

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

    Screenshot for SQL PLUS login

    Screenshot for SQL PLUS login

  3. 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

     

    Screenshot for APEX version 3.0.1

    Screenshot for APEX version 3.0.1

    Screenshot for APEX version 3.2

    Screenshot for APEX 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.

Bookmark and Share

Related Information:

  1. Install Oracle Apex 3.2 on XE and XP Pro - Video Walkthrough Tutorial This tutorial is a supplment to the install video linked to below. It takes you through the process of installing...
  2. APEX 3.2 Tutorial Preparation and OEHR Sample Data - Video Walkthrough This tutorial video and article is meant to help you setup your APEX installation so you can proceed through the...
  3. Oracle APEX Main Components One of the main functions of APEX is to be able to easily build applications and perform basic database administration...
  4. Oracle APEX Advanced Tutorial 1 - Creating a Tabular Form - Video Walkthrough This tutorial is designed to walk you through section 2 of the Oracle APEX Advanced Tutorial, Creating a Tabular Form....
  5. Oracle APEX Tutorial 10 - Access Control - Part 2 - Video Training Security. We hear about it everywhere. Make this more secure, make this less secure. In the computer industry this is...
  6. Oracle XE 10g Windows Install - Video Walkthrough Tutorial This tutorial article is meant to provide a visual guide to the process of installing Oracle express edition (XE) onto...
  7. Oracle APEX Tutorial 10 - Access Control - Part 1 - Video Training Security. We hear about it everywhere. Make this more secure, make this less secure. In the computer industry this is...
  8. Oracle APEX Tutorial 3 - Drilldown Report Part 1- Video Training This tutorial covers section 4 of the Oracle APEX Advanced Tutorials, Creating a drilldown report...

3 Responses to “Resetting Oracle APEX Admin Password - Video Walkthrough Tutorial”

  1. Srini
    Jun 14, 2009
    Reply

    Nice set of tutorials….wonderful, thanks


    • ashok.aggarwal
      Jun 15, 2009
      Reply

      Thanks, Srini. I’m glad to hear you are gaining value from them.


  2. Iman
    Jun 22, 2009
    Reply

    Thanks for this tutorials, great job.



Leave a Reply


Archives

Recent Comments

  • SaintClair said: Thanks a million for this priceless material. May God richly bless you!
  • ashok.aggarwal said: Thank you for your comment, Stuart. I’m glad this helped you.
  • Stuart said: I’d really like to thank you for your post. It was really that simple.
  • ashok.aggarwal said: Your specific question is not very clear, however, in the context of implementing a LIKE...
  • Jonas said: Finally in print that a user is required to show the email option. Thanks.

Calendar

March 2010
M T W T F S S
« Feb    
1234567
891011121314
15161718192021
22232425262728
293031  

Featured Testimonial

"M&S has taken 'partnership' to a new level. They are not only a deeply skilled service provider, the M&S team is actually a mission critical component to our operations, taking on new initiatives as well as maintaining custom, open source, and COTS solutions."

CEO, MedPivot

Free SQL Service