My Oracle Support Banner

Listener Error TNS-12518 And User Error ORA-28545 Using DG4MSQL 11g on Windows (Doc ID 1129415.1)

Last updated on SEPTEMBER 04, 2024

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.

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.