My Oracle Support Banner

OGG Extract Abend with ERROR OGG-00662 OCI Error ORA-01001: invalid cursor (Doc ID 2827708.1)

Last updated on APRIL 17, 2023

Applies to:

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

Symptoms


Extract abended with below error : 

2021-08-28 08:00:38 ERROR OGG-00662 OCI Error ORA-01001: invalid cursor
2021-08-28 08:00:38 ERROR OGG-02078 Extract encountered a fatal error in a processing thread and is abending.

 alert logfile shows error below at the same time :

ORA-01555 caused by SQL statement below (SQL ID: czw8cfcddpt47, Query Duration=4172 sec, SCN: 0x000005836af591d6):
2021-08-28T08:00:37.334787+08:00
SELECT CASE WHEN MAX(LENGTHB(C.COLNAME)) > 30 THEN 32768 ELSE 0 END AS LONG_IDEN FROM SYSTEM.LOGMNRC_GTCS C WHERE C.OBJ# = :B1
2021-08-28T08:00:37.336987+08:00
LOGMINER: session#=184 (OGG$CAP_EE), builder MS08 pid=1939 OS id=247289 sid=2998 stopped
2021-08-28T08:00:37.337293+08:00
Errors in file /u01/app/oracle/diag/rdbms/...../trace/Ext_ms08_247289.trc:
ORA-01001: invalid cursor
ORA-00604: error occurred at recursive SQL level 1
ORA-01001: invalid cursor
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 92 with name "_SYSSMU92_198676121$" too small
ORA-06512: at "SYS.LOGMNR_DICT_CACHE", line 9476
ORA-06512: at line 1
2021-08-28T08:00:37.354455+08:00

 

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