Oracle Gateway to SQL server - ORA-28511: lost RPC connection to heterogene
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>