3 Replies Latest reply: Mar 1, 2013 5:46 AM by Mkirtley-Oracle RSS

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

    984345
      Hi , I know that this error has many threads before but i have tried them all and none of them worked

      MY problem is not in the lisener nor the tns nor the dblink
      It is an odbc drive i think

      I have window server 2008 r2 sp2 64 bit
      and i have sql server 2008 r2 64 bit also

      and i have also office 2010 64 bit alll on same station


      when i create a link using a .msd or my sql odbc it gives me this error


      *********************************************************************
      Link : "linkname"
      Error : 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 linkname
      *********************************************************************

      the problem is if i use the same odbc names but located on window server 2003 on another host its working i need them to work uson this windows 2008 station please help am ready to post listner, tns .

      Please help i have been working on this problem more than one year and i tried all possble ways and i cant solve
      my oracle is (10.2.0.4.0)

      Edited by: 981342 on 11-Jan-2013 05:57
        • 1. Re: Error : ORA-28545: error diagnosed by Net8 when connecting to an agent
          Mkirtley-Oracle
          Hi,
          The ORA-28545 error is usually a configuration problem but we will need to see the files.
          If you are using 10.2 HSODBC or TG4MSQL then that is the problem because they were never ported to Windows 64-bit. The only generic connectivity option or gateway available on Windows 64-bit is the 11.2 Database Gateway for ODBC (Dg4ODBC) or Database Gateway for SQL*Server (DG4MSQL)
          If you are using the 11.2 gateways then to check further please send the following -

          - gateway listener.ora
          - gateway init<sid>.ora
          - tnsnames.ora
          - create database link statement.

          If you are using 10.2 gateways then the only alternative on Windows 64-bit is to install the 11.2 gateway in a separate ORACLE_HOME from the 10.2 install.
          The 11.2 gateways are certified with RDBMS 10.2.0.4.

          Regards,
          Mike

          Edited by: mkirtley on Jan 11, 2013 2:13 PM
          • 2. Re: Error : ORA-28545: error diagnosed by Net8 when connecting to an agent
            984345
            Hi I have installed 11g Release 2 (11.2) for Microsoft Windows x64 (64-Bit) , My sql is 64 bit also BUt still when test the dblink am getting
            *********************************************************************
            Link : "MSSQL"
            Error : 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 MSSQL
            *********************************************************************

            Here is a listener.ora
            MSSQL =

            (DESCRIPTION_LIST =

            (DESCRIPTION =

            (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))

            )

            )

            SID_LIST_MSSQL =

            (SID_LIST =

            (SID_DESC =

            (PROGRAM = dg4odbc)

            (SID_NAME = acc)

            (ORACLE_HOME = e:\oracle\product\11.2.0\dbhome_1)

            )

            )



            ADR_BASE_MSSQL = e:\Oracle


            Tns.ora

            ORCL=
            (DESCRIPTION=
            (ADDRESS=
            (PROTOCOL=TCP)
            (HOST=hostname)
            (PORT=1521)
            )
            (CONNECT_DATA=
            (SERVICE_NAME= orcl)
            )
            )

            MSSQL =

            (DESCRIPTION=

            (ADDRESS=(PROTOCOL=tcp)

            (HOST=hostname)

            (PORT=1521))

            (CONNECT_DATA=(SID= acc))

            (HS=OK)

            )



            initacc.ora

            # HS init parameters
            #
            HS_FDS_CONNECT_INFO = acc

            HS_FDS_TRACE_LEVEL= OFF



            #
            # Environment variables required for the non-Oracle system
            #
            #set <envvar>=<value>


            I also added a initdg4acc.ora

            HS init parameters

            #

            HS_FDS_CONNECT_INFO = acc

            HS_FDS_TRACE_LEVEL = off

            #

            # Environment variables required for the non-Oracle system

            #

            #set <envvar>=<value>

            I used ODBC located in c:\windows\system32\odbcad32.exe

            and I added a sql server system dns and called it "acc" and point it to sql server using sql authentication

            Link script is

            CREATE DATABASE LINK MSSQL
            CONNECT TO SA
            IDENTIFIED BY <PWD>
            USING 'MSSQL';

            Here is the returns value of lisner and tns status



            C:\>lsnrctl status

            LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 01-MAR-2013 13:31
            :19

            Copyright (c) 1991, 2010, Oracle. All rights reserved.

            Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
            STATUS of the LISTENER
            ------------------------
            Alias LISTENER
            Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Produ
            ction
            Start Date 01-MAR-2013 13:03:23
            Uptime 0 days 0 hr. 27 min. 56 sec
            Trace Level off
            Security ON: Local OS Authentication
            SNMP OFF
            Listener Parameter File E:\oracle\product\11.2.0\dbhome_1\network\admin\listen
            er.ora
            Listener Log File e:\oracle\product\11.2.0\diag\tnslsnr\Server2\listener
            \alert\log.xml
            Listening Endpoints Summary...
            (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hostname)(PORT=1521)))
            Services Summary...
            Service "orcl" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
            Service "orclXDB" has 1 instance(s).
            Instance "orcl", status READY, has 1 handler(s) for this service...
            The command completed successfully

            C:\>tnsping mssql

            TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 01-MAR-2
            013 13:31:31

            Copyright (c) 1997, 2010, Oracle. All rights reserved.

            Used parameter files:
            E:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora


            Used TNSNAMES adapter to resolve the alias
            Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp) (HOST=hostname) (PORT=1521)) (CONNECT_DATA=(SID= acc)) (HS=OK))
            OK (0 msec)



            testing dblink is making that net 8 error

            Please help cuz am sick of reading and searchin I have tried almost everything

            Edited by: 981342 on 01-Mar-2013 03:34
            • 3. Re: Error : ORA-28545: error diagnosed by Net8 when connecting to an agent
              Mkirtley-Oracle
              Hi,
              You have set up a listener called MSSQLusing port 1521. However, you have shown the status of the listener called 'LISTENER' which is also using port 1521.
              Can you change the port used by the MSSQL listener to 1522 (or another port not being used) and make sure you can start the gateway listener and that it has the 'acc' service running -

              lsnrctl
              start mssql
              status mssql
              services mssql

              You will need to change the tnsnames.ora MSSQL entry to use the MSSQL port number, then try a select from a new SQLPLUS session.


              One other point - the database link is created as -

              CREATE DATABASE LINK MSSQL
              CONNECT TO SA
              IDENTIFIED BY <PWD>
              USING 'MSSQL';

              but SQL*Server is case sensitive for user and passowrd, so you should create it as -

              CREATE DATABASE LINK MSSQL
              CONNECT TO "sa"
              IDENTIFIED BY "<PWD>"
              USING 'MSSQL';

              - where "sa" and "<PWD>" are the same case as used in SQL*Server for the names.

              Regards,
              Mike