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

/u01/oracle/product/11.2/apex

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 11.2.0.1.0 Production on Thu Jun 24 17:20:56 2010

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

SQL> conn sys as sysdba

Enter password:

Connected.

SQL>

SQL>

SQL> show user

USER is “SYS”

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

http://devu0777.hiroshima.com:8080/apex/

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

Leave a comment