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 SEPTEMBER 04, 2015

Applies to:

Oracle Workflow - Version 12.2.4 to 12.2.4 [Release 12.2]
Oracle Concurrent Processing - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

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