Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

trouble creating db link from oracle 10.2.0.1 to sybase anywhere.

849617Mar 23 2011 — edited Mar 28 2011
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2011
Added on Mar 23 2011
16 comments
1,398 views