I had an installation of database 21c and Oracle Apex 24.2 and Tomcat , today it is showing an below error when trying to get session by entering localhost:8090/ords
SELECT username, account_status FROM dba_users where account_status like 'LOCK%' order by username;
1* SELECT username, account_status FROM dba_users where username like '%ORDS%'
SYS@orclpdb> /
USERNAME ACCOUNT_STATUS
------------------------- ------------------
ORDS_PUBLIC_USER EXPIRED <<<---
ORDS_METADATA OPEN
2 rows selected.
SYS@orclpdb> ALTER PROFILE "DEFAULT" LIMIT PASSWORD_VERIFY_FUNCTION NULL;
Profile altered.
SYS@orclpdb> alter user ORDS_PUBLIC_USER identified by oracle account unlock;
User altered.
and now on connect error has been changed:
please help how it can be resolved?
I didn't changed it's password when first installed Oracle Apex.
with kind regards