Resetting Your APEX Password
If you are locked out of your APEX account, you will may to reset the admin user's password. Here is the process:
Change the Administrator's password in SQL*Plus
- Open Windows Explorer and navigate to C:\apex.
- Type cmd over the folder path:
Press Enter to launch the command line. - Log in to SQL*Plus:
sqlplus / as sysdba - Change the container to XEPDB1:
ALTER SESSION SET CONTAINER = XEPDB1; - Run @apxchpwd to change the password for the administrator. You will get three prompts:
- Enter the administrator's username [ADMIN]. Just press Enter to accept ADMIN as the username.
- Enter ADMIN's email [apex@example.com]. Just press Enter to accept apex@webucator.com as the email.
- Enter ADMIN's password []. Enter the password you want to use for the APEX administrator. It needs to be somewhat complex (e.g., Webuc8tor++). Then, press Enter.
The SQL*Plus session will look like this:
You can now close the command line tool and return to APEX in the browser to log in as the Administrator and change the password for the admin user.
- You will sign into the internal workspace as admin with the password you just set:
- Click Manage Workspaces:
- On the right, click the number above Workspace Users (3):
- Click ADMIN for the WEBUCATOR workspace. Make sure to click the right one!
- Change the password to admin in the Password and Confirm Password fields and then click Apply Changes:
- Sign out of the internal workspace:
You should then be able to sign back into your workspace as admin / admin: