Error while creating DBLINK Oracle - SQL Server

[ngkumar]

I created DB Link as follows.
But when I run select statement

Select * from TableName@XXX_E H

I get following error message

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 XXX_EH

I am stuck, not sure what to do. Any help would really appreciated.

1. Created System DSN = ICTXXXSCRATCH02 DSN

2. Created initSIDICTXXXSC RATCH02.ora file in ORACLE_HOME\hs\ admin as below

HS_FDS_CONNECT_ INFO = ICTXXXSCRATCH02 DSN
HS_FDS_TRACE_LE VEL = OFF

3. Updated tnsnames.ora in ORACLE_HOME\NET WORK\ADMIN as

XXXSQLSVR =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)( HOST=SCRATCHSVR ) # Oracle Server Name
(PORT=1521)
)
)
(CONNECT_DATA=( SID=SIDICTXXXSC RATCH02))
(HS=OK)
)

4. Updated Listener.ora in ORACLE_HOME\NET WORK\ADMIN as

(SID_DESC=
(SID_NAME=SIDIC TXXXSCRATCH02)
(ORACLE_HOME=D: \oracle\product \10.2.0\db_1)
(PROGRAM=hsodbc )
)

Restarted the listener

5. CREATE public DATABASE LINK XXX_EH
CONNECT TO SA IDENTIFIED BY <PWD>
USING 'XXXSQLSVR'