Java开发网 - 通过oracle透明网关连接其他数据库(sybase)

Java开发网

您没有登录

» Java开发网 » Database/JDBC/SQL/JDO/Hibernate

打印话题 寄给朋友 订阅主题

作者

通过oracle透明网关连接其他数据库(sybase) [精华]

li_chuansong

发贴: 55
积分: 21

于 2003-07-22 16:44

要求：oracle必须装tg4选项，8i需下载tg4,9i默认安装时没装tg4
安装结束后需配置文件内容如下：
---------------------------------------------------------------------------
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=QDGS-LCS.master
HS_FDS_TRACE_LEVEL=ON
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER

#
# Environment variables required for Sybase
#
set SYBASE=C:\\Sybase
set LD_LIBRARY_PATH=C:\Sybase\lib
---------------------------------------------------------------------------
listener.ora
# LISTENER.ORA Network Configuration File: D:\oracle\ora90\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = qdgs-lcs)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = tg4sybs)
(ORACLE_HOME = d:\oracle\ora90)
(PROGRAM = tg4sybs)
)
(SID_DESC =
(GLOBAL_DBNAME = study)
(ORACLE_HOME = D:\oracle\ora90)
(SID_NAME = study)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora90)
)
)

-----------------------------------------------------------------
tnsnames.ora

# TNSNAMES.ORA Network Configuration File: D:\oracle\ora90\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

tg4sybs =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = qdgs-lcs)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4sybs)
)
(HS = OK)
)

STUDY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = qdgs-lcs)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = study)
)
)

九佰 edited on 2003-07-24 10:39

• JAVA学习日子分享

话题树型展开

人气	标题	作者	字数	发贴时间
8264	[精华] 通过oracle透明网关连接其他数据库(sybase)	li_chuansong	1975	2003-07-22 16:44

已读帖子

新的帖子

被删除的帖子