Setup Heterogeneous Service
Server (Sybase) requirements:
Add an ODBC entry in System DSN tab, make sure connection test is successful #Be aware of 32/64 bit of ODBC driver, in this example odbcSYB as DSN (Data Source Name) is named.
Install Oracle 11g database software only on Sybase server.
#Create Oracle HS init file
$ORACLE_HOME/hs/admin/initodbcSYB.ora
HS_FDS_CONNECT_INFO = odbcSYB
HS_FDS_TRACE_LEVEL = off
#Link HS SID in listener.ora
$ORACLE_HOME/network/admin/listener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=odbcSYB)
(ORACLE_HOME=C:\oracle\product\11.1.0\db_1)
(PROGRAM=DG4ODBC)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SYB_SERVER)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
#Restart Listener
Client requirements:
tnsnames.ora
odbcSYB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = SYB_SERVER)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = odbcSYB)
)
(HS=OK)
)
database link
create database link odbcSYB
connect to “sa” identified by “1234”
using ‘odbcSYB‘;
global_names
global_names has to set to FALSE
network connectivity
A port connectivity needs to be opened bi-directional between client and server for listener, default is 1521.