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.

BEA-150000 Error when starting Admin Server

Are you writing scripts to start & stop the admin server?


Are you getting below error when trying to start the Admin Server using scripts?

 <Error> <Configuration Management> <xxxxx.na.lzb.hq> <AdminServer> <[STANDBY] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1541099907869> <BEA-150000> <An error occurred while establishing a connection back to the Adminstration Server t3://10.1.2.79:7001 during startup. Since bootstrap succeeded, check that t3://1xx.yy.zz.rr:7001 uniquely identifies the Administration Server.

Here the catch:

If you have set this variable any where in your scripts or property file, you are bound to get the error.

ADMIN_URL=<HOST>:<PORT>

Resolution: ==> Do not set the variable ADMIN_URL anywhere in you startup script or property file.

Repeat the above statement 4 more times again.