Oracle Database Discussions

Hi,

Please Help to relsove below issue:

I am using Oracle gateway for Sql Server 11.2 on Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi, on a IBM Power p595 AIX 6.1, SQL Server 2008

When I run a query the first time, it runs perfectly. After some time, I try to run it again and it displays the following error: lost RPC connection

09:44:09 SQL> select count(*) from GSUP_ATRIBUTO@SQLPRD;

COUNT(*)
----------
73

09:48:48 SQL> /
select count(*) from GSUP_ATRIBUTO@SQLPRD
*
ERROR at line 1:
ORA-02068: following severe error from SQLPRD
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.20.8.28)(PORT=1521))(CONNECT_DATA=(SID=SQLPRD)))


09:49:05 SQL> /

COUNT(*)
----------
73

In the gateway trace file we can see:

Oracle Corporation --- FRIDAY MAR 09 2012 09:51:04.140

Heterogeneous Agent Release
11.2.0.1.0

HS Agent received unexpected RPC disconnect
Network error 1003: NCR-01003: NCRS: Read error.


Gateway initSQLPRD.ora file
# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server
#
# HS init parameters
#
HS_FDS_CONNECT_INFO=[ipSQLSERVER]:port//
# alternate connect format is hostname/serverinstance/databasename
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

Gateway Listener
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME=SQLPRD)
(ORACLE_HOME=/home/oracle/app/oracle/product/10.2.0)
(ENV="LD_LIBRARY_PATH=/home/oracle/app/oracle/product/10.2.0/dg4msql/driver/lib:/home/oracle/app/oracle/product/10.2.0/lib")
(PROGRAM=dg4msql)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ipGateway) (PORT = 1521))
)
)
)

SQLNET.INBOUND_CONNECT_TIMEOUT=0


My tnsnames.ora file
SQLPRD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = ipGateway)(PORT = 1521))
(CONNECT_DATA =
(SID = SQLPRD)
)
(HS = OK)
)


Alert log message in Oracle Server:
Fri Mar 09 09:48:47 GMT-03:00 2012HS: Lost RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ipGateway)(PORT=1521))(CONNECT_DATA=(SID=SQLPRD))), NCR status = -2147385340


Please help