This discussion is archived
4 Replies Latest reply: Sep 19, 2012 10:25 PM by kgronau RSS

Lose RPC connection from database to gateway

tx103108 Newbie
Currently Being Moderated
OS: Red Hat Linux 5.4 64-bit
DB: Oracle Ent Ed 11gR1 64-bit
Gateway: Oracle Gateway for ODBC 64-bit
(1) Database and gateway reside on same Linux Server.
(2) Trying to connect to remote Sybase Anywhere 10 server on WindowsXP.
(3) Using FreeTDS odbc driver and unixODBC driver manager.
(4) Created public dblink 'txeis'.
(5) tnsping works fine.
(6) inittxeis.ora file:
============

HS_FDS_CONNECT_INFO = txeis
HS_FDS_SHAREABLE_NAME = /etc/unixODBC-2.3.1/DriverManager/.libs/libodbc.so

HS_LANGUAGE=american_america.we8iso8859p1
HS_NLS_NCHAR=UCS2

set ODBCINI=/usr/local/etc/odbc.ini

(7) listener.ora (gateway section of file below; using one listener.ora for both db and gateway but 2 listeners are started):
===========================================================================

LISTENER_GTW =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.10.10)(PORT=1522))
)

SID_LIST_LISTENER_GTW =
(SID_LIST=
(SID_DESC=
(SID_NAME=txeis)
(ORACLE_HOME=/u01/app/oracle/product/11.1/db_1)
(PROGRAM=dg4odbc)
(ENVS=LD_LIBRARY_PATH=/usr/local/freetds/lib:$ORACLE_HOME/hs/lib:$ORACLE_HOME/lib)
)
)

(8) tnsnames.ora (gateway section of file below):
==============================
txeis =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1522))
(CONNECT_DATA =
(SID = txeis))
(HS=OK))

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Given the above, I get the following error:

select * from mytable@txeis
*
ERROR at line 1:
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.10.10.10)(PORT=1522))(CONNECT_DATA=(SID=txeis)))
ORA-02063: preceding line from TXEIS
Process ID: 15506
Session ID: 228 Serial number: 19545
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Any help would be appreciated. Thx.

Edited by: user601798 on Sep 18, 2012 2:34 PM
  • 1. Re: Lose RPC connection from database to gateway
    kgronau Guru
    Currently Being Moderated
    Could you please provide a gateway trace level 255?
    Tracing is enabled in the gateway init file by setting HS_FDS_TRACE_LEVEL=255
  • 2. Re: Lose RPC connection from database to gateway
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    As well as the gateway trace could you also change the listener.ora to use the full directory path instead of $ORACLE_HOME ? You should include the path of the ODBC driver manager, so the ENVS parameter should look like -

    (ENVS=LD_LIBRARY_PATH=/etc/unixODBC-2.3.1/DriverManager/.libs:/usr/local/freetds/lib:/u01/app/oracle/product/11.1/db_1/lib)

    Stop and start the listener after making the change.
    Have a look at this note in My Oracle Support for more details -

    How to Configure DG4ODBC on 64bit Unix OS (Linux, Solaris, AIX, HP-UX Itanium) to Connect to Non-Oracle Databases Post Install (Doc ID 561033.1)

    Regards,
    Mike
  • 3. Re: Lose RPC connection from database to gateway
    tx103108 Newbie
    Currently Being Moderated
    HS_FDS_CONNECT_INFO = txeis
    HS_FDS_SHAREABLE_NAME = /etc/unixODBC-2.3.1/DriverManager/.libs/libodbc.so
    HS_FDS_TRACE_LEVEL = 255
    HS_FDS_TRACE_FILE_NAME = /tmp/hsodbc.trc

    HS_LANGUAGE=american_america.we8iso8859p1
    HS_NLS_NCHAR=UCS2
    ===================
    Result: No trace file is created

    Replaced $ORACLE_HOME with full path to libs and restarted listener.
    ===================
    Result: No change in error - same issue.

    Thanks.
  • 4. Re: Lose RPC connection from database to gateway
    kgronau Guru
    Currently Being Moderated
    to create the gateway trace please only add to the gateway init file
    HS_FDS_TRACE_LEVEL = 255
    and do not specify HS_FDS_TRACE_FILE_NAME.

    Then make sure you open a new SQL*Plus session as only when you start a new gateway session the gateway init file is read. Execute your command and exit once you got the error. The gateway log file is then found in $ORACLE_HOME/hs/log.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points