Sunday, December 11, 2011

Lost APEX ADMIN password?

You need to locate and run the file C:\oraclexe\app\oracle\product\11.2.0\server\apex\apxchpwd.sql

If you are running your database in Linux, find the apxchpwd.sql file by

$ locate apxchpwd.sql

Then go to that directory and run SQLPlus.

Follow these instructions to recover your ADMIN password. Note this is not for reseting your workspace ADMIN account password. Its for resetting the password for ADMIN account for your entire APEX installation.
  1. Open command prompt and cd to C:\oraclexe\app\oracle\product\11.2.0\server\apex
  2. Run sqlplus from command prompt.
  3. Run the command alter session set current_schema='apex_040000';
Run the command @apxchpwd.sql and enter your password.

You should now be able to log into http://localhost:8080/apex/apex_admin. APEX will ask you change  your password again after logging in.

1 comment:

  1. How to Retrieve Forgot Username and Password of Oracle? Contact to Remote DBA Services for Quick Access
    Well! If unfortunately you are not able to recover your forget username and password of Oracle database then no issue, with Cognegic’s Database Administration for Oracle or Online Oracle DB Support you can easily retrieve your password without confronting any issue. Our all technical experts know very-well how to recover your username and password of Oracle. With our Oracle Database Solution you can easily solve your problem.
    For More Info: https://cognegicsystems.com/
    Contact Number: 1-800-450-8670
    Email Address- info@cognegicsystems.com
    Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801

    ReplyDelete