This discussion is archived
3 Replies Latest reply: Mar 1, 2013 3:46 AM by mkirtley-Oracle RSS

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

984345 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points