If APEX ADMIN account has locked for INTERNAL workspace or need to change the password, use the following procedure, please test it first and do the necessary backups first.
INTERNAL Admin password change
==============================
login with sys as sysdba to the APEX database
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 APEXUAT READ WRITE NO
SQL> alter session set container=APEXUAT;
Session altered.
SQL>
SQL>
SQL> @apxchpwd.sql
...set_appun.sql
================================================================================
This script can be used to change the password of an Oracle APEX
instance administrator. If the user does not yet exist, a user record will be
created.
================================================================================
Enter the administrator's username [ADMIN]
User "ADMIN" exists.
Enter ADMIN's email [apexadmin@testlab.com]
Enter ADMIN's password []
Changed password of instance administrator ADMIN.
- test the login with ADMIN account for INTERNAL workspace
