Unable to initialize state monitor. Not able to create new database connection

Unable to initialize state monitor.

oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDSECURITY_APPL_SERVER_ID

In my case FND_NODES table and dbc file both have different SERVER_ID. Once I have updated the dbc file as FND_NODES , issue got resolved.

The APPL_SERVER_ID in the dbc file should match the server_id in FND_NODES table.

cd $FND_SECURE

first of all backup the existing one and modify the correct server id.


Just go under $APPLCSF/log


Check the FNDOPP2330321.txt . Following error will appear as below


Unable to initialize state monitor.
oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FNDCURITY_APPL_SERVER_ID
        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(ExtendedProfileStore.java:211)
        at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:171)
        at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:148)
        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:593)
        at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:570)
        at oracle.apps.fnd.common.AppsContext.initializeContext(AppsContext.java:524)
        at oracle.apps.fnd.common.AppsContext.<init>(AppsContext.java:292)
        at oracle.apps.fnd.cp.util.CPAppsDatabaseContext.<init>(CPAppsDatabaseContext.java:64)
        at oracle.apps.fnd.cp.util.CPContextFactory.makeContext(CPContextFactory.java:56)
        at oracle.apps.fnd.cp.gsf.GSMStateMonitor.init(GSMStateMonitor.java:70)
        at oracle.apps.fnd.cp.gsf.GSMStateMonitor.<init>(GSMStateMonitor.java:62)
        at oracle.apps.fnd.cp.gsf.GSMServiceController.init(GSMServiceController.java:111)
        at oracle.apps.fnd.cp.gsf.GSMServiceController.<init>(GSMServiceController.java:66)
        at oracle.apps.fnd.cp.gsf.GSMServiceController.main(GSMServiceController.java:428)
Caused by: oracle.apps.fnd.common.PoolException: Not able to create new database connection: FND
        at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:255)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at oracle.apps.fnd.common.Pool.createObject(Pool.java:1273)
        at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:1027)


Now I was able to see the login page as well...


After that file FNDOPP* file will display the logs as below, once we will stop the all application services and start it again.


FNDOPP2330399.txt:-


Starting GSF service with concurrent process id = 2330399.
Initialization Parameters: oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=10
[Thread-19] Service thread starting up.