Hello,
I use HS for connect Oracle with sybase in 8.1.7.4(working fine), i need migrate database to 9i, but i set same configuration use in 8.1.7 and no working in 9i.
With HS the connection working but i try compile procedure and error occurs:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][S1000] [9013]General error in nvITrans_Commit – rc = -1. Please refer to the log file for details.
ORA-02063: preceding 2 lines from HO.WORLD
the trace the hs:
Oracle Corporation — SUNDAY MAR 26 2006 03:21:44.343
Heterogeneous Agent Release
9.2.0.1.0
HS Agent received unexpected RPC disconnect
Network error 1003: NCR-01003: NCRS: Read error.
*******************
With Transparent gateway the connection no working, the error is:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ct_connect(): directory service layer: internal directory control layer error:
Requested server name not found.
ORA-02063: preceding 2 lines from TG4SYBS
The trace the Gateway is:
Oracle Corporation — MONDAY MAR 27 2006 18:59:14.906
Heterogeneous Agent Release
9.2.0.4.0
(0) [Transparent gateway for SYBASE] version: 3.3.00.00.0030
(0) connect string is: defTdpName=TG4SYBS;SYNTAX=(ORACLE8_HOA, BASED_ON=ORACLE8,
(0) IDENTIFIER_QUOTE_CHAR=””,
(0) CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=
(0)
(0)
(0) ct_connect(): directory service layer: internal directory control layer error:
(0) Requested server name not found.
(0) (Last message occurred 2 times)
(0)
(0) Closing log file at MON MAR 27 18:59:15 2006.
**********************
The content the lister.ora:
SID_LIST_LISTENER =
(SID_DESC =
(SID_NAME = ADSODBC)
(ORACLE_HOME = E:\oracle\product\920)
(PROGRAM = hsodbc)
)
(SID_DESC =
(SID_NAME = TG4SYBS)
(ORACLE_HOME = E:\oracle\product\920)
(PROGRAM = TG4SYBS)
)
)
**********************
The content the tnsnames is:
ADSODBC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.50.20)(PORT = 1521))
(CONNECT_DATA = (SID = ADSODBC))
(HS = OK)
)
tg4sybs =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.50.20)(PORT = 1521))
(CONNECT_DATA = (SID = tg4sybs))
(HS = OK)
)
**********************
The content the tg4sybs is:
HS_FDS_CONNECT_INFO=DTADS.ads
HS_FDS_TRACE_LEVEL=on
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
#
# Environment variables required for Sybase
#
set SYBASE=c:\\sybase
********************
The content the initadsodbc.ora is:
HS_FDS_CONNECT_INFO = ads
HS_FDS_TRACE_LEVEL = 0
********************
The System DSN “ads” is configurate and working fine(i testing. ok)
********************
The dblink are:
create public database link TG4SYBS
connect to SA
identified by “pass”
using ‘tg4sybs’;
create public database link HO.WORLD
connect to “sa”
identified by “pass”
using ‘adsodbc’;
All is configurate same working in 8i but no working in 9i, please help me.
I try with patch 9.2.0.1, 9.2.0.4, 9.2.0.5, 9.2.0.7.
Thanks you.