Unable to Access Apex due to APEX_PUBLIC_USER password expiry

In 11g database the password for the APEX_PUBLIC_USER expires after 180 days.

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

  • July 22, 2013 | 57 views
  • Comments