Errors Ora-28500 And Ora-02063 : Gateway."Hs_transaction_log" Not Found Using Dg4Sybase (Doc ID 1140063.1)

Last updated on SEPTEMBER 25, 2013

Applies to:

Oracle Database Gateway for Sybase - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 25-Sep-2013***


Symptoms


An Oracle 11.1 DG4Sybase runs  normally but then these messages appear in the alert log -

Errors in file /opt/oracle/admin/ORCL/bdump/orcl2_reco_8549.trc:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC Sybase Wire Protocol driver][SQL Server]gateway."HS_TRANSACTION_LOG" not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
ORA-02063: preceding 2 lines from DBLINK

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms