I try to connect my Oracle 11.2 database to SQL server 2012. I installed Oracle Gateway on a window 2012 R2 and followed Oracle Gateway configure instruction.

Here is the initdg4msql.ora

#

# HS init parameters

#

HS_FDS_CONNECT_INFO=ctmcsql2012.dot.state.co.us:1433/CTMCSQLSVR12/external

HS_FDS_TRACE_LEVEL=OFF

HS_FDS_TRANSACTION_MODEL=READ_ONLY

HS_DB_NAME=external

HS_DB_DOMAIN=ITS.DOT.STATE.CO.US

LISTENER.ORA

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME=PLSExtProc)

(ORACLE_HOME=D:\product\11.2.0\tg_1)

(PROGRAM=extproc)

)

(SID_DESC =

(SID_NAME=dg4msql)

(ORACLE_HOME=D:\product\11.2.0\tg_1)

(PROGRAM=dg4msql)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = CTMCSQL2012.dot.state.co.us)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)

ADR_BASE_LISTENER =

\product\11.2.0\tg_1

TNSNAMES.ORA

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

dg4msql.its.dot.state.co.us =

(DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=ctmcsql2012.dot.state.co.us)(PORT=1521))

(CONNECT_DATA=

(SID=dg4msql))

(HS=OK)

)

lsnrctl status output:

PS

\product\11.2.0\tg_1\bin> lsnrctl status LISTENER

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 23-APR-2015 14:26:54

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=CTMCSQL2012.dot.state.co.us)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production

Start Date                21-APR-2015 16:00:11

Uptime                    1 days 22 hr. 26 min. 42 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File

\product\11.2.0\tg_1\network\admin\listener.ora

Listener Log File         d:\product\11.2.0\tg_1\diag\tnslsnr\CTMCSQL2012\listener\alert\log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=CTMCSQL2012.dot.state.co.us)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "dg4msql" has 1 instance(s).

Instance "dg4msql", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

I copied TNS entry to the database TNSNAMES.ora and created a DB link and get error:

CREATE DATABASE LINK "[email protected]"

CONNECT TO "CoDOT"

IDENTIFIED BY

USING 'dg4msql.its.dot.state.co.us';

Error : 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 [email protected]

*********************************************************************