trouble creating db link from oracle 10.2.0.1 to sybase anywhere.
849617Mar 23 2011 — edited Mar 28 2011Hi
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