RE: Connection closed error

What's in the Oracle (alert, listener) logs?

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Pap Sent: Wednesday, October 27, 2021 12:17 PM To: Lok P <loknath.73_at_gmail.com>
Cc: Oracle L <oracle-l_at_freelists.org> Subject: Re: Connection closed error

CAUTION: This email originated from outside of the organization. Do not follow guidance, click links, or open attachments unless you recognize the sender and know the content is safe.

Thank you.

Can this be anyway related to the database or Is this error purely related to Java side connection pooling (and may be some setup issue over there) but not anyway related to database?

On Wed, Oct 27, 2021 at 12:52 AM Lok P <loknath.73_at_gmail.com<mailto:loknath.73_at_gmail.com>> wrote: Don't have much idea about connection pool setup and management , but it seems to be related to how that is configured.

https://www.ibm.com/docs/en/was-nd/9.0.5?topic=applications-connection-pool-settings<https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ibm.com%2Fdocs%2Fen%2Fwas-nd%2F9.0.5%3Ftopic%3Dapplications-connection-pool-settings&data=04%7C01%7Cclay.jackson%40quest.com%7Cf0e420e7a7b9469da52408d9997e6968%7C91c369b51c9e439c989c1867ec606603%7C0%7C1%7C637709590485936956%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=6RwkFlrUCcYJhrNehU66ZhrVWNGs0OYNM4eNvIQlOo4%3D&reserved=0>

On Sun, Oct 24, 2021 at 3:34 PM Pap <oracle.developer35_at_gmail.com<mailto:oracle.developer35_at_gmail.com>> wrote:

Hello Listers, Its oracle database version 11.2.0.4. We have one of the customer java websphere applications pointing to this database encountering connection close error while doing the stored proc execution. Sometimes after a few minutes into the stored procedure call and a few times after ~2 hours into execution. In a normal scenario, this job succeeds, within <10 seconds . So during failure time, it may have been waiting for some resource or other bottleneck that resulted in long execution time. So want to understand if anybody encountered such an error and what is the cause and fix of this? Below is the application log.

com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.

               at com.ibm.ws.rsadapter.jdbc.WSJdbcWrapper.createClosedException(WSJdbcWrapper.java:122)
               at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.activate(WSJdbcConnection.java:2936)
               at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.setAutoCommit(WSJdbcConnection.java:3512)

We found below doc matching the error but it seems if it would have been this bug then rerun also would have been failed. So our case might be different.

Protocol Violation and Connection is Closed exceptions When Using JDBC 12.1.0.2 with WebSphere (Doc ID 2359390.1)

--
http://www.freelists.org/webpage/oracle-l