MultiThread Classic Extract In ALO Mode Abends With OGG-06509 DPI-007 Invalid OCI Handle Or Descriptor OGG-10556 No Data Found ORA-01036 (Doc ID 2797419.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Case 1: Multi Thread Classic Extract in ALO Mode getting abended with below errors after altering extract with timestamp or scn:

2021-05-23 22:05:32  INFO    OGG-06509  Using the following key columns for source table <SCHEMANAME.TABLENAME>: COL1, COL2, COL3, COL4.
aCC runtime: Uncaught exception of type "ExceptionImpl".
aCC runtime: what(): DPI-007: invalid OCI handle or descriptor

Case 2. alter Multi Thread Classic Extract in ALO Mode with begin timestamp, process reported no data found
error:

2021-06-01 15:18:30  ERROR   OGG-10556  No data found when executing SQL
statement <select o.object_id, o.data_object_id,        decode (t.clucols
, NULL, 0, 1)  from dba_objects o, sys.tab$ t  where o.owner = :1 and
o.object_name = :2 and t.obj# = o.object_id>.

>>>>while altering 2nd time with begin timestamp, it abended with following
errors:

GGSCI (test@<ogguser>) 23> alter <ext_name> begin 2021-06-01 15:00
EXTRACT altered.

2021-06-01 17:01:52  ERROR   OGG-00664  OCI Error ORA (status =
1036-ORA-01036: illegal variable name/number
).

Source Context :
  SourceModule            : [er.redo.ora.metathr]
  SourceID                : [er/redo/oracle/ocimetathr.c]
  SourceMethod            : [OCIMETATHR_get_table_from_object_id]
  SourceLine              : [1537]

2021-06-01 17:01:52  ERROR   OGG-00663  OCI Error ORA-24338: statement handle
not executed

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.