Monday, October 27, 2014

Error Code: 28001 org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: ORA-28001: the password has expired

Error:
######

Initializing WebLogic Scripting Tool (WLST) ...

Welcome to WebLogic Server Administration Scripting Shell

Type help() for help on available commands

Info: Data source is: opss-DBDS
INFO: Found persistence provider "org.eclipse.persistence.jpa.PersistenceProvider". OpenJPA will not be used.
INFO: Found persistence provider "org.eclipse.persistence.jpa.PersistenceProvider". OpenJPA will not be used.
[EL Severe]: 2014-10-14 09:42:20.49--ServerSession(957605646)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.1.v20111018-r10243): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-28001: the password has expired

Error Code: 28001
Oct 14, 2014 9:42:20 AM oracle.security.jps.internal.credstore.ldap.LdapCredentialStore init
WARNING: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-10000: There was an internal error in the policy store.
JPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.policystore.PolicyStoreConnectivityException: JPS-10000: There was an internal error in the policy store.
Error: Diagnostics data was not saved to the credential store.
Error: Validate operation has failed.
Need to do the security configuration first!


Solution:
#########

Run the below queries

SELECT owner, comp_name, version, status, upgraded FROM schema_version_registry WHERE comp_name like '%Oracle%';esukl

Result:
#######

PROFILE                RESOURCE_NAME                                RESOURCE LIMIT
------------------------------ -------------------------------- ------------------------------------
DEFAULT                FAILED_LOGIN_ATTEMPTS              PASSWORD10
DEFAULT                PASSWORD_LIFE_TIME                     PASSWORDUNLIMITED
DEFAULT                PASSWORD_REUSE_TIME                 PASSWORDUNLIMITED
DEFAULT                PASSWORD_REUSE_MAX                  PASSWORDUNLIMITED
DEFAULT                PASSWORD_VERIFY_FUNCTION     PASSWORDNULL
DEFAULT                PASSWORD_LOCK_TIME                   PASSWORD1
DEFAULT                PASSWORD_GRACE_TIME                PASSWORDUNLIMITED
         
select USERNAME,EXPIRY_DATE,LOCK_DATE,ACCOUNT_STATUS from dba_users where username like '%DEV%';

Result:
#######

USERNAME               EXPIRY_DA LOCK_DATE    ACCOUNT_STATUS
------------------------------ --------- -----------------------------------------
DEV_SOAINFRA         OPEN
DEV_OIF                      OPEN
DEVBI_MDS                OPEN
DEV_IAU_APPEND    OPEN
DEV_ORASDPM         OPEN
DEV_IAU                     OPEN
DEVBI_BIPLATFORM    OPEN
DEV_IAU_VIEWER    OPEN
DEV_OAAM                OPEN
DEV_MDS                   OPEN
DEV_OAM                  OPEN
DEV_OPSS               09-OCT-14    EXPIRED

12 rows selected.

Per above result, it is evident that DEV_OPSS password has been expired. so we need to reset that

> alter user DEV_OPSS identified by Password123;

Restart everything :)

Other Posts