Home » RDBMS Server » Networking and Gateways » gateway for drda(db2udb8.1) ora-28527 (Oracle 10G,DB2UDB8.1,WinXP)
gateway for drda(db2udb8.1) ora-28527 [message #339024] Wed, 06 August 2008 10:21 Go to next message
keelin
Messages: 3
Registered: July 2007
Junior Member
Follow the oracle document,I configured some profiles.
But when I ran the command "exec GTW$_BIND_PKG@home"
the error "ORA-28527: Heterogeneous Services datatype mapping error" appeared
I have spent much time going to handle this error,but still do not resolve this erroe .

Here is what I have tried

The environment
1)Windows XP+oracle 10.2.0.1.0 SID:wahaha IP:192.168.1.110
2)Windows XP+GateWay For Drda IP:192.168.1.100
3)Windows XP+db2udb8.1 db_name:SAMPLE IP:192.168.1.110

==========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
=========================================

=================listener.ora============
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\tg_1\network\admin\listener.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_server tnsnames.ora========
# tnsnames.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

WAHAHA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WWW-EF3DD945768)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = wahaha)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


HOME=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=192.168.1.100)
(PORT=1522)
)
(CONNECT_DATA=
(SID=home))
(HS= ))
==========================================

=============Database Link================
create public database link home
connect to back identified back using 'HOME';
/*back is the administrator of DB2,
and I have run g4ddtab.sql and g4ddvwu8.sql on DB2 successfully.
*/
==========================================



Now when I issue the following :
sql>exec GTW$_BIND_PKG@home;

I will get the error as
ORA-28527: Heterogeneous Services datatype mapping error

please help me out where I am wrong,thanks in advance


keelin




Re: gateway for drda(db2udb8.1) ora-28527 [message #341609 is a reply to message #339024] Tue, 19 August 2008 09:13 Go to previous message
keelin
Messages: 3
Registered: July 2007
Junior Member
oh,no!help me~~~
Previous Topic: Interface between Oracle and SQL Server databases
Next Topic: Problem Oracle Listner.log
Goto Forum:
  


Current Time: Sun Oct 26 05:00:01 CDT 2014

Total time taken to generate the page: 0.09845 seconds