Howto Trace Clientside Applications on OCI Level On Windows (Doc ID 749498.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.2 and later
Microsoft Windows (32-bit)
***Checked for relevance on 2nd Aug 2016***

Goal

To describe how to trace client side OCI calls to the Full Client "oraclient[X].dll" or Instant Client "oraociei[X].dll" or  library. Since almost all client applications implemented in OCI uses these two libraries (directly or indirectly), this may help in trouble-shooting and debugging applications on Windows. This note also provides an example on how Microsoft Debugging Tools for Windows can be customized to provide Oracle specific information.

The Oracle Call Interface is an application programming interface used by a large number of client side interfaces, for example:

An application using the Oracle Call Interface can either link with oci.dll that indirectly links to the oraclient[X].dll or oraociei[X].dll libraries, or link directly to these two libraries depending if Full or Instant Client is used. The tracing will work regardless how the application is linked.

This approach to trace OCI calls is based on the Microsoft Debugging Tools for Windows. A debugger script is generated that adds breakpoints on the entry points for the OCI calls and writes the function calls and parameters to a log file. The debugger is invoked by the AdPlus tool.

The tracing functionality described in this note cannot be used to trace applications that links with ociw32.dll (OCI7) for example used by Microsoft ODBC Driver.

Solution

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