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


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.

Who is Participating?
sglewConnect With a Mentor Author Commented:
I just started back over with the DSN and all the connections and now I'm back to where I need to be.

lilian-arnaudConnect With a Mentor Commented:
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.
sglewAuthor Commented:

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...

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.