"IO Error: Connection Timed Out" Using Thin Driver And "ORA-03113: end-of-file on communication channel" Using OCI Driver From JDBC Program After IP Change On The Database Host

(Doc ID 2008225.1)

Last updated on OCTOBER 13, 2016

Applies to:

JDBC - Version 11.2.0.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.3.0 version, Thin JDBC driver

The network configuration on the database has been changed. The IP address on this database host was changed, and after this change the JDBC connection from a particular host is not working.
If a JDBC java program using the Thin driver is executed to connect the the database , it repoorts "IO Error: Connection timed out" error. Using the OCI driver, it gives an "ORA-03113: end-of-file on communication channel".
The complete errors are as follows:

ERROR
-----------------------
Using the JDBC Thin driver:
=======================

java -Doracle.jdbc.Trace=true -Djava.util.logging.config.file=Logging.properties -cp /tmp/ojdbc6_g.jar:. NTraceSample
Exception in thread "main" java.sql.SQLRecoverableException: IO Error: Connection timed out
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:841)
  at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:751)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:38)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:593)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at NTraceSample.main(NTraceSample.java:6)
Caused by: java.net.SocketException: Connection timed out
  at java.net.SocketInputStream.socketRead0(Native Method)
  at java.net.SocketInputStream.read(Unknown Source)
  at oracle.net.ns.Packet.receive(Packet.java:317)
  at oracle.net.ns.DataPacket.receive(DataPacket.java:101)
  at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:301)
  at oracle.net.ns.NetInputStream.read(NetInputStream.java:245)
  at oracle.net.ns.NetInputStream.read(NetInputStream.java:167)
  at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
  at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:119)
  at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:75)
  at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:447)
  at oracle.jdbc.driver.T4C8TTIdty.receive(T4C8TTIdty.java:706)
  at oracle.jdbc.driver.T4C8TTIdty.doRPC(T4C8TTIdty.java:611)
  at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:2161)
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:564)
  ... 6 more

Error using JDBC OCI driver:
=======================

java -cp ./ojdbc6.jar:. OracleN1JDBC
-------- Oracle JDBC Connection Testing ------
Oracle JDBC Driver Registered!
Connection Failed! Check output console
java.sql.SQLRecoverableException: ORA-03113: end-of-file on communication channel

  at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:996)
  at oracle.jdbc.driver.T2CConnection.logon(T2CConnection.java:530)
  at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:662)
  at oracle.jdbc.driver.T2CDriverExtension.getConnection(T2CDriverExtension.java:54)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:560)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at java.sql.DriverManager.getConnection(Unknown Source)
  at OracleN1JDBC.main(OracleN1JDBC.java:29)




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms