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

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

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

Posted by: li_chuansong
Posted on: 2003-07-28 12:27

1.配置LISTENER.ORA

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = qdgs-jk)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = f:\Oracle\Ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = oracle.qdgs)
(ORACLE_HOME = f:\Oracle\Ora81)
(SID_NAME = oracle)
)
#============================sidn_ame同inittg4msql.ora一致
(SID_DESC =
(SID_NAME = tg4msql)
(ORACLE_HOME = f:\Oracle\Ora81)
(PROGRAM = tg4msql)
)
)
#=====================
2.配置TNSNAMES.ORA(增加)
TG4MSQL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = qdgs-jk)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = tg4msql)
)
)
3.inittg4msql.ora
#文件名=init+sidn_ame
# HS init parameters
#
HS_FDS_CONNECT_INFO=qdgs_oa.oa_db
HS_FDS_TRACE_LEVEL=OFF