My Oracle Support Banner

Running ODI JKM Oracle To Oracle Consistent (OGG Online) with ONLINE=True Fails with the Error "ODI-1589: The execution of the OdiOggCommand operation EXECUTEOBEY failed." (Doc ID 2101728.1)

Last updated on MARCH 10, 2017

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Oracle GoldenGate - Version 12.1.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Issue was first observed with the following:
Oracle IDE 12.1.3.0.0
Oracle GoldenGate version : 12.1.2.1.5

When trying to use the JKM oracle to Oracle Consistent (OGG Online) and setting the ONLINE = true the process fails at the first step that would use the Goldengate ggsci connection.
The error message is:

ODI-1589: The execution of the OdiOggCommand operation EXECUTEOBEY failed.
Caused By: com.sunopsis.dwg.tools.gg.exceptions.OdiOggException: com.sunopsis.dwg.tools.gg.exceptions.OdiOggException: Failed by Oracle Golden Gate JAgent for the operation EXECUTEOBEY.
at com.sunopsis.dwg.tools.gg.operations.ExecuteGGSCICommand.execute(ExecuteGGSCICommand.java:120)
at com.sunopsis.dwg.tools.gg.operations.AbstractOperationStrategy.executeOperation(AbstractOperationStrategy.java:62)...

 

If the option ONLINE=False is set, then the generated files will copy and run with no problem.
If the option ONLINE=True is set, the files are copied to the database server with no problem, but the ggsci commands are not being executed from the OBEY file using the JKM.

 

Cause

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
Symptoms
Cause
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.