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.

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

 
%d bloggers like this: