Enable Email Notifications in Live Replication

Owned by Clive Otten (Unlicensed)
Jan 21, 2020
2 min read

Problem Description

This article explains how to configure E-Mail notification in a live replicate environment. 

Solution

Email notifications can be configured in step-4 of the setup wizard. In most configurations, users prefer to configure Dbvisit Replicate first. Once replication is live they then enable email notifications.

Enabling email notification in live replication requires setting a few of Dbvisit Replicate's parameters depending upon your SMTP server's authentication method.

SMTP server requires NO authentication

If the SMTP server requires NO authentication:

  1. Add the following commands in the MINE DDC file:

    set MINE.MAILCFG_FROM = oracle@replicate.com *Can be any valid email address set MINE.MAILCFG_SMTP_SERVER = <smtp\_server> set MINE.MAILCFG_PORT = 25 set MINE.NOTIFY_ALL_EMAIL = user@company.com [,cc list] set MINE.NOTIFY_SUCCESS_EMAIL= user@company.com [,cc list] set MINE.NOTIFY_ALERT_EMAIL= user@company.com [,cc list]

  2. Add following commands in the APPLY DDC file.

    set APPLY.MAILCFG_FROM = oracle@replicate.com *Can be any valid email address set APPLY.MAILCFG_SMTP_SERVER = <smtp\_server> set APPLY.MAILCFG_PORT = 25 set APPLY.NOTIFY_ALL_EMAIL = user@company.com [,cc list] set APPLY.NOTIFY_SUCCESS_EMAIL= user@company.com [,cc list] set APPLY.NOTIFY_ALERT_EMAIL= user@company.com [,cc list]

  3. Restart MINE and APPLY.

SMTP Server REQUIRES Authentication

If SMTP server REQUIRES authentication:

  1. Add the following commands in the MINE DDC file:

    set MINE.MAILCFG_SMTP_SERVER = <smtp\_server> set MINE.MAILCFG_AUTH_USER = user@company.com set MINE.MAILCFG_AUTH_PASSWD = <user\_password> set MINE.MAILCFG_PORT = 465 set MINE.MAILCFG_USE_SSL = YES set MINE.NOTIFY_ALL_EMAIL = user@company.com [,cc list] set MINE.NOTIFY_SUCCESS_EMAIL= user@company.com [,cc list] set MINE.NOTIFY_ALERT_EMAIL = user@company.com [,cc list]

  2. Add the following commands in the APPLY DDC file.

  3. Restart MINE and APPLY.

Krupesh Desai November 17, 2014 11:32