Oracle Database - Gateway Log

Card Puncher Data Processing

About

How to debug a gateway problem.

Parameters

Example:

HS_FDS_TRACE_FILE_NAME=dblink_trace.txt
HS_FDS_TRACE_LEVEL=ON

HS_FDS_TRACE_LEVEL

  • Default Value: OFF
  • Range of values: OFF, ON, DEBUG

Specifies whether error tracing is turned on or off for gateway connectivity.

The following values are valid:

  • OFF disables the tracing of error messages.
  • ON enables the tracing of error messages that occur when you encounter problems. The results are written by default to a gateway log file in LOG directory where the gateway is installed.
  • DEBUG enables the tracing of detailed error messages that can be used for debugging.

HS_FDS_TRANSACTION_LOG

  • Default Value: HS_TRANSACTION_LOG
  • Range of Values: Any valid table name

Specifies the name of the table created in the non-Oracle system for logging transactions. For more information about the transaction model, see the HS_TRANSACTION_MODEL parameter.

Documentation





Discover More
Card Puncher Data Processing
Oracle Database - Gateway (Heterogeneous services)

Gateway (Or Heterogeneous Services before 11g) make a non-Oracle system appear as a remote Oracle Database server through program that are called agent. The Oracle ODBC agent acts as an ODBC client and...



Share this page:
Follow us:
Task Runner