How to diagnose GoldenGate GGSCI command errors on an Oracle database
Last updated on JANUARY 10, 2017
Applies to:Oracle GoldenGate - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 11.2 to 12.1]
Information in this document applies to any platform.
Several GoldenGate GGSCI commands execute SQL statements and/or PL/SQL packages on an Oracle database, for example;
- ADD TRANDATA
- LIST TABLES
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:
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