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 :)
Posted by at
Labels: ,

11 comments:

  1. James kristenJanuary 21, 2015 at 6:46 AM

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

    ReplyDelete
  2. AbhinayFebruary 26, 2015 at 1:54 AM

    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. chinniravitejaFebruary 26, 2015 at 10:32 AM

    Did you try running Security Store configuration ?

    ReplyDelete
  4. chinniravitejaJune 9, 2015 at 10:29 AM

    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. NeeluJune 10, 2015 at 4:35 AM

    Thanks a lot :) It worked :)

    ReplyDelete
  6. NeeluJune 11, 2015 at 1:33 AM

    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. chinniravitejaJune 11, 2015 at 11:53 AM

    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. NeeluJune 12, 2015 at 7:32 AM

    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. chinniravitejaJune 12, 2015 at 10:25 PM

    Neelu,


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


    Thanks

    ReplyDelete
  10. NeeluJune 15, 2015 at 1:06 AM

    Hello chinniraviteja,


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



    Regards
    Neelu

    ReplyDelete
  11. chinniravitejaJune 15, 2015 at 8:26 AM

    Nellu,


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


    Thanks

    ReplyDelete

Subscribe to: Post Comments (Atom)

Other Posts