谁能明白这里面的痛(透明网关),折腾了好几天,试了很多方法,环境有限只能在现有的环境上做测试。
源端数据库:sql anywhere 10
目标端数据库:oracle 10.2.0.4
透明网关:oracle 11.2.0.1
11g报错:
SQL> select * from dual@dg4sybs;
select * from dual@dg4sybs
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC Sybase Wire Protocol driver][Sybase ASE]SQL Anywhere -265:
'sp_server_info' {HY000,NativeErr = 504}
ORA-02063: preceding 2 lines from DG4SYBS
Oracle Corporation --- 星期四 1月 05 2017 14:36:40.263
Heterogeneous Agent Release
11.2.0.1.0
Oracle Corporation --- 星期四 1月 05 2017 14:36:40.263
Version 11.2.0.1.0
HOSGIP for "HS_FDS_TRACE_LEVEL" returned "ON"
RC=-1 from HOSGIP for "PATH"
PATH from environment is "D:\product\11.2.0\tg_1\bin;D:\oracle\product\10.2.0\tg_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;D:\sybase\win32;D:\sybase\Sybase Central 5.0.0\win32"
Setting PATH to "D:\product\11.2.0\tg_1\dg4sybs\driver\lib;D:\product\11.2.0\tg_1\bin;D:\oracle\product\10.2.0\tg_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;D:\sybase\win32;D:\sybase\Sybase Central 5.0.0\win32"
HOSGIP for "HS_OPEN_CURSORS" returned "50"
HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
HOSGIP for "HS_FDS_CHARACTER_SEMANTICS" returned "FALSE"
HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
using song as default value for "HS_FDS_DEFAULT_OWNER"
HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
hgocont, line 2753: calling SqlDriverConnect got sqlstate HY000
10g报错:
Oracle Corporation --- 星期三 1月 04 2017 17:36:33.339
Heterogeneous Agent Release
10.2.0.1.0
(0) [Transparent gateway for SYBASE] version: 4.6.1.0.0070
(0) connect string is: defTdpName=tg4sybs;SYNTAX=(ORACLE8_HOA, BASED_ON=ORACLE8,
(0) IDENTIFIER_QUOTE_CHAR="",
(0) CASE_SENSITIVE=CASE_SENSITIVE_QUOTE);BINDING=<navobj><binding><datasources><da-
(0) tasource name='tg4sybs' type='SYBASE'
(0) connect='10.10.12.15.ltest'><driverProperties/></datasource></datasources><rem-
(0) oteMachines/><environment><optimizer noFlattener='true'/><misc
(0) year2000Policy='-1' consumerApi='1' sessionBehavior='4'/><queryProcessor
(0) parserDepth='2000' tokenSize='1000' noInsertParameterization='true'
(0) noThreadedReadAhead='true'/></environment></binding></navobj>
(0) ORACLE SYBASE GATEWAY Log File Started at 2017-01-04T17:36:33
(0) 找不到指定的模块。
; at FIND_IMAGE_SYMBOL
(0) [C079] Failed to load dynamic library 'hsdbsyb'
(0) PATH =
(0) D:\oracle\product\10.2.0\tg_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\Sy-
(0) stem32\Wbem
(0) [C077] Could not find symbol 'SYBASE' in dynamic library
(0) 找不到指定的模块。
; at FIND_IMAGE_SYMBOL
[C079] Failed to load dynamic
(0) library 'hsdbsyb'
PATH =
(0) D:\oracle\product\10.2.0\tg_1\bin;C:\Windows\system32;C:\Windows;C:\Windows\Sy-
(0) stem32\Wbem
[C077] Could not find symbol 'SYBASE' in dynamic library
(0)
(0) Closing log file at WED JAN 04 17:36:33 2017.