My Oracle Support Banner

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

Last updated on MARCH 12, 2021

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, <replicat name>.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, <extract name>.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, <extract name>.prm: PROCESS ABENDING.
 

Solution

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
Goal
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.