sql server and oracle stady

imlihj2007發表於2008-01-17

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)
)

[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9879835/viewspace-997573/,如需轉載,請註明出處,否則將追究法律責任。

相關文章