ITPUB论坛 » Oracle入门与认证 » 【求助】透明网关for db2的配置问题
2008-8-5 10:41
mamamiya5613
【求助】透明网关for db2的配置问题
gateway for drda(db2udb8.1)提问
最近在做oracle异构数据库相连的实验,用到了oracle的gateway(透明网关)
按照oracle的官方文档配置,并测试连接,报错：ORA-28527: 多机种服务数据类型映射错误
google无果，特此来向高手请教，该如何搞
db2的版本环境 ： Windows+db2udb8.1 db2数据库名称为SAMPLE,端口50000
oracle server的版本环境: Windows+10.2.0.1.0 ，监听端口为1521
gateway与oracle在同一台机器上,版本为10.2.0.1.0，监听端口为1522
配置initsid.ora-->inithome.ora
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#
# HS specific parameters
#
FDS_CLASS=TG4DRDA_DB2UDB
#TRACE_LEVEL=255
#LOG_DESTINATION=DB2.log
#ORACLE_DRDA_TCTL=debug.tctl
HS_COMMIT_POINT_STRENGTH=255
HS_NLS_DATE_FORMAT=YYYY-MM-DD
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
HS_RPC_FETCH_REBLOCKING=off
HS_RPC_FETCH_SIZE=32767
HS_FDS_FETCH_ROWS=20
#
# DRDA specific parameters
#
DRDA_CONNECT_PARM=192.168.1.110:50000
DRDA_REMOTE_DB_NAME=SAMPLE
DRDA_PACKAGE_COLLID=ORACLE
DRDA_PACKAGE_NAME=G2DRSQL
DRDA_PACKAGE_CONSTOKEN=A92617CB3FE54701
DRDA_RECOVERY_USERID=ORADRDA
DRDA_RECOVERY_PASSWORD=ORADRDA
DRDA_ISOLATION_LEVEL=CS
#DRDA_PACKAGE_OWNER=ORADRDA
#DRDA_DISABLE_CALL=TRUE
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
配置gateway的listener.ora
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
# listener.ora Network Configuration File: D: oracle product 10.2.0 tg_1
etworkadminlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D: oracle product 10.2.0 tg_1)
(PROGRAM = extproc)
)
(SID_DESC=
(SID_NAME=home)
(ORACLE_HOME = D: oracle product 10.2.0 tg_1)
(PROGRAM=g4drsrv)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = kngsshalp1748a.internal.sungard.corp)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
配置oracle_sever的tnsnames.ora,在原来的基础上增加如下数据行
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
HOME1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = kngsshalp1748a.internal.sungard.corp)(PORT = 1522))
(CONNECT_DATA =
(SID = home)
)
(HS = )
)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
db2方面我建立了两个个新帐号HA，OTGDB2
HA是用于访问db2数据库的,我把db2该有的权限都给他了
create public database link home connect to HA identified by HA suing 'HOME1'
(该用户下已经创建了HA.ORACLE2PC表)
OTGDB2,我也把db2该有的权限都给他了
OTGDB2是按照oracle gateway的官方文档,用来运行g4ddtab.sql和g4ddvwu8.sql,创建字典表和试图的
现在我一运行绑定包的语句
exec GTW$_BIND_PKG@home
就报:
ORA-28527: 多机种服务数据类型映射错误
那位搞过这个连接db2透明网关的大侠,指点一下小弟吧
在此先谢过了
gateway for drda(db2udb8.1)提问
最近在做oracle异构数据库相连的实验,用到了oracle的gateway(透明网关)
按照oracle的官方文档配置,并测试连接,报错：ORA-28527: 多机种服务数据类型映射错误
google无果，特此来向高手请教，该如何搞
db2的版本环境 ： Windows+db2udb8.1 db2数据库名称为SAMPLE,端口50000
oracle server的版本环境: Windows+10.2.0.1.0 ，监听端口为1521
gateway与oracle在同一台机器上,版本为10.2.0.1.0，监听端口为1522
配置initsid.ora-->inithome.ora
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#
# HS specific parameters
#
FDS_CLASS=TG4DRDA_DB2UDB
#TRACE_LEVEL=255
#LOG_DESTINATION=DB2.log
#ORACLE_DRDA_TCTL=debug.tctl
HS_COMMIT_POINT_STRENGTH=255
HS_NLS_DATE_FORMAT=YYYY-MM-DD
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
HS_RPC_FETCH_REBLOCKING=off
HS_RPC_FETCH_SIZE=32767
HS_FDS_FETCH_ROWS=20
#
# DRDA specific parameters
#
DRDA_CONNECT_PARM=192.168.1.110:50000
DRDA_REMOTE_DB_NAME=SAMPLE
DRDA_PACKAGE_COLLID=ORACLE
DRDA_PACKAGE_NAME=G2DRSQL
DRDA_PACKAGE_CONSTOKEN=A92617CB3FE54701
DRDA_RECOVERY_USERID=ORADRDA
DRDA_RECOVERY_PASSWORD=ORADRDA
DRDA_ISOLATION_LEVEL=CS
#DRDA_PACKAGE_OWNER=ORADRDA
#DRDA_DISABLE_CALL=TRUE
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
配置gateway的listener.ora
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
# listener.ora Network Configuration File: D: oracle product 10.2.0 tg_1
etworkadminlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D: oracle product 10.2.0 tg_1)
(PROGRAM = extproc)
)
(SID_DESC=
(SID_NAME=home)
(ORACLE_HOME = D: oracle product 10.2.0 tg_1)
(PROGRAM=g4drsrv)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = kngsshalp1748a.internal.sungard.corp)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
配置oracle_sever的tnsnames.ora,在原来的基础上增加如下数据行
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
HOME1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = kngsshalp1748a.internal.sungard.corp)(PORT = 1522))
(CONNECT_DATA =
(SID = home)
)
(HS = )
)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
db2方面我建立了两个个新帐号HA，OTGDB2
HA是用于访问db2数据库的,我把db2该有的权限都给他了
create public database link home connect to HA identified by HA suing 'HOME1'
(该用户下已经创建了HA.ORACLE2PC表)
OTGDB2,我也把db2该有的权限都给他了
OTGDB2是按照oracle gateway的官方文档,用来运行g4ddtab.sql和g4ddvwu8.sql,创建字典表和试图的
现在我一运行绑定包的语句
exec GTW$_BIND_PKG@home
就报:
ORA-28527: 多机种服务数据类型映射错误
那位搞过这个连接db2透明网关的大侠,指点一下小弟吧
在此先谢过了
2008-8-5 17:38
mamamiya5613
每天一顶,好心的大侠指导下小弟吧
2008-8-5 21:45
football2006
帮你顶
2008-8-6 15:32
mamamiya5613
谢谢楼上,每日一顶
2008-8-6 17:28
apcbzxy
帮楼主顶了,顺便学习
2008-8-6 22:39
总不行
不好意思，我也不懂哦~
2008-8-6 22:39
总不行
以后多了解再说了
2008-8-8 14:22
mamamiya5613
哎 已经一个星期了 文档都看烂了要 我错在哪里啊~~~哭鸟
2008-9-13 10:31
begin2007
[quote]原帖由 [i]mamamiya5613[/i] 于 2008-8-5 10:41 发表 [url=http://www.itpub.net/redirect.php?goto=findpost&pid=11163148&ptid=1033289][img]http://www.itpub.net/images/common/back.gif[/img][/url]
gateway for drda(db2udb8.1)提问
最近在做oracle异构数据库相连的实验,用到了oracle的gateway(透明网关)
按照oracle的官方文档配置,并测试连接,报错：ORA-28527: 多机种服务数据类型映射错误
google无果，特此来向高手请教，该如何搞
db2的版本环境 ： Windows+db2udb8.1 db2数据库名称为SAMPLE,端口50000
oracle server的版本环境: Windows+10.2.0.1.0 ，监听端口为1521
gateway与oracle在同一台机器上,版本为10.2.0.1.0，监听端口为1522
配置initsid.ora-->inithome.ora
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#
# HS specific parameters
#
FDS_CLASS=TG4DRDA_DB2UDB
#TRACE_LEVEL=255
#LOG_DESTINATION=DB2.log
#ORACLE_DRDA_TCTL=debug.tctl
HS_COMMIT_POINT_STRENGTH=255
HS_NLS_DATE_FORMAT=YYYY-MM-DD
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
HS_RPC_FETCH_REBLOCKING=off
HS_RPC_FETCH_SIZE=32767
HS_FDS_FETCH_ROWS=20
#
# DRDA specific parameters
#
DRDA_CONNECT_PARM=192.168.1.110:50000
DRDA_REMOTE_DB_NAME=SAMPLE
DRDA_PACKAGE_COLLID=ORACLE
DRDA_PACKAGE_NAME=G2DRSQL
DRDA_PACKAGE_CONSTOKEN=A92617CB3FE54701
DRDA_RECOVERY_USERID=ORADRDA
DRDA_RECOVERY_PASSWORD=ORADRDA
DRDA_ISOLATION_LEVEL=CS
[color=DarkRed]HS_DB_NAME设置了吗？？[/color]
#DRDA_PACKAGE_OWNER=ORADRDA
#DRDA_DISABLE_CALL=TRUE
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
配置gateway的listener.ora
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
# listener.ora Network Configuration File: D: oracle product 10.2.0 tg_1
etworkadminlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D: oracle product 10.2.0 tg_1)
(PROGRAM = extproc)
)
(SID_DESC=
(SID_NAME=home)
(ORACLE_HOME = D: oracle product 10.2.0 tg_1)
(PROGRAM=g4drsrv)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = kngsshalp1748a.internal.sungard.corp)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
配置oracle_sever的tnsnames.ora,在原来的基础上增加如下数据行
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
HOME1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = kngsshalp1748a.internal.sungard.corp)(PORT = 1522))
(CONNECT_DATA =
(SID = home)
)
(HS = [color=Red])//这里应该是(HS = OK)[/color] )
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
db2方面我建立了两个个新帐号HA，OTGDB2
HA是用于访问db2数据库的,我把db2该有的权限都给他了
create public database link home connect to HA identified by HA suing 'HOME1'
(该用户下已经创建了HA.ORACLE2PC表)
OTGDB2,我也把db2该有的权限都给他了
OTGDB2是按照oracle gateway的官方文档,用来运行g4ddtab.sql和g4ddvwu8.sql,创建字典表和试图的
现在我一运行绑定包的语句
exec GTW$_BIND_PKG@home
就报:
ORA-28527: 多机种服务数据类型映射错误
那位搞过这个连接db2透明网关的大侠,指点一下小弟吧
在此先谢过了 [/quote]
gateway for drda(db2udb8.1)提问
最近在做oracle异构数据库相连的实验,用到了oracle的gateway(透明网关)
按照oracle的官方文档配置,并测试连接,报错：ORA-28527: 多机种服务数据类型映射错误
google无果，特此来向高手请教，该如何搞
db2的版本环境 ： Windows+db2udb8.1 db2数据库名称为SAMPLE,端口50000
oracle server的版本环境: Windows+10.2.0.1.0 ，监听端口为1521
gateway与oracle在同一台机器上,版本为10.2.0.1.0，监听端口为1522
配置initsid.ora-->inithome.ora
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#
# HS specific parameters
#
FDS_CLASS=TG4DRDA_DB2UDB
#TRACE_LEVEL=255
#LOG_DESTINATION=DB2.log
#ORACLE_DRDA_TCTL=debug.tctl
HS_COMMIT_POINT_STRENGTH=255
HS_NLS_DATE_FORMAT=YYYY-MM-DD
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1
HS_RPC_FETCH_REBLOCKING=off
HS_RPC_FETCH_SIZE=32767
HS_FDS_FETCH_ROWS=20
#
# DRDA specific parameters
#
DRDA_CONNECT_PARM=192.168.1.110:50000
DRDA_REMOTE_DB_NAME=SAMPLE
DRDA_PACKAGE_COLLID=ORACLE
DRDA_PACKAGE_NAME=G2DRSQL
DRDA_PACKAGE_CONSTOKEN=A92617CB3FE54701
DRDA_RECOVERY_USERID=ORADRDA
DRDA_RECOVERY_PASSWORD=ORADRDA
DRDA_ISOLATION_LEVEL=CS
[color=DarkRed]HS_DB_NAME设置了吗？？[/color]
#DRDA_PACKAGE_OWNER=ORADRDA
#DRDA_DISABLE_CALL=TRUE
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
配置gateway的listener.ora
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
# listener.ora Network Configuration File: D: oracle product 10.2.0 tg_1
etworkadminlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D: oracle product 10.2.0 tg_1)
(PROGRAM = extproc)
)
(SID_DESC=
(SID_NAME=home)
(ORACLE_HOME = D: oracle product 10.2.0 tg_1)
(PROGRAM=g4drsrv)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = kngsshalp1748a.internal.sungard.corp)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
配置oracle_sever的tnsnames.ora,在原来的基础上增加如下数据行
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
HOME1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = kngsshalp1748a.internal.sungard.corp)(PORT = 1522))
(CONNECT_DATA =
(SID = home)
)
(HS = [color=Red])//这里应该是(HS = OK)[/color] )
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
db2方面我建立了两个个新帐号HA，OTGDB2
HA是用于访问db2数据库的,我把db2该有的权限都给他了
create public database link home connect to HA identified by HA suing 'HOME1'
(该用户下已经创建了HA.ORACLE2PC表)
OTGDB2,我也把db2该有的权限都给他了
OTGDB2是按照oracle gateway的官方文档,用来运行g4ddtab.sql和g4ddvwu8.sql,创建字典表和试图的
现在我一运行绑定包的语句
exec GTW$_BIND_PKG@home
就报:
ORA-28527: 多机种服务数据类型映射错误
那位搞过这个连接db2透明网关的大侠,指点一下小弟吧
在此先谢过了 [/quote]
2008-9-13 11:14
begin2007
回复 #1 mamamiya5613 的帖子
昨天上午没事尝试配置linux oracle11g for db2透明网关，没遇到什么问题。
db2数据库名是test，建dblink用的是以前建的用户，db2数据库用户给管理员的权限（自己玩玩的不考虑安全方面的东西）
大概过程如下：
1、先安装对应的透明网关组件
2、initudb.ora-->inittest.ora，主要修改下面几个参数
DRDA_CONNECT_PARM=db2数据库ip:端口
DRDA_REMOTE_DB_NAME=test
HS_DB_NAME＝test
3、listener.ora文件增加
(SID_DESC=
(SID_NAME=test)
(ORACLE_HOME = 设置为$ORACLE_HOME)
(PROGRAM=g4drsrv)
)
4、tnsnames.ora
gatewaydb2=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle数据库主机ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
(HS = OK)
)
5、创建dblink和执行绑定包
官方文档上说的脚本我没有执行，但这样配置执行简单的select语句没问题的
昨天上午没事尝试配置linux oracle11g for db2透明网关，没遇到什么问题。
db2数据库名是test，建dblink用的是以前建的用户，db2数据库用户给管理员的权限（自己玩玩的不考虑安全方面的东西）
大概过程如下：
1、先安装对应的透明网关组件
2、initudb.ora-->inittest.ora，主要修改下面几个参数
DRDA_CONNECT_PARM=db2数据库ip:端口
DRDA_REMOTE_DB_NAME=test
HS_DB_NAME＝test
3、listener.ora文件增加
(SID_DESC=
(SID_NAME=test)
(ORACLE_HOME = 设置为$ORACLE_HOME)
(PROGRAM=g4drsrv)
)
4、tnsnames.ora
gatewaydb2=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle数据库主机ip)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
(HS = OK)
)
5、创建dblink和执行绑定包
官方文档上说的脚本我没有执行，但这样配置执行简单的select语句没问题的
页: [1]
查看完整版本: 【求助】透明网关for db2的配置问题
Powered by ITPUB论坛