Current Cofiguration:
We are using Weblogic 9.2 MP3 and Oracle 10g.
We have One Admin Server and two managed Node .. But these are not in any Cluster.
The underlaying database is HA configured .There are 6 datasource for each 6 VIP in Weblogic for Database connection.
And these 6 datasource are bind with single multiple datasource with failover algorithm enabled.
Also these 6 datasource have the below property .....
Database Driver:Oracle's Driver(Thin) Version:9.0.1,9.2.0,10
Test Connections On Reserve :TRUE
Shrink Frequency :900
Ignore In-Use Connections: TRUE
Remove Infected Connections Enabled:TRUE
Initial Capacity: 1
Maximum Capacity: 100
Capacity Increment: 1
Property for mutidatasource
Failover Request if Busy :FALSE
Failover Callback Handler: NONE
Problem Descriptio:
After someday interval we are getting the below error in our log
[java.sql.SQLException: weblogic.common.ResourceException:
MultiDataSource(DataSource009): weblogic.common.resourcepool.ResourceLimitException:
No resources currently available in pool DataSource009 to allocate to applications, please increase the size of the pool and retry..
And no failover is happening .also in bea log it is just saying DataSource009 as closed. No other message is there.
While monitoring this datasource
Server managed1_wls01
Active Connections Current Count :0
Active Connections :4
Connection Delay Time: 1657
Current Capacity :4
Current Capacity Hight Count:3
Server managed2_wls01
Active Connections Current Count:1
Active Connections :8
Connection Delay Time:998
Current Capacity :2
Current Capacity Hight Count:7
we can see this data dource in no node is touching the Maximum Capacity as : 100
So why the above error is comming and what is the resolution ?