DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Monday, July 22, 2013

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

No comments: