Database Administration (MOSC)

MOSC Banner

Fail to connect to sql server from oracle 12c via oracle gateway

edited Jan 8, 2020 11:45AM in Database Administration (MOSC) 1 commentAnswered

Kindly assist, am failing to DB link sql server from oracle 12c  using oracle gateway

SQL> select 1 from dual@mslink;

select 1 from dual@mslink

                   *

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 MSLINK

this is how i configured the gateway ( note that the gateway software was installed in the same oracle home directory

listener.ora

=========

# listener.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (PROGRAM = /u01/app/oracle/product/12.2.0/dbhome_1/bin/dg4msql)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center