1.安装
1).下载Oracle Gateways组建10201_gateways_win32.zip
2).安装覆盖原有的ORACLE_HOME目录，选择
Oracle Transparent Gateway for Sybase 10.2.0.1.0
3).输入主机名和数据库名。

2.配置gateways实例参数文件
$ORACLE_HOME/tg4sybs/admin/inittg4sybs.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for the Transparent Gateway for Sybase

#
# HS init parameters
#
HS_FDS_CONNECT_INFO=LD_YS
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

#
# Environment variables required for Sybase
#
set SYBASE="C:\\sybase"

注意：
HS_FDS_CONNECT_INFO=server_name.database_name[,INTERFACE=interface_file]
1).要在本地通过"Desedit Utility"工具配置连接Sybase服务器的Server Name。
配置好后，文件C:\sybase\ini\sql.ini：
############################
[LD_YS]
master=TCP,192.166.1.13,7000
query=TCP,192.166.1.13,7000

[LD_SS]
master=TCP,192.166.1.13,7000
query=TCP,192.166.1.13,7000
############################
server_name名称就是通过"Desedit Utility"工具配置好的Server Name(sql.ini中配置的server_name)。
Oracle文档中要求配置database_name,实际上是不需要配置的。
server_name不是主机名也不是Sybase服务器的ip地址，不需要配置hosts文件绑定ip。
2).set SYBASE="Sybase的安装目录"

3.配置监听
$ORACLE_HOME/network/admin/listener.ora
SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC=
      (SID_NAME=tg4sybs)
      (ORACLE_HOME=E:\oracle\product\10.2.0\db_1)
      (PROGRAM=tg4sybs)
    )
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = lsdlgs)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
)

重启监听器。

4.配置服务名
$ORACLE_HOME/network/admin/tnsnames.ora
tg4sybs =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = lsdlgs)(PORT = 1521))
    (CONNECT_DATA =
      (SID = tg4sybs)
    )
    (HS = OK)
)

5.创建DATABASE LINK
SQL> create public database link testdblink connect to "try" identified by "111111" using 'tg4sybs';

Database link created.
SQL> select * from "aaaa"@testdblink;

a
----------
1111

注意：
由于Sybase中是严格区分大小写，所以用户名、密码和表名都需要严格大小写并且加上双引号。

ITPub博客

通过Oracle Gateways 访问Sybase

最新文章