Error while creating DBLINK Oracle - SQL Server

[ngkumar]

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

Select * from TableName@XXX_EH

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 = ICTXXXSCRATCH02DSN

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

HS_FDS_CONNECT_INFO = ICTXXXSCRATCH02DSN
HS_FDS_TRACE_LEVEL = OFF

3. Updated tnsnames.ora in ORACLE_HOME\NETWORK\ADMIN as

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

4. Updated Listener.ora in ORACLE_HOME\NETWORK\ADMIN as

(SID_DESC=
(SID_NAME=SIDICTXXXSCRATCH02)
(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'