i am trying to login as the apex instance admin user but i keep getting invalid credentials even after change the password many times.
SQL> select version_no from apex_release;
VERSION_NO
--------------------------------------------------------------------------------
19.1.0.00.15
SQL> select username from dba_users where username like 'APEX%';
USERNAME
------------------------------
APEX_190100
APEX_REST_PUBLIC_USER
APEX_PUBLIC_USER
APEX_LISTENER
APEX_INSTANCE_ADMIN_USER
I have checked and confirmed that i am using the correct apxchpwd.sql.
SQL> select user_name, account_locked, change_password_on_first_use, account_expiry, first_password_use_occurred,last_failed_login
from wwv_flow_fnd_user; 2
USER_NAME A C ACCOUNT_E F LAST_FAIL
-------------------- - - --------- - ---------
APEXADMIN N N 25-JAN-23 N
ADMIN N Y 30-APR-20 Y
PROBEADMIN Y 22-OCT-19 N
PROBEADMIN Y 22-OCT-19 N
C12378 N N 22-OCT-19 N
The admin account is APEXADMIN. I also created another one called ADMIN. Both not working; I am getting invalid credentials.
What is wrong with the account?
thanks.