Listener Error TNS-12518 And User Error ORA-28545 Using DG4MSQL 11g on Windows

(Doc ID 1129415.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database Gateway for SQL Server - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 04-Nov-2014***


Symptoms

You are using DG4MSQL to connect to SQL*Server and a connection gives the following error -

SQL> select * from emp@testlink;
select * from emp@testlink
*
Error at line1:
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 TESTLINK.


A listener log file shows the following errors -

TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 2: No such file or directory

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms