1,install the sql server gataway
2,$oracle_home/tg4msql/admin/inittg4msql.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for the Transparent Gateway for SQL Server
#
# HS init parameters
#
HS_FDS_CONNECT_INFO="SERVER=192.168.0.47;DATABASE=pubs"
HS_FDS_TRACE_LEVEL=ON
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
3,update then file:$oracle_home/network/admin/listner.ora
# LISTENER.ORA Network Configuration File: d:oracleora92NETWORKADMINlistener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = lkhuasof-lihj)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = tg4msql)
(PROGRAM = tg4msql)
(ORACLE_HOME = D:oracleora92)
(SID_NAME = tg4msql)
)
(SID_DESC =
(GLOBAL_DBNAME = oralihj)
(ORACLE_HOME = d:oracleora92)
(SID_NAME = oralihj)
)
)
4,update then file:$oracle_home/network/admin/tsnames.ora
tg4msql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =lkhuasof-lihj)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4msql)
(SERVER = DEDICATED)
)
(HS=OK)
)
