HS: Golded Gate Process Abend Issue In QC Env. (Doc ID 1913740.1)

Last updated on JULY 22, 2015

Applies to:

Oracle GoldenGate - Version 11.2.1.0.20 and later
Information in this document applies to any platform.

Goal

Database is up and running. Both the instances are up and running.

OGG process fails with below error

WARNING OGG-02043 Oracle GoldenGate Delivery for Oracle, rworksp.prm: ID missing from SQLEXEC EXEC clause, id CH_APC_FILES. If an EXEC clause includes a schema name with the stored procedure name, ID is required due to bug 12989433 https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=12989433. See the Oracle GoldenGate reference documentation for details.
INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
ERROR OGG-00665 Oracle GoldenGate Capture for Oracle, extall.prm: OCI Error describe for query (status = 3114-ORA-03114: not connected to ORACLE),
SQL< SELECT owner, object_name, object_type FROM dba_objects WHERE object_id = 53800 AND object_type in ('TABLE', 'INDEX', 'INDEX PARTITION','TABLE PARTITION', 'TABLE SUBPARTITION', 'SEQUENCE')>.
ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, extall.prm: PROCESS ABENDING.
 

Solution

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