My Oracle Support Banner

Oracle GoldenGate 12.3 Extract Abends With ORA-4043 When Using SQLEXEC (Doc ID 2454196.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

When capture has SQLEXEC with SPNAME on CDB, Capture process is abended due to ORA-4043.

< ggserr.log >

2018-10-01T09:50:46.097+0900 INFO OGG-06507 Oracle GoldenGate Capture for Oracle, cap01.prm: MAP (TABLE) resolved (entry PDB.XXX.XXXX): TABLE "PDB"."XXXX"."XXXX", SQLEXEC (SPNAME XXXX.XXXX,ID EMP1, NOPARAMS).
2018-10-01T09:50:46.251+0900 INFO OGG-06509 Oracle GoldenGate Capture for Oracle, cap01.prm: Using the following key columns for source table PDB.XXXX.XXXX: C1.
2018-10-01T09:50:46.357+0900 INFO OGG-06507 Oracle GoldenGate Capture for Oracle, cap01.prm: MAP (TABLE) resolved (entry PDB.XXXX.XXXX): TABLE "PDB"."XXXX"."XXXX", SQLEXEC (SPNAME XXXX.XXXX EMP1, NOPARAMS).
2018-10-01T09:50:46.367+0900 ERROR OGG-00251 Oracle GoldenGate Capture for Oracle, cap01.prm: Stored procedure/function XXXX.XXXX does not exist (ORA-04043: オブジ ェクトXXXXは存在しません。).
2018-10-01T09:50:46.368+0900 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, cap01.prm: PROCESS ABENDING.

Sample of parameter file of Capture process is as follows.

EXTRACT cap01
USERID c##XXXX@cdb, PASSWORD xxxx
EXTTRAIL ./dirdat/lt
TABLE PDB.XXXX.XXXX, SQLEXEC (SPNAME XXXX.XXXX,ID EMP1, NOPARAMS); 

 

Changes

This problem reproduces on OGG 12.3.0.1.0 or above, and Oracle Database is configured as CDB (Multitenant).

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