1 2 Previous Next 16 Replies Latest reply: Dec 4, 2012 3:34 AM by Kgronau-Oracle RSS

    Oracle Gateway to SQL server - ORA-28511: lost RPC connection to heterogene

    indytoatl
      When I run the select statement below I get an error message that the connection was lost. When I run SQL profiler on the SQL db I can see the account login and logout.
      Any ideas what may be the issue here?

      Oracle 11g - running on Windows 7
      SQL 2008 R2 - running on Windows 2008 R2
      CentOS Linux - Gateway only

      SQL> select * from my_table@mygateway;
      ERROR:
      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=My_Linux_Svr.Domain.org)(PORT=1521))

      (CONNECT_DATA=(SID=dg4msql)))
      ORA-02063: preceding line from MYGATEWAY
      Process ID: 16632
      Session ID: 134 Serial number: 27



      no rows selected

      SQL>
        1 2 Previous Next