Stuck Threads On DoPingDatabase (Doc ID 2271927.1)

Last updated on AUGUST 30, 2023

Applies to:

Symptoms

Stuck threads are generated on doPingDatabase when using JDBC 12.1.0.2 on FMW 11.1.1.9.0.

Blocking thread is JDBC doPingDatabase :

 java.lang.Thread.State: RUNNABLE
  at java.net.SocketInputStream.socketRead0(Native Method)
  at java.net.SocketInputStream.read(SocketInputStream.java:164)
  at java.net.SocketInputStream.read(SocketInputStream.java:134)
  at oracle.net.nt.MetricsEnabledInputStream.read(TcpNTAdapter.java:730)
  at oracle.net.ns.Packet.receive(Packet.java:310)
  at oracle.net.ns.DataPacket.receive(DataPacket.java:108)
  at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:325)
  at oracle.net.ns.NetInputStream.read(NetInputStream.java:269)
  at oracle.net.ns.NetInputStream.read(NetInputStream.java:191)
  at oracle.net.ns.NetInputStream.read(NetInputStream.java:108)
  at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:126)
  at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:82)
  at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1178)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:314)
  at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
  at oracle.jdbc.driver.T4CTTIoping.doOPING(T4CTTIoping.java:55)
  - locked (a oracle.jdbc.driver.T4CConnection)
  at oracle.jdbc.driver.T4CConnection.doPingDatabase(T4CConnection.java:4751)
  at oracle.jdbc.driver.PhysicalConnection$3.run(PhysicalConnection.java:12808)
  at java.lang.Thread.run(Thread.java:798)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.