4 Replies Latest reply: Sep 20, 2012 12:25 AM by Kgronau-Oracle RSS

    Lose RPC connection from database to gateway

    tx103108
      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-Oracle
          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
            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
              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-Oracle
                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.