Oracle Gateway使用分享
1、安装服务器gateway，仅安装透明网关OS SERVER 2003 sp2，32位内存2g 硬盘空间50GB
透明网关版本11gr2 32位
2、配置监听
3、安装db2和as400客户端程序（提供数据库驱动文件）
4、配置odbc，并测试连接正常
5、添加并修改透明网关配置文件（文件位置在home目录下C:\product\11.2.0\tg_1\hs\admin ）
添加文件命名为init_sid.ora
注意点：sid和odbc中名称要一致
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = hisp
HS_FDS_TRACE_LEVEL = off
#
# Environment variables required for the non-Oracle system
#
#set =
6、修改tnsnames
C:\product\11.2.0\tg_1\NETWORK\ADMIN
HISP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gateway服务器ip)(PORT = 1521))
)
(CONNECT_DATA =
(SID = hisp)
)
(HS = OK)---------使用gateway方式连接
)
7、修改listener，并重启监听
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = hisp)
(ORACLE_HOME = C:\product\11.2.0\tg_1)
(SID_NAME = hisp)
(PROGRAM = dg4odbc)-----注意点：9i透明网关此处使用的程序为hs
)
)
此时gateway服务器已配置完成
页:
[1]