Classic Replicat is ABENDED due to ORA-904 and OGG-01296 After Replicating RENAME COLUMN Command
(Doc ID 2813773.1)
Last updated on APRIL 07, 2024
Applies to:
Oracle GoldenGate - Version 12.2.0.2.2 and laterInformation 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.
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 |