AnsweredAssumed Answered

TNS Channel Error

Question asked by Sathish Kumar Sellamuthu on Nov 17, 2017
Latest reply on Nov 20, 2017 by Joao Figueiredo

Hi,

 

We are connecting PDI (way old version) 4.3.0 to Oracle 11.2.0.4 (Exadata version). When there are multiple queries connected to Oracle executing via JDBC connection fails at one point with the below error,

 

Error occured while trying to connect to the database

 

 

Error connecting to database: (using class oracle.jdbc.driver.OracleDriver)

IO Error: End of TNS data channel

 

- which means say out of 10 connections to Oracle , one single connection briefly for a second disconnects. And yes, PDI stand alone (Unix version) sits on different server and communicating to Oracle DB server.

 

I have tried changing jar file versions. None of them could help. At present , we are using ojdbc6.jar and orai18n.jar for JDBC Connection

Outcomes