How to diagnose GoldenGate GGSCI command errors on an Oracle database
(Doc ID 1575600.1)
Last updated on APRIL 05, 2018
Applies to:Oracle GoldenGate - Version 220.127.116.11.0 to 18.104.22.168.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:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!