My Oracle Support Banner

Classic Replicat is ABENDED due to ORA-904 and OGG-01296 After Replicating RENAME COLUMN Command (Doc ID 2813773.1)

Last updated on DECEMBER 07, 2021

Applies to:

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

Symptoms

Classic Replicat process is ABENDED due to ORA-904 and OGG-01296 after replicating RENAME COLUMN command.

< ggserr.log on Target >
2018-12-11T14:08:01.497+0900 INFO OGG-06510 Using the following key columns for target table <SCHEMA>.<TABLE>: <COL1>.
2018-12-11T14:08:01.523+0900 WARNING OGG-01004 Aborted grouped transaction on <SCHEMA>.<TABLE>, Database error 904 (OCI Error ORA-00904: "<COL2>": invalid identifier (status = 904), SQL <INSERT INTO "<SCHEMA>"."<TABLE>" ("<COL1>","<COL2>") VALUES (:a0,:a1)>).
2018-12-11T14:08:01.523+0900 WARNING OGG-01003 Repositioning to rba 5106 in seqno 0.
2018-12-11T14:08:01.523+0900 WARNING OGG-01154 SQL error 904 mapping <SCHEMA>.<TABLE> to <SCHEMA>.<TABLE> OCI Error ORA-00904: "<COL2>": invalid identifier (status = 904), SQL <INSERT INTO "<SCHEMA>"."<TABLE>" ("<COL1>","<COL2>") VALUES (:a0,:a1)>.
2018-12-11T14:08:01.523+0900 ERROR OGG-01296 Error mapping from <SCHEMA>.<TABLE> to <SCHEMA>.<TABLE>.
2018-12-11T14:08:01.531+0900 INFO OGG-02333 Reading <GG_HOME>/dirdat/rt000000000, current RBA 5,106, 2 records, m_file_seqno = 0, m_file_rba = 5,224.
2018-12-11T14:08:01.531+0900 ERROR OGG-01668 PROCESS ABENDING.

Changes

This problem reproduces when Replicat process is configured as Classic Replicat.
Configuration of Capture (Extract) process does not affect this problem.

Testcase is to run following commands on Source DB after enabling DDL replication on both Capture and Classic Replicat.

When replicating last INSERT command by Classic Replicat, Replicat process is ABENDED.

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