SOA 11g Admin - Increasing Database Connection Values

You can receive the following error message because of slow connections to the database.

Exception [TOPLINK-4002] (Oracle TopLink - 11g Release 1 (11.1.1.1.0) (Build

090304)): oracle.toplink.exceptions.DatabaseException

Internal Exception: java.sql.SQLException: Internal error: Cannot obtain

XAConnection weblogic.common.resourcepool.ResourceDeadException: Pool

SOADataSource has been disabled because of hanging connection tests, cannot

allocate resources to applications.

If this occurs, perform the following steps:

1. Open the DOMAIN_HOME\bin\setSOADomainEnv.cmd file.
2. Uncomment the lines shown in bold.
3. # 8331492: Value of weblogic.resourcepool.max_test_wait_secs is 10
4. # seconds. It can be increased by uncommenting line below if your database
5. # connections are slow. See SOA documentation for more details.
6. EXTRA_JAVA_PROPERTIES="${EXTRA_JAVA_PROPERTIES}
7. -Dweblogic.resourcepool.max_test_wait_secs=30"
8. export EXTRA_JAVA_PROPERTIES

Save your changes and restart the managed Oracle WebLogic Server.