We're here to help!

Enable Email Notifications in Live Replication

Follow
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.
    set APPLY.MAILCFG_SMTP_SERVER = <smtp\_server>
    set APPLY.MAILCFG_AUTH_USER = user@company.com 
    set APPLY.MAILCFG_AUTH_PASSWD = <user\_password>
    set APPLY.MAILCFG_PORT = 465
    set APPLY.MAILCFG_USE_SSL = YES
    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.

Krupesh Desai November 17, 2014 11:32

Have more questions? Submit a request

Comments