How to diagnose GoldenGate GGSCI command errors on an Oracle database
Last updated on APRIL 05, 2018
Applies to:Oracle GoldenGate - Version 188.8.131.52.0 to 184.108.40.206.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