在已装有Oracle DB 10gR2的windows 环境下安装 gateway 11g for sybase
1.建立安装目录
2.使用OUI安装
注意：win7下安装要使用管理员身份、兼容模式运行程序，否则会报“程序异常终止”的错误。
注意：由于数据库版本与gateway版本不同，因此不能在原oracle_home目录下安装gateway，要使用新目录，否则bin下的程序会被覆盖，导致oracle软件不可用。
此处是配置监听，由于我之前配置了，因此不在这里配置。这里配置失败的原因是环境变量oracle_home没有设置为gateway的安装目录，如果安装之前设置成功则该步不会失败，并配置成功新的监听。
3.确认或修改HS初始话参数文件initdg4sybs.ora
# This isa customized agent init file that contains the HS parameters
# thatare needed for the Database Gateway for Sybase
#
# HS initparameters
#
HS_FDS_CONNECT_INFO=[192.168.131.57]:4100/ssdd
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
这个是我们之前安装gateway写的sybase数据库连接信息，如果当初没有写错，则无需修改，忽略此步。
4.修改监听，增加静态监听服务
#listener.ora Network Configuration File: F:\app\NETWORK\ADMIN\listener.ora
#Generated by Oracle configuration tools.
SID_LIST_LISTENER=
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\app)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = shdb)
(ORACLE_HOME = F:\app)
(SID_NAME = shdb)
)
(SID_DESC =
(SID_NAME =dg4sybs) --与initdg4sybs.ora一致
(ORACLE_HOME =F:\gateway) --gateway安装目录（bin的上级目录）
(PROGRAM = F:\gateway\BIN\dg4sybs.exe)
--windows下是exe类型文件，必须加上全路径！
)
)
LISTENER=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =xqwu)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY =EXTPROC0))
)
)
ADR_BASE_LISTENER = F:\app
配置好之后，重启监听
注意：环境变量path中，oracle_home所在的bin路径必须放在最前面，否则会报错。
5.配置tnsnames.ora
--加入以下内容
dg4sybs =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xqwu)(PORT=1521))
(CONNECT_DATA=(SID=dg4sybs))
(HS=OK)
)
--用 tnsping dg4sybs测试一下：
C:\Windows\system32>tnsping dg4sybs
TNS PingUtility for 32-bit Windows: Version 10.2.0.1.0 - Production on 11-JUN-201411:29:06
Copyright(c) 1997, 2005, Oracle. All rightsreserved.
Usedparameter files:
UsedTNSNAMES adapter to resolve the alias
Attemptingto contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=xqwu)(PORT=1521))(CONNECT_DATA=(SID=dg4sybs)) (HS=OK))
OK (30msec)
6.建立db_link
CREATE DATABASELINK sybase_ssdd_linkCONNECTTO"sa" IDENTIFIED BY" "USING 'dg4sybs'
7.测试
select count(*)from"XQW_ERROR_INFO"@sybase_ssdd_link;
COUNT(*)
----------
140928
1 row selected.
成功！
8.建立新的sybase数据库连接
1.新建initdg4sybs2.ora
# This isa customized agent init file that contains the HS parameters
# thatare needed for the Database Gateway for Sybase
#
# HS initparameters
#
HS_FDS_CONNECT_INFO=[192.168.131.57]:4100/amtrix
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
2.新增tns服务
dg4sybs2 =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=xqwu)(PORT=1521))
(CONNECT_DATA=(SID=dg4sybs2)) --与initdg4sybs2.ora一致
(HS=OK)
)
3.修改并重启listener
SID_LIST_LISTENER=
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:\app)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = shdb)
(ORACLE_HOME = F:\app)
(SID_NAME = shdb)
)
(SID_DESC =
(SID_NAME = dg4sybs)
(ORACLE_HOME = F:\gateway)
(PROGRAM = F:\gateway\BIN\dg4sybs.exe)
)
(SID_DESC =
(SID_NAME =dg4sybs2) --与initdg4sybs2.ora一致
(ORACLE_HOME =F:\gateway)
(PROGRAM =F:\gateway\BIN\dg4sybs.exe)
)
)
4.建立db_link
CREATE DATABASELINK sybase_amtrix_linkCONNECTTO "sa"IDENTIFIEDBY" " USING 'dg4sybs2';
5.测试
select * from "test"@sybase_amtrix_link;
id
---------------
3
1 row selected.
成功！
Sharon
2014.06.12
----------------------------------------------------------------------------------------------
转载须注明出处！
http://blog.csdn.net/sharqueen_wu/article/details/30238743
转载须注明出处！
http://blog.csdn.net/sharqueen_wu/article/details/30238743
转载须注明出处！
http://blog.csdn.net/sharqueen_wu/article/details/30238743