In this post we will fix Unable to initialize state monitor Not able to create new database connection.
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.