Internal Exception: java.sql.SQLException: ORA-28001: the password has expired

JPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-00027: There was an internal error: java.sql.SQLException: ORA-28001: the password has expired

 

The issue is due to expiration of DB Schema passwords.

 

Solution:

  1. Figure out expired passwords.
    1. sqlplus ‘/as sysdba’SQL> select USERNAME, ACCOUNT_STATUS,EXPIRY_DATE from dba_users;
  2. Change all expired schema passwords one by one using below command.

    Sample: alter user <> identified by <Password>;

    E.g.:

    SQL> alter user DEV_IAU identified by Oracle123;

    User altered.

  3. Set passwords not to expire (Not a recommended approach for Production, only POC)

    SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

 

July 12, 2017

0 responses on "Internal Exception: java.sql.SQLException: ORA-28001: the password has expired"

Leave a Message