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

Topic: 通过oracle透明网关连接其他数据库(sybase)

1.通过oracle透明网关连接其他数据库(sybase)

Posted by: li_chuansong
Posted on: 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)
)
)