How to diagnose GoldenGate GGSCI command errors on an Oracle database

(Doc ID 1575600.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle GoldenGate - Version 11.2.0.0.0 to 12.1.2.0.0 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Goal

Several GoldenGate GGSCI commands execute SQL statements and/or PL/SQL packages on an Oracle database, for example;

If there are problems with these commands, then the problem may not be immediately obvious from the GGSCI interface.

So, this note demonstrates how to diagnose any Oracle database problems when such commands are issued.

Please note that these GGSCI Database Commands are only valid once the connection has been established:

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