Oracle dblink的select表中出现错误ORA-00600

Question

我创建了一个Oracle Dblink来访问SQLServer表。我可以看到我可以访问的表/视图。

​

​

但是当我执行select时，它返回ORA-00600。

​

​

我的dblink create命令：

CREATE DATABASE LINK SQLREQUERIM CONNECT TO my_user IDENTIFIED BY "myPassword" USING 'MSSQLREQUERIM';

我的tnsnames.ora文件

MSSQLREQUERIM =
  (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=myOracleHost)(PORT=1521))
    (CONNECT_DATA=(SID=MSSQLREQUERIM))
    (HS=OK)
  )

我的listener.ora文件

SID_LIST_LISTENER =
 (SID_LIST =
   (SID_DESC=
     (SID_NAME=MSSQLREQUERIM)
     (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)
     (PROGRAM=dg4odbc)
   )
 )

我的odbc.ini

[ODBC Data Sources]
MSSQLREQUERIM = MSSQL Server

[MSSQLREQUERIM]
Driver=/usr/lib64/libtdsodbc.so.0
Description     = MSSQL Server
Trace           = No
Server          = mySQLServerHost
Database        = REQUERIM
Port            = 60472
TDS_Version     = 7.2

我的iniMYSQLREQUERIM.ora文件

HS_FDS_CONNECT_INFO = MSSQLREQUERIM
HS_FDS_TRACE_LEVEL = DEBUG
HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so
set ODBCINI=/etc/odbc.ini

Answer 1

错误是由于某些表列的类型(文本)与Oracle不兼容。如果不显示这些列，搜索就会起作用。