java.sql.SQLException: Pool connect failed : weblogic.common.ResourceException: oms_pool(osm_pool_ra
Actually we have a problem in our OSM production environment, since this morning we start receiving the following error in WebLogic console:
java.sql.SQLException: Pool connect failed : weblogic.common.ResourceException: oms_pool(osm_pool_rac1): Pool osm_pool_rac1 is Suspended, cannot allocate resources to applications.
That error causes the osm_pool_rac1 change the status to suspended and the osm application leave working, we need to resume manually the data source to start the osm application, but when osm received the first request the data source change to suspended again.
We check the Persistent Stores we have associated to our JMS Servers and those JMS Servers was pointing to the same Data Source osm_pool_rac1 so we changed the persistent store used by JMS Servers to File Store, after that we continue looking the data source change the status to suspended but automatically resume the data source and the osm still working.