| gateway for drda(db2udb8.1) ora-28527 [message #339024] |
Wed, 06 August 2008 10:21  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
