10g透明网关的配置
1、下载gateways目录，安装，因为开始装了10.2.0.1.0，所以要选择另外一个目录安装。我这里安装在g盘
2、配置远程数据库连接文件，在G: oracle product 10.2.0 tg_1tg4msql admin下的inittg4msql.ora，分别连接两个库，所以配置了两个相应的文件，文件名里用的是对应的listener.ora里的sid，两个文件分别为，initsql2000.ora和inittest.ora
3、配置listener.ora和tnsnames.ora，在listener.ora里SID_LIST_LISTENER =小节里面加上下面的两段，注意oracle_home的地址：
SID_LIST_LISTENER =
(SID_DESC =
(GLOBAL_DBNAME = tg4msql)
(PROGRAM = tg4msql)
(SID_NAME = sql2000)
(ORACLE_HOME = F:oracleproduct10.2.0db_1)
)
(SID_DESC =
(GLOBAL_DBNAME = tg4msql)
(PROGRAM = tg4msql)
(SID_NAME = test)
(ORACLE_HOME = F:oracleproduct10.2.0db_1)
)
在tnsnames.ora里加上：
sql =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wen)(PORT = 1521))
)
(CONNECT_DATA =
(SID = sql2000)
)
(HS = OK)
)
sql1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = wen)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
)
(HS = OK)
)
4、在oracle模式里面建立相应的dblinks，我这里分别建立了
create public database link dblink connect to wen identified by wen using 'sql';
create public database link dblink1 connect to wen identified by wen using 'sql1';
5、tnsping sql及tnsping sql1检查配置的正确行
6、进行数据查询测试
select count(*) from t1@dblink1;
COUNT(*)
----------
3
SQL>
注意：启动的lsnrctl的路径，因为使用lsnrctl其所使用的参数多是对应目录的sqlnet.ora和listener.ora，所以别弄错了。