3 Replies Latest reply on Feb 18, 2020 5:27 AM by 4073220

    Trigger doesn't work properly after upgrade Oracle GoldenGate from 11g to 19c

    3578879
    3578879 Feb 11, 2020 5:35 PM

      Hello OGG experts,

       

      We have one table which contains two extra columns to capture current_scn and sysdate in target only. The current scn is inserted via a trigger. The sysdate is defined by COLUMN mapping ( = @DATENOW())  in the replicat parameter file.

      This process works very well with OGG 11g. However, after we upgraded OGG from 11g to 19c, the trigger doesn't work properly. The current scn is always NULL.

      I can confirm that the trigger works properly if I insert the data manually.

       

      Any solutions or recommendations?

       

      Thank you,

       

      Lina

      • 55 Views
      • Tags: