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 :)

11 comments:

  1. Realy would like to say thanks to all of you guys. Shairing Knowledgeble information here.
    Error
    code 30088-27

    ReplyDelete
  2. I have changed the Password and tried to restart. it gives me the below error
    Error Code: 1017
    Feb 20, 2015 10:46:27 PM 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!

    ReplyDelete
  3. Did you try running Security Store configuration ?

    ReplyDelete
  4. Neelu,


    Domain would have already stored your old password so either you need to update your DB schema passwords to old password or you should change schema passwords in Weblogic Doamin.


    I would suggest to change DB schema passwords to old passwords which you have used earlier and restart the servers.


    Thanks

    ReplyDelete
  5. Thanks a lot :) It worked :)

    ReplyDelete
  6. I have one more question, Is there any way to make the password not expire after 180 days. I mean can i make the password stay for longerrr.

    ReplyDelete
  7. Neelu,

    Can you run same query and share the results?

    select USERNAME,EXPIRY_DATE,LOCK_DATE,ACCOUNT_STATUS from dba_users where username like '%DEV%';

    ReplyDelete
  8. Hello chinniraviteja

    The results u asked for

    ======================

    SQL> select USERNAME,EXPIRY_DATE,LOCK_DATE,ACCOUNT_STATUS from dba_users where username like '%DEV%';

    USERNAME EXPIRY_DA LOCK_DATE
    ------------------------------ --------- ---------
    ACCOUNT_STATUS
    --------------------------------
    DEV_IAU 10-MAR-15
    OPEN

    DEV_IAU_VIEWER 10-MAR-15
    OPEN

    DEV_IAU_APPEND 10-MAR-15
    OPEN

    USERNAME EXPIRY_DA LOCK_DATE
    ------------------------------ --------- ---------
    ACCOUNT_STATUS
    --------------------------------
    DEV_MDS 10-MAR-15
    OPEN

    DEV_OAM 07-DEC-15
    OPEN

    DEV_OPSS 07-DEC-15
    OPEN

    6 rows selected.

    ReplyDelete
  9. Neelu,


    Your Schema accounts looks good, they won't expire any more.


    Thanks

    ReplyDelete
  10. Hello chinniraviteja,


    After 180 days also it wont expire ? Or is it only the first time ,it would expire?



    Regards
    Neelu

    ReplyDelete
  11. Nellu,


    Its only for this first time. You shouldn't see that error again.


    Thanks

    ReplyDelete

Other Posts