Search This Blog

Saturday, 9 July 2011

Oracle Application APEX admin user password reset by script

Introduction: If you dont know the password for admin user of Oracle Application APEX, and if version of APEX is 3 or higer then the password of admin can be reset by a script. CookBook: There is script in the directory of apex softwae and the script name is apxchpwd.sql, this can be run with sys user on sqlplus and it will ask the new password for admin, just type the new password and use it.

No comments:

manage long running sessions with "screen" on linux OS - handy utility for Oracle APPS DBA for cloning, patching etc

  n Oracle E-Business Suite (EBS), there is no standard   -S   flag for the primary cloning commands ( adpreclone.pl   or   adcfgclone.pl )....