Unable to Start the RA Service in Hyperion - Reset the password

To alter the password expiry policy for a certain user profile in Oracle first check wich profile the user is in using:

select profile from DBA_USERS where username = 'EPMSS';

Then you can change the limit to never expire using:

alter profile DEFAULT limit password_life_time UNLIMITED;

If you want to previously check the limit you may use:

   
select username,expiry_date,account_status from dba_users;
   
alter user EPMSS account unlock;


For development you can disable password policy if no other profile was set (i.e. disable password expiration in default one):

ALTER PROFILE "DEFAULT" LIMIT PASSWORD_VERIFY_FUNCTION NULL;

Then, reset password and unlock user account. It should never expire again:

alter user EPMSS identified by EPMSS account unlock;