Issue :
GoldenGate Error Queue For Apply Process “OGG$RNDDEV_A” Contains New Transaction With ORA-904
Observation :
*** ACTION NAME:(OGG$RNDDEV_A – Apply Server) 2016-06-01 15:50:47.102
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=10, mask=0x0)
—– Error Stack Dump —–
ORA-00904: : invalid identifier
—– Current SQL Statement for this session (sql_id=0pzw54w06ham9) —–
update /*+ streams restrict_all_ref_cons */ “<OWNER>”.”<TABLE_NAME>” p set “ADAPTER_ID”=decode(:1,’N’,”ADAPTER_ID”,:2), ……,”ATTRIBUTE_VALUE_MAPPING_FILE”=dbms_reputil2.get_final_lob(:7,”ATTRIBUTE_VALUE_MAPPING_FILE”,:8), …….., “POSTPROCESSING_XSL”=dbms_reputil2.get_final_lob(:29,”POSTPROCESSING_XSL”,:30), …… and(:112=”USER_MAPPING_ID”)
Reason :
The table of interest does have LOB columns and as seen in the trace there are calls to dbms_reputil2.get_final_lob
The GoldenGate user lacks privileges on dbms_reputil2.get_final_lob
Fix :
The issue got resolved once the execute privileges were granted to dbms_reputil2 to the GG admin user or the user that is applying the changes from the replicat process