Unable To Start Service Components and Workflow Services In Release 12.2.4 - ORA-28001: the password has expired

(Doc ID 2052312.1)

Last updated on JUNE 04, 2018

Applies to:

Oracle Concurrent Processing - Version 12.2.4 to 12.2.4 [Release 12.2]
Oracle Workflow - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
Checked for relevance on June 4th, 2018

Symptoms

Using the Oracle Application Release 12.2.4,
unable to start the Workflow Services due the following error:

ORA-28001: the password has expired


The following was in the Workflow Mailer log file:

Could not start Service Component Container because an unexpected RuntimeException or other Throwable occurred -> oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1509)
at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:362)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(Unknown Source)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(Unknown Source)
at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(Unknown Source)
at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1294)
at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:1149)
at oracle.apps.fnd.common.logging.DebugEventManager.internalReinit(DebugEventManager.java:1118)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1085)
at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:1072)
at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:595)
at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:611)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:588)
at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:542)
at oracle.apps.fnd.common.AppsContext.(AppsContext.java:304)
at oracle.apps.fnd.wf.apps.WorkflowContext.(WorkflowContext.java:31)
at oracle.apps.fnd.wf.apps.ContextFactory.makeContext(Unknown Source)
at oracle.apps.fnd.wf.common.WorkflowContext.(WorkflowContext.java:98)
at oracle.apps.fnd.cp.gsc.SvcComponentContainer.getNewWorkflowContext(SvcComponentContainer.java:1325)
at oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.initializeStateMachine(GSMSvcComponentContainer.java:207)
at oracle.apps.fnd.cp.gsc.SvcComponentContainer.start(SvcComponentContainer.java:782)
at oracle.apps.fnd.cp.gsm.GSMSvcComponentContainer.main(GSMSvcComponentContainer.java:424)
Caused by: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1289)
at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1028)
at oracle.apps.fnd.security.DBConnObjPool.borrowObjectX(DBConnObjPool.java:650)
at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:597)
at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:354)
at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1758)
at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2425)
at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2362)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2218)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2028)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1816)
at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1829)
at oracle.apps.fnd.common.Context.getJDBCConnection(Context.java:1492)
at oracle.apps.fnd.cache.GenericCacheLoader.load(GenericCacheLoader.java:170)
at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:1500)
... 21 more
Caused by: java.lang.RuntimeException: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28001: the password has expired

at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:864)
at oracle.apps.fnd.security.DBConnObj.getLabelledConnection(DBConnObj.java:321)
at oracle.apps.fnd.security.DBConnObj.(DBConnObj.java:233)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1276)
... 35 more
Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28001: the password has expired

at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:992)
at oracle.apps.fnd.security.AppsConnectionManager.getGwyuidConn(AppsConnectionManager.java:1071)
at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:844)
... 42 more
Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-28001: the password has expired

Changes

Since the problem occurred, changed some passwords in the environment using the FNDCPASS:

Changed the profiles after noticing apps was locked.  Service components were not coming up prior to changing the profiles.
SQL> SELECT * FROM dba_profiles WHERE profile = 'DEFAULT' AND resource_type = 'PASSWORD';

PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
DEFAULT PASSWORD_LOCK_TIME PASSWORD 1
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7

7 rows selected.

Elapsed: 00:00:00.84
SQL> select profile from dba_users where username='APPS';

PROFILE
------------------------------
APP_OWNER_PROFILE

Elapsed: 00:00:00.02
SQL> SELECT * FROM dba_profiles WHERE profile = 'APP_OWNER_PROFILE' AND resource_type = 'PASSWORD';

PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
APP_OWNER_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD DEFAULT
APP_OWNER_PROFILE PASSWORD_LIFE_TIME PASSWORD UNLIMITED
APP_OWNER_PROFILE PASSWORD_REUSE_TIME PASSWORD DEFAULT
APP_OWNER_PROFILE PASSWORD_REUSE_MAX PASSWORD DEFAULT
APP_OWNER_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD DEFAULT
APP_OWNER_PROFILE PASSWORD_LOCK_TIME PASSWORD DEFAULT
APP_OWNER_PROFILE PASSWORD_GRACE_TIME PASSWORD DEFAULT
issue clarification

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms