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

Recommended Posts

Start typing and press Enter to search