Oracle ODBC Gateway to CData for QuickBooks: Error [ORA-00600]

2956286

I am trying to integrate Oracle DB with QuickBooks DB via CData ODBC driver.

currently im using oracle gateway to connect 2 databases.

here is the setup:

machine1: Oracle <==>Cdata ODBC(quickbooks)

machineServer: QuickBooks database(remoteconnection)

CData ODBC access the quickbooks data remotely, and i want to access the data using oracle.

listener.ora -------------------------------------------------------------------------------------------------------------

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = BLPTEST.hitachitransport.com)(PORT = 1522))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))

    )

  )

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

(SID_NAME=QB)

(ORACLE_HOME=D:\app\Administrator\product\11.2.0\tg_1\)

(PROGRAM=dg4odbc)

)

)

ADR_BASE_LISTENER = \app\Administrator\product\11.2.0\tg_1

-------------------------------------------------------------------------------------------------------------------------------

tnsnames.ora-------------------------------------------------------------------------------------------------------------

ORACLE.11G.BLPTEST =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = ORACLE.11G.BLPTEST)

      (SID = ORCL)

    )

  )

QB =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1522))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SID=QB))

      (HS=OK)

  )

-------------------------------------------------------------------------------------------------------------

sqlnet.ora-------------------------------------------------------------------------------------------------------------

SQLNET.AUTHENTICATION_SERVICES= (NONE)

-------------------------------------------------------------------------------------------------------------

lsnrctl working ok

tnsping is also ok

created the database link called QB to connected and run the query

select * from [email protected]

but everytime i try to query, I get:

Error ORA-00600: Internal error code, arguments: [HO define: Long fetch], [],[],[],[],[],[],[],[],[],[]....

please see the attachment(log file)

looking at the logfile it kind of retrieve the table information(which matches with the quickbooks DB).

Please advise.

Chris

Unknown

>(HOST = localhost)

above prevents any remote access

2956286

Thank you for your advise.

I had it written local host but it is actually written as IP address.

Unknown

I am sorry to see that COPY & PASTE are broken for you.

Since I can't believe the details you post to be correct, I stop wasting my time trying to discern fact from fiction.

2956286

Except the HOST part, everything else is the actual content of my tns and listener file.