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 :)
######
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.
INFO: Found persistence provider "org.eclipse.persistence.jpa.
[EL Severe]: 2014-10-14 09:42:20.49--ServerSession(
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.
WARNING: Could not create credential store instance. Reason oracle.security.jps.service.
JPS-01055: Could not create credential store instance. Reason oracle.security.jps.service.
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_
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 :)