hello,
i have an issue on my prod server since lastweek.
from server.log i got this message error but i have no idea where the problem is.
im using Integration Server 10.15 and ojdbc8
error message:
1.
[1787]IO Error: Got minus one from a read call, connect lapse 60017 ms., Authentication lapse 0 ms.
[1786][ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
[1785][ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource [connection name].
[2423]IO Error: The Network Adapter could not establish the connection
[2422][ADA.1.204] Cannot connect to the database with DataSource class “oracle.jdbc.pool.OracleDataSource”.
[2421]2025-07-15 09:28:54 ICT [ART.0114.1007E] (tid=355204) Adapter Runtime: Error Logged. See Error log for details. Error: [ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource [connection name].
Integration Server is connected to many Oracle DB but this error only appear from 1 DB. what i suppose to do?
regards,
momon
Hi Momon,
what is the exact version of your ojdbc8.jar? To which Oracle version is it referring?
Which Oracle version is the affected database running on?
I assume that your are running on JDBC Adapter 10.3.
Are there any fixes applied to IS, ART and JDBC adapter?
Can you get in contact with the DBAs of the affected DB to check if there is anything related to this in the logs on DB side?
Were there any changes on IS or DB side which might be causing this?
Regards,
Holger
hi @Holger_von_Thomsen,
idont know what the exact version for ojdbc8 is, for oracle we useing 19c
for the JDBC adapter using JDBC Adapter 10.3 fix 20
for the IS is
and ART
from our DBA only say its intermittent.
and this morning i have a new issue the adapter cannont make connection until i reenable the JDBC Connector. the message is
[88076]2025-07-17 10:06:13 ICT [ART.0114.1007E] (tid=845867) Adapter Runtime: Error Logged. See Error log for details. Error: [ART.117.4012] Adapter Runtime (Adapter Service): Unable to run adapter service. Error occurred when connecting to resource ad1.connection.core.oracle:dbAolConnInquiry2.
[88075]A connection was not available for request in pool ad1.connection.core.oracle:dbAolConnInquiry2, error code: 107
[88074]2025-07-17 10:06:13 ICT [ART.0114.1007E] (tid=845867) Adapter Runtime: Error Logged. See Error log for details. Error: [ART.118.5053] Adapter Runtime (Connection): Unable to get a connection to resource ad1.connection.core.oracle:dbAolConnInquiry2.
[88073]2025-07-17 10:06:13 ICT [SCC.0126.0106E] (tid=845867) An error occurred while attempting to retrieve a connection from ad1.connection.core.oracle:dbAolConnInquiry2
its never happen when i using IS 10.3, but start form we migrate to IS 10.15 i have this problem everyday from this jan.
regards
momon
Hi Momon,
from https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html:
To check the version of the Oracle JDBC driver, use java -jar ojdbcX.jar (eg., java -jar ojdbc8.jar).
The latest long term stable driver is 19.27.
Which Java version are you running your IS on?
Eventually you can switch to the ojdbc10.jar then when it is Java 10 or newer.
Additionally, check your connection config for the pooling settings and set the minimum value to 0 to avoid that stale connections are blocking the pool.
Regards,
Holger
hi holger,
for the ojdbc driver using Oracle 12.2.0.1.0 JDBC 4.2
IS java version 11.0.19 (55.0), for this java version from your experience beter using ojdbc8-19.27 or beter we move to ojdbc 10?
for the minimum pool value alreadt set to 0.
regards
momon
Hi Momon,
in this case I would suggest to update your driver jar to ojdbc10-19.27 and remove the old ojdbc8.jar from your installation.
Remember to restart your IS after that to get the old jar unloaded from JVM.
Regards,
Holger
