Forgot the admin password for Apex hosted on your VM?

Problem

I'm not sure whether this is just for hosted apex environments, or whether all environments have this script...but there is a script to get you out of trouble, I did not need to restart anything after running the SQL script.

Solution

On UNIX and Linux:

$ sqlplus /nolog
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password

3) Run apxchpwd.sql. For example:

@apxchpwd

4) When prompted enter a password for the ADMIN account.

Acknowledgements

https://community.oracle.com/thread/2332882

Comments