Oracle Goldengate How to Troubleshoot issues and Performace tuning Webinar 06082023

[@aniszerelli820]

great session

[@beenabansal5585]

Nice

[@JianingFan-nu1tf]

did not find the setup and configure performance metrics in MSA. are you going to make a vidoe on that? thanks,

[@kumarmh7098]

If due to any reason goldengate source to target replication fails is there a way to initiate notification. Or what do you recommend in this situation

[@AshishAgarwal_GG]

Hi- Yes u can setup shell script for the same. Pls read below article: www.linkedin.com/pulse/oracle-goldengate-monitoring-methods-ashish-agarwal/

[@mohammedasifali6448]

Good videos but maintains a bit more volume

[@mohanreddy4543]

Sir I have a question

[@mohanreddy4543]

We are trying to migrate MySql to Oracle while initial load replicate we are facing invalid month...2023-08-28 13:53:24 WARNING OGG-01004 Canceled grouped transaction on table WIZARD.ACCOUNT. Database error 1843, (OCI Error ORA-01843: not a valid month (status = 184

[@mohanreddy4543]

As per SR tried MAP Wizard.Account,target wizard.account, colmap(usedefaults, CASHTRANSACTIONDATE = @IF ( @STRCMP ( CASHTRANSACTIONDATE, "0000-00-00:00:00:00") = 0, "", CASHTRANSACTIONDATE) CHEQUETRANSACTIONDATE = @IF ( @STRCMP ( CHEQUETRANSACTIONDATE, "0000-00-00:00:00:00") = 0, "", CHEQUETRANSACTIONDATE) ACCOUNTOPENINGVALUEDATE = @IF ( @STRCMP ( ACCOUNTOPENINGVALUEDATE, "0000-00-00:00:00:00") = 0, "", ACCOUNTOPENINGVALUEDATE) ACCOUNTCREATEDON = @IF ( @STRCMP ( ACCOUNTCREATEDON, "0000-00-00:00:00:00") = 0, "", ACCOUNTCREATEDON) CREATEDON = @IF ( @STRCMP ( CREATEDON, "0000-00-00:00:00:00") = 0, "", CREATEDON) MODIFIEDON = @IF ( @STRCMP ( MODIFIEDON, "0000-00-00:00:00:00") = 0, "", MODIFIEDON));

[@mohanreddy4543]

But no luck, any help on this issue

[@luckyme213]

@@mohanreddy4543 Change date format to Oracle format by using the following query. ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'; Hope this helps anyone passing by.

[@liesbethopen]

Sound misses😢

[@liesbethopen]

My fault, sound Ok

[@AshishAgarwal_GG]

hi - I can hear the sound. Can u pls check the speaker of device being used. probably thats the case