Oracle Database Discussions

Hi

I am tring to create a db link from oracle 10.2.0.1 running on a redhat server to a sybase anywhere server running on win2008 server.
after creating the link and running a select I get this error

SQL> SELECT * FROM PA_TEST@SYBPA;
SELECT * FROM PA_TEST@SYBPA
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][Sybase][ODBC Driver][SQL Anywhere]Database
server not found (SQL State: 08001; SQL Code: -100)
ORA-02063: preceding 2 lines from SYBPA



here is the configuration I have done:

########## listener.ora in $ORACLE_HOME/network/admin on sybase server ##############

LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=coolserver.COOL)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)
)
)
SID_LIST_LISTENER =
(SID_LIST=
(SID_DESC=
(SID_NAME=sybpa
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM=hsodbc)
)
)


################initSYBPA.ora in $ORACLE_HOME/hs/admin on sybase server #######


# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = SYBPA
HS_FDS_TRACE_LEVEL = off


#
# ODBC specific environment variables
##
#set ODBCINI=<full path name of the odbc initilization file>


#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>


##### tnsnames.ora on oracle RHEL server ##############


SYBPA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = coolserver.COOL)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = SYBPA)
)
(HS=OK)
)

########## output of tnsping from oracle server #########

[oracle@cooldb admin]$ tnsping SYBPA

TNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 23-MAR-2011 11:59:43

Copyright (c) 1997, 2005, Oracle. All rights reserved.

Used parameter files:
/opt/app/oracle/product/10.2.0/cool/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = coolserver.COOL)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = SYBPA)) (HS=OK))
OK (0 msec)



can anyone help me please understand where I have made the mistake?

Thanks
Liran