My Oracle Support Banner

How to diagnose GoldenGate GGSCI command errors on an Oracle database (Doc ID 1575600.1)

Last updated on FEBRUARY 11, 2021

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.