ORA-28545 when trying to connect to SQL Server via Oracle DB Link after SQL Navigator Install

Posted on 2009-02-17
Last Modified: 2013-12-18

We setup a system DSN to a SQL Server DB and then setup Oracle Heterogeneous services on our Oracle DB so we can select from SQL Server via a public DB link in Oracle.  This was working just great, I was able to use Oracle SQL Plus to select from SQL server using the database link.  Had no issues with the link or communication so if I ran the following I was returned the proper information:

select * from "User"@sqlserver;

Then I installed SQL Navigator.  Something with the install of that software hosed the connection.  Whether I try that same select statement from SQL Navigator or SQL Plus I get the following error:

ERROR at line 1:
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 tried un-installing SQL Navigator and that didn't fix it.

I have absolutely no idea where to go with this, I really don't want to start all over again from scratch I'm hoping someone out there may be able to point me in the proper direction to fix the problem at hand.

Question by:sglew
    LVL 3

    Assisted Solution

    do you have configured the listener to point to the heterogeneus service (listener.ora) ?
    do you have created a new connection in your tnsnames.ora file ?
    do you have restarted your listener service ?

    if the remote connection works fine with sqlplus (is it the case ?), you may have another ORACLE_HOME entry in the registry. switch the default oracle home to the previous home and restart your db and your listener.

    Author Comment


    Everything was configured and working just fine before I installed the SQL Navigator software.  I was able to select from the remote SQL Server DB using sqlplus.  As soon as I installed SQL Navigator I started receiving this error whether using SQL Navigator or sqlplus.  I just checked the following within the Registry and only found one ORACLE_HOME and it is correct...


    Accepted Solution

    I just started back over with the DSN and all the connections and now I'm back to where I need to be.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
    From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
    This video shows how to recover a database from a user managed backup

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now