First check if the details of the profile assigned to the APEX_PUBLIC_USER
select username,account_status,profile from dba_users where username=’APEX_PUBLIC_USER’
USERNAME ACCOUNT_STATUS PROFILE
—————————— ——————————– ——————————
APEX_PUBLIC_USER LOCKED DEFAULT
Now check the details of the Profile “DEFAULT” using the below query
SQL> select profile,resource_name,limit from dba_profiles where profile=’DEFAULT’ and
RESOURCE_NAME=’PASSWORD_LIFE_TIME’;
PROFILE RESOURCE_NAME LIMIT
—————————— ——————————– —————————————-
DEFAULT PASSWORD_LIFE_TIME 180
The password_life_time for the profile “DEFAULT” had reached. This was the profile assigned to the APEX_PUBLIC_USER.
So we changed the password_life_time to “unlimited” for the profile “DEFAULT” by using the below command.
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
SQL> select profile,resource_name,limit from dba_profiles where profile=’DEFAULT’ and
RESOURCE_NAME=’PASSWORD_LIFE_TIME’;
PROFILE RESOURCE_NAME LIMIT
—————————— ——————————– —————————————-
DEFAULT PASSWORD_LIFE_TIME UNLIMITED
After the “DEFAULT” profile Limit change to UNLIMITED, we were able to access APEX without any issue
