一、配置透明网关sqlserver
1、initdg4msql文件中参数:HS_FDS_CONNECT_INFO=[服务地址:端口]/实例名/数据库名 (其中端口,实例名可以忽略,报错注意实例名)
2、配置中gateway与oracle中监听都需要配置成对,gateway中监听ORACLE_HOME为本身安装目录
3、步骤:
a>安装gateway
b>安装目录配置监听
LISTENER_GW =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
)
SID_LIST_LISTENER_GW =
(SID_LIST =
(SID_DESC =
(PROGRAM = dg4msql)
(SID_NAME = dg4msql) //为dg4mysql目录中init**的**名称//
(ORACLE_HOME = gateway安装目录)
)
)
c>安装目录配置服务名\dg4msql\admin中initdg4msql.ora配置
HS_FDS_CONNECT_INFO=[服务器IP]//数据库用户名
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
d>oracle_home中配置监听,要成对出现
LISTENER_GW =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=(SID_NAME=dg4msql)
(ORACLE_HOME=oracle_home目录)
(PROGRAM=dg4msql))
)
e>oracle_home中配置连接串tns名称
dg4msql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = dg4msql)
)
(HS = OK) //必须要加
)
f>启动监听
h>创建dblink(大小写敏感,双引号引起来)
二、mysql配置透明网关(同上,安装文件配置目录不一样)
1、配置ODBC数据源
2、安装目录hs文件夹下配置连接(odbc数据源的名称)
3、配置监听(监听中sid为安装目录hs文件夹下init**中的**)
4、配置服务名
5、建立DBLINK(大小写敏感,双引号引起来)