点击上方蓝字关注我们
因业务需要oracle到db2取数据，使用透明网关实现。
gateway安装目录：/oracle/oracle/product/12.1.0/gateway
红色部分需要修改（安装时已经配置）
目录：/oracle/oracle/product/12.1.0/gateway/dg4db2/admin
oracle@oracle12c01:/oracle/oracle/product/12.1.0/gateway/dg4db2/admin> cat initdg4db2.ora
# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for DB2
#
# HS init parameters
#
HS_FDS_CONNECT_INFO=[XX.XX.XX.XX]:XXXX/BASS_DM,LUW
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
HS_TRANSACTION_MODEL=COMMIT_CONFIRM
HS_FDS_TRANSACTION_ISOLATION=READ_COMMITTED
HS_FDS_SUPPORT_STATISTICS=TRUE
HS_FDS_RESULTSET_SUPPORT=FALSE
HS_FDS_PACKAGE_COLLID=ORACLEGTW
HS_IDLE_TIMEOUT=0
目录：/oracle/oracle/product/12.1.0/gateway/network/admin
SID_NAME就是前面init.ora文件名里指定的SID
SID_LIST_LISTENER_GW =
(SID_LIST =
(SID_DESC =
(SID_NAME = dg4db2)
(ORACLE_HOME=/oracle/oracle/product/12.1.0/gateway)
(ENV="LD_LIBRARY_PATH=/oracle/oracle/product/12.1.0/gateway/dg4db2/driver/lib:/oracle/oracle/product/12.1.0/gateway/lib")
(PROGRAM = dg4db2)
)
)
LISTENER_GW =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT = 1512))
)
)
--启动监听
export ORACLE_HOME=/oracle/oracle/product/12.1.0/gateway
export TNS_ADMIN=/oracle/oracle/product/12.1.0/gateway/network/admin
cd /oracle/oracle/product/12.1.0/gateway/bin
lsnrctl start LISTENER_GW
目录：/oracle/oracle/product/12.1.0/gateway/dg4db2/admin
dg4db2 =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=XX.XX.XX.XX)(PORT=1512))
(CONNECT_DATA=(SID=dg4db2))
(HS=OK)
)
--测试是否成功
tnsping dg4db2
CREATE DATABASE LINK db2
CONNECT TO db2user IDENTIFIED BY XXXXXX USING 'dg4db2';
Select count(*) from area@db2;
select count(*) from bb.tb_XXXX@db2;
