Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

Change Admin password in Apex

Posted by Hendry chinnapparaj on June 24, 2010

apex11g:/u01/oracle/product/11.2/apex> pwd


apex11g:/u01/oracle/product/11.2/apex> ls -lrt apxchpwd.sql

-rw-r–r–    1 ofsad2   dba            1549 Jan  8 2009  apxchpwd.sql

apex11g:/u01/oracle/product/11.2/apex> sqlplus /nolog

SQL*Plus: Release Production on Thu Jun 24 17:20:56 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn sys as sysdba

Enter password:




SQL> show user


SQL> @apxchpwd

Enter a value below for the password for the Application Express ADMIN user.

Enter a password for the ADMIN user              []

Session altered.

…changing password for ADMIN

PL/SQL procedure successfully completed.

Commit complete.

Then login to


and change the password for “admin” user as requested by the application.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: