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
|