You may get the following errors when running a query that takes some time to complete (e.g. when fetching a large result set or running select count(*)
against a large table):
ORA-02068: following severe error from <link name> ORA-28511: lost RPC connection to heterogeneous remote agent using
If you turn on HSODBC tracing, the trace output will indicate that:
The problem happens because Oracle times out the link when it takes a long time to get the data from Oracles SQL*Net layer to HSODBC.
You may also get these errors:
ORA-12637: Packet receive failed ORA-12170: TNS:Connect timeout occurred ORA-12547: TNS:lost contact
Please see also the related Oracle bugs #6242391 (Oracle 10) and bug #5753490 (accessible from Oracles customer support web site.)
When investigating this issue, we resolved the problem by adding this line to the sqlnet.ora
file:
SQLNET.INBOUND_CONNECT_TIMEOUT=0
This setting prevents Oracle from timing out the link to HSODBC. Please see the Profile Parameters (sqlnet.ora) in the Oracle Database Net Services Reference Guide for full information on SQLNET.INBOUND_CONNECT_TIMEOUT
.
This issue was reported to us by a customer who was using the Easysoft ODBC-SQL Server Driver version 1.2 with Oracle 10.2.0.4 on an AIX platform. It is also a known problem with:
This issue has not been reported by customers using the Oracle 11g (and later) Database Gateway (DG4ODBC).