SOA 11g Admin - Increasing Database Connection Values

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