GoldenGate EXTRACT Hung when fetching data (Doc ID 1639558.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

Extract hangs and pstack shows:

 

18: 4000000000af6c90 : process_select_lobs(file_def*,int)() at /scratch/aime1/adestore/views/aime1_staoi06/oggcore/OpenSys/src/gglib/ggdbora/dboci8.c:5454
19: 4000000000afb9a0 : DBOCI_get_query_row(file_def*,int,int*)() at /scratch/aime1/adestore/views/aime1_staoi06/oggcore/OpenSys/src/gglib/ggdbora/dboci8.c:6041
20: 4000000000b08780 : pk_fetch_cols(file_def*,DBOCI_stmt_def*,int,int,int*)() at /scratch/aime1/adestore/views/aime1_staoi06/oggcore/OpenSys/src/gglib/ggdbora/dboci8.c:6859
21: 4000000000b0c0b0 : DBFETCH_fetch_pk_cols(void*,file_def*)() at /scratch/aime1/adestore/views/aime1_staoi06/oggcore/OpenSys/src/gglib/ggdbora/dboci8.c:6906
22: 4000000000435d00 : fetchPKCols(file_def*)() at /scratch/aime1/adestore/views/aime1_staoi06/oggcore/OpenSys/src/app/er/dbfetch.c:3527
23: 40000000004372e0 : DBFETCH_fetch_cols(file_def*,char*,int,short,int,int*,short*,int*)() at /scratch/aime1/adestore/views/aime1_staoi06/oggcore/OpenSys/src/app/er/dbfetch.c:2156
24: 400000000043f120 : DBFETCH_checkFetchCols(file_def*,__std_rec_hdr*,char*,int,unsignedchar*,char*,short*,long,int,pk_fetch_options_t*)() at
/scratch/aime1/adestore/views/aime1_staoi06/oggcore/OpenSys/src/app/er/dbfetch.c:3370
25: 40000000006591f0 :



Cause

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