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 laterInformation 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.
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);
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 |