We are connecting PDI (way old version) 4.3.0 to Oracle 18.104.22.168 (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