Golden Gate Related Errors After Enabling Extended Data Type for the Database

(Doc ID 2325329.1)

Last updated on NOVEMBER 06, 2017

Applies to:

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

Symptoms

Extract abends with the following errors after enabling Extended Data Type support in the database:

2017-10-09 11:32:59 INFO OGG-01851 Oracle GoldenGate Capture for Oracle, ggs_ext.prm: filecaching started: thread ID: 140706819602176.
2017-10-09 11:32:59 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ggs_ext.prm: Virtual Memory Facilities for: COM
  anon alloc: mmap(MAP_ANON) anon free: munmap
  file alloc: mmap(MAP_SHARED) file free: munmap
  target directories:
  /goldengate/dirtmp.
2017-10-09 11:32:59 INFO OGG-01639 Oracle GoldenGate Capture for Oracle, ggs_ext.prm: BOUNDED RECOVERY: ACTIVE: for object pool 1: p32610_extr.
2017-10-09 11:32:59 INFO OGG-01640 Oracle GoldenGate Capture for Oracle, ggs_ext.prm: BOUNDED RECOVERY: recovery start XID: 0.0.0.
2017-10-09 11:32:59 INFO OGG-01641 Oracle GoldenGate Capture for Oracle, ggs_ext.prm: BOUNDED RECOVERY: recovery start position: SeqNo: 65644, RBA: 715948, SCN: 0.3374802818 (3374802818), Timestamp: 2017-10-09 11:23:59.000000, Thread: 1.
2017-10-09 11:32:59 INFO OGG-01642 Oracle GoldenGate Capture for Oracle, ggs_ext.prm: BOUNDED RECOVERY: recovery end position: SeqNo: 65644, RBA: 715948, SCN: 0.3374802818 (3374802818), Timestamp: 2017-10-09 11:23:59.000000, Thread: 1.
2017-10-09 11:32:59 INFO OGG-01643 Oracle GoldenGate Capture for Oracle, ggs_ext.prm: BOUNDED RECOVERY: CANCELED: for object pool 1: p32610_extr.
2017-10-09 11:32:59 INFO OGG-01579 Oracle GoldenGate Capture for Oracle, ggs_ext.prm: BOUNDED RECOVERY: VALID BCP: CP.GGS_EXT.000001399.
2017-10-09 11:32:59 INFO OGG-01629 Oracle GoldenGate Capture for Oracle, ggs_ext.prm: BOUNDED RECOVERY: PERSISTED OBJECTS RECOVERED: <>.
2017-10-09 11:33:06 ERROR OGG-00665 Oracle GoldenGate Capture for Oracle, ggs_ext.prm: OCI Error describe for query (status = 4045-ORA-04045: errors during recompilation/revalidation of PUBLIC.GV$PARAMETER
ORA-04024: self-deadlock detected while trying to mutex pin cursor 0x42D47F8F8
ORA-06512: at "OGGUSER.FILE_SEPARATOR", line 9
ORA-06512: at line 1149
ORA-04024: self-deadlock detected while trying to mutex pin cursor 0x42D47F8F8
ORA-06512: at "OGGUSER.FILE_SEPARATOR", line 9
ORA-06512: at line 1149
ORA-04045: errors during recompilation/revalidation of SYS.V_$PARAMETER
ORA-04024: self-deadlock detected while trying to mutex pin cursor 0x423F77D30
ORA-06512: at "OGGUSER.FILE_SEPARATOR", line 9
ORA-06512: at line 1149
ORA-04024: self-deadlock detected while trying to mutex pin cursor 0x423F77D30), SQL


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