3 Replies Latest reply: Mar 9, 2012 9:20 AM by Mkirtley-Oracle RSS

    ORA-28511: lost RPC connection to heterogeneous remote agent using SID=%s

    PauloJCJ
      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