OGG-08221 Cannot register or unregister EXTRACT TESTIEXT because of the following SQL error: OCI Error 1,116. (Doc ID 2139392.1)

Last updated on MAY 18, 2016

Applies to:

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

Symptoms

Trying to REGISTER or UNREGISTER Goldengate Integrated Extract fails with:

GGSCI> dblogin userid gg_app, password ****
Successfully logged into database.

GGSCI> register extract testiext database

2016-05-13 14:43:38  ERROR   OGG-08221  Cannot register or unregister EXTRACT TESTIEXT because of the following SQL error: OCI Error 1,116.

 
Usually a database trace file (.trc) is generated at the database for the Goldengate client session, it will show a stack like this:

<<from .trc file>>
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /usr/local/oracle/product/11.2.0.4/dbhome_1
System name:    AIX
Node name:    test
Release:    1
Version:    7
Machine:    00C0988A4C00
Instance name: test
Redo thread mounted by this instance: 1
Oracle process number: 31
Unix process pid: 2425032, image: oracle@test (TNS V1-V3)


*** 2016-05-16 10:04:31.487
*** SESSION ID:(197.49069) 2016-05-16 10:04:31.487
*** CLIENT ID:() 2016-05-16 10:04:31.487
*** SERVICE NAME:(SYS$USERS) 2016-05-16 10:04:31.487
*** MODULE NAME:(OGG-OPEN_DATA_SOURCE) 2016-05-16 10:04:31.487
*** ACTION NAME:() 2016-05-16 10:04:31.487
 
*** 2016-05-16 10:04:31.486 4338 krsh.c
ALTER SYSTEM SWITCH ALL LOGFILE start

*** 2016-05-16 10:04:34.361
*** 2016-05-16 10:04:34.361 4338 krsh.c
ALTER SYSTEM SWITCH ALL LOGFILE complete
DDE rules only execution for: ORA 1110
----- START Event Driven Actions Dump ----
---- END Event Driven Actions Dump ----
----- START DDE Actions Dump -----
Executing SYNC actions
----- START DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (Async) -----
Successfully dispatched
----- END DDE Action: 'DB_STRUCTURE_INTEGRITY_CHECK' (SUCCESS, 0 csec) -----
Executing ASYNC actions
----- END DDE Actions Dump (total 0 csec) -----
Mon May 16 10:04:34 2016
Logminer Bld: failed to load gather tables at  position 3 status -1116
DDE: Problem Key 'ORA 1110' was flood controlled (0x1) (no incident)
ORA-01110: data file 2: '/usr/local/oracle/database/test/undo/undo_01.dbf'
ORA-27092: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 507914
ORA-01116: error in opening database file 2
ORA-01110: data file 2: '/usr/local/oracle/database/test/undo/undo_01.dbf'
ORA-27092: size of file exceeds file size limit of the process
Additional information: 262143
Additional information: 507914

 

 

 

Changes

 New Goldengate integrated extract configuration.

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