How to set apex public account's password limit life time.

------------------Check User Status---------------------------------

select * from apex_release;

select username

     , account_status

  from dba_users

 where username in (

       'ANONYMOUS'

     , 'APEX_210200'

     , 'APEX_LISTENER'

     , 'APEX_PUBLIC_USER'

     , 'APEX_REST_PUBLIC_USER'

     , 'APEX_INSTANCE_ADMIN_USER'

     , 'ORDS_PUBLIC_USER'

     , 'ORDS_METADATA'

     , 'PDBADMIN'

     , 'SYS'

     , 'XDB'

 )

 order by username;

NOTE:

Be sure that the new passwords for APEX accounts are the same passwords you set at the time of installing ORDS, otherwise, you will get an error.

------------------------Reason for being apex password expired/account locked----------------------

what is a profile?

A profile is a set of limits on database resources and password access to the database. If no profile is specified, then the user is assigned a default profile.

Why Apex password expired errors were raised?

Apex password expired errors were raised because of the Password management-related profile. 

Since APEX public accounts assigned to DEFAULT profile and the PASSWORD_LIFE_TIME Parameter for DEFAULT Profile is: 

180 days means APEX accounts reached the limit and Passwords expired/ account locked.But after 180 days the problem will raise again. 

So, to make sure this will not happen again, create a new profile with unlimited PASSWORD_LIFE_TIME and assign APEX accounts to the new profile:

---------------Create a new Profile-------------------

create profile my_profile

limit password_life_time unlimited;

  

alter user apex_public_user profile  my_profile;

alter user apex_rest_public_user profile my_profile;

alter user apex_listener profile my_profile;

alter user ords_public_user profile my_profile;