BEA-001112 java.sql.SQLRecoverableException: IO Error: Connection reset in weblogic

Error:


<Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "VPDDataSource" failed with exception: "java.sql.SQLRecoverableException: IO Error: Connection reset".>


Cause:

There are two scenarios that can result in this error:

1. If it is single instance database:
The DB instance that the jdbc datasource is configured for, was unavailable either due to shutdown or some other issues.

2. If it is RAC databsae:
Both A & B below should be true to receive this error in weblogic.
A. One of the database instance of your cluster/RAC database, that your jdbc session was hooked on to, either died or it was shutdown, and 

B. The JDBC pool is configured as generic datasource, and not as gridlink datasource, 

 

Resolution:

Use RAC databsae to make database highly available, and at also ensure that JDBC datasource is configuerd as gridlink , and not as generic.