1 Reply Latest reply on Apr 14, 2010 8:18 AM by Kai-Oracle

    ORA-28545: error diagnosed by Net8 when connecting to an agent


      I've to setup the Oracle Gateway service in order to access the SQL Server 2005 db from Oracle11g db which is running on a LINUX os.

      Basically, i've to periodically PULL data from SQL Server to oracle.

      Have done the necessary setup as specified in Oracle docs.

      1. Oracle ini file: initdg4msql.ora


      2. listener.ora entry

      (ADDRESS = (PROTOCOL = TCP)(HOST = oracle.portal.internal)(PORT = 1522))

      (SID_LIST =
      (SID_DESC =
      (SID_NAME = OBIM1)
      (ORACLE_HOME = /app/oracle/product/11.1.0/db_1)
      (SID_DESC =
      (SID_NAME = dg4msql)
      (ORACLE_HOME = /app/oracle/product/11.1.0/db_1)
      (PROGRAM = dg4msql)

      3. tnsnames.ora entry

      dg4msql =
      (ADDRESS = (PROTOCOL = tcp)(HOST = oracle.portal.internal)(PORT = 1522))
      (CONNECT_DATA =(SID = dg4msql))
      (HS = OK)

      4. Create database link on oracle

      create public database link sqlserver connect to "sqlserver_user_id" identified by "sqlserver_user_password" using 'dg4msql';

      Database link created.


      Upon the completion of the configuration, I did the following and all are successful and working:

      - starting the listener by

      lsnrctl start LISTENER_GATEWAY

      - tnsping my gateway

      tnsping dg4msql

      However, when I tried to retreive data and got the following error:

      SQL> desc myTestingTable@sqlserver;
      ORA-28545: error diagnosed by Net8 when connecting to an agent
      Unable to retrieve text of NETWORK/NCR message 65535
      ORA-02063: preceding 2 lines from SQLSERVER

      I have stepped through the doc of "How to Setup DG4MSQL (Oracle Database Gateway for MS SQL Server) Release 11" but unable to figure out where the error lies.

      Any inputs on this?? please help, I am in urgent.