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 Video Training Tutorials - Complete List
    A few kind readers asked, so we have delivered. Below is a consolidated list of all of the APEX training...

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

  • Kavitha Muniraj said: Hi, Could you please send a script which checks the status of forms and reports of oracle...
  • Siddharth said: Hey thanks a lot !! Have been lookin all over for this :) My PC may not be able t handle FlashBuilder...
  • Cyrex said: Hey man why I cant install Apex 4? is there anyone can help me.,?
  • sharanabasava said: ALTER TABLE [my_table_name] RENAME COLUMN [current_column_name] TO [new_column_name]; Sir,I...
  • Huub Vankan said: Thanks for this easy solution. Indeed strange that is does not work in the (x86) folder….

Calendar

July 2010
M T W T F S S
« Jun    
 1234
567891011
12131415161718
19202122232425
262728293031  

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