Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2009-02-17
3
Medium Priority
?
2,666 Views
Last Modified: 2013-12-18
Hi,

We setup a system DSN to a SQL Server DB and then setup Oracle Heterogeneous services on our 10.2.0.4 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.

Thanks,
joe
0
Comment
Question by:sglew
  • 2
3 Comments
 
LVL 3

Assisted Solution

by:lilian-arnaud
lilian-arnaud earned 400 total points
ID: 23665327
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.
0
 

Author Comment

by:sglew
ID: 23671991

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

HKEY_LOCAL_MACHINE>SOFTWARE>ORACLE
0
 

Accepted Solution

by:
sglew earned 0 total points
ID: 23674348
I just started back over with the DSN and all the connections and now I'm back to where I need to be.

Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

810 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