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:
- Figure out expired passwords.
- sqlplus ‘/as sysdba’SQL> select USERNAME, ACCOUNT_STATUS,EXPIRY_DATE from dba_users;
- 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.
- Set passwords not to expire (Not a recommended approach for Production, only POC)
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
0 responses on "Internal Exception: java.sql.SQLException: ORA-28001: the password has expired"