Versions Compared

Old Version 8

changes.mady.by.user KrupeshD

Saved on

compared with

New Version 9

changes.mady.by.user Anton Els

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This section contains all the settings found in the Dbvisit Standby Configuration (DDC) file with regards to E-Mail configuration.

There are two sections:

  • General email configuration
  • Advanced email configuration

General E-mail Configuration Variables

Variable Name

Meaning

ADMINS

The

This variable holds the administrator email address

(es)

where emails will be sent upon success or failure of Dbvisit Standby. Multiple emails should be separated with a comma (,). Also see SUCCESS_MAILTO.

Example

Examples: 

   

ADMINS = alert@mycompany.com

ADMINS = alert@mycompany.com,dba@mycompany.com

 

SUCCESSMAIL

Specifies when Dbvisit Standby should send an email from the primary server.

Possible Values

are Yes or No.Yes =

:

  • Yes (default value)
    Every time Dbvisit Standby is run an email will be sent.
  • No
=

  • Only when an error occurs or a threshold is exceeded will an email be sent.
 
It is advisable to initially set to Yes.
Once everything is stable, this setting can be changed to No. 
If you are not sure, set to Yes.
Example:
   
  •   

Example (default) value:

SUCCESSMAIL = Yes

 

SUCCESSMAIL_DR

Specifies when Dbvisit Standby should send an email from the standby server.

Values are Yes or No.
Yes =

Possible Values:

  • Yes  (default value)
    Every time Dbvisit Standby is run an email will be sent.
No =
  • No 
    Only when an error occurs or a threshold is exceeded will an email be sent
. It is advisable to initially set to Yes
  • .
Once everything is stable, this setting can be changed to No.
  •  
If you are not sure, set to Yes.

Example (default) value:

   

SUCCESSMAIL_DR = Yes

 

MAILCFG_MAIL_CLIENT

Specifies the mail client. Default is to use internal Dbvisit Standby mail client. The Dbvisit Standby internal mail client requires a smtp mail server to send emails.

Other mail clients can be specified. Example: mail, sendmail or javamail

.For sendmail:

.

The default option of "dbvisit" should work for most environments and is the recommended option to set for this variable.

Note

Sendmail does not need to be running in order to send mail from this server. Only when receiving mail on this server does it need to be running.

Sendmail does need to be configured to in order to send mail.

If the Dbvisit Standby mail client is to be used, specify "Dbvisit".

Example (default) value:

   

MAILCFG_MAIL_CLIENT= dbvisit

 

MAILCFG_FROM

Specifies the FROM email address of the primary server

(optional)

.

If this is not specified, the emails may not arrive.

Example:

   

MAILCFG_FROM =

server1@dbvisit

oracledba@dbvlin101.dbvisit.com

 

MAILCFG_FROM_DR

Specifies the FROM email address of the standby server

(optional)

.

If this is not specified, the emails may not arrive.

Example:

   

MAILCFG_FROM_DR =

server2@dbvisit

oracledba@dbvlin102.dbvisit.com

 

MAILCFG_SMTP_SERVER

Specifies the smtp server to send the email to. Is only used if the mail client is Dbvisit. Is not required when the mail client is sendmail.

Sample

Examples:

- mail.<your company name>

MAILCFG_SMTP_SERVER = smtp.<yourcompanyname>.com

-

MAILCFG_SMTP_SERVER = smtp.

<your company name>

example.com

Example:

   

MAILCFG_SMTP_SERVER = mail.

<your company name>

example.com

 

MAILCFG_SMTP_SERVER_DR

Optional smtp mail server for the standby server.

Only used if smtp mail server for the standby server differs from the main smtp mail server (MAILCFG_SMTP_SERVER).

Sample

Examples:

- mail.<your company name>

MAILCFG_SMTP_SERVER = smtp.<yourcompanyname>.com

-

MAILCFG_SMTP_SERVER = smtp.

<your company name>

example.

com 

com

Example:
   

MAILCFG_SMTP_SERVER = mail

-dr 
  

.example.com


Advanced Mail Settings

This section will cover the more advanced E-mail configuration settings available in the Dbvisit Standby configuration file (DDC).

 

MAILCFG_AUTH_USER is PASSWD MAILCFG are Yes or No.Yes = = filesize is is is to turn is

Variable Name

Meaning

MAILCFG_AUTH_USER

This parameter is used to specify a username required for SMTP authentication (username).

Examples:

MAILCFG_AUTH_USER=<your_username>

MAILCFG_AUTH_

USER=admin

 

MAILCFG_AUTH_PASSWD

This variable is used to specify the password required for SMTP authentication (password).

Example:

MAILCFG_AUTH_PASSWD=<your_password>

MAILCFG_AUTH_PASSWD=adminpassword

 

MAILCFG_CC

Specify email address you want to cc Dbvisit Standby email alerts to.

Example:

MAILCFG_CC=admin@example.com

 

MAILCFG_BCC

Specify email address you want to bcc Dbvisit Standby email alerts to.

Example:

MAILCFG_BCC=admin@example.com

 

MAILCFG_ATTACH_TRACEFILE

This parameter is used to specify whether to attach trace files to error emails so that these can be forwarded to Dbvisit support.

Possible Values

:

  • Yes (Default)
    Attach trace files with error email.

  • No

  • Trace files are not attached with error email.

It is advisable to initially set to Yes

Example:

MAILCFG_ATTACH_TRACEFILE=Yes

 

MAILCFG_ATTACH_TRACEFILE_MAX_SIZE_IN_BYTES

This variable is used to specify a

file size limit to attaching the tracefile.

Example:

MAILCFG_ATTACH_TRACEFILE_MAX_SIZE_IN_BYTES = 768000

 

MAILCFG_SENDMAIL_CLIENT

This parameter allows you to specify another sendmail client. Full path must be provided.

Note

MAILCFG_MAIL_CLIENT must be set to

sendmail for this to take effect.

 

Example: ( '\' must be escaped if used on Windows )

MAILCFG_SENDMAIL_CLIENT = C:\\programs\\sendmail.exe

 

MAILCFG_PORT

This parameter allow you to specify another smtp port if the default is not used.

Example:

MAILCFG_PORT=26

 

MAILCFG_DEBUG

Turn on smtp debug messages in the trace files. Possible values are 0 (default) or 1 (enable debug)

Example:

MAILCFG_DEBUG=1

 

MAILCFG_TIME_OUT

This parameter allow the option to specify smtp timeout in seconds.

Example (default) value:

MAILCFG_TIME_OUT=60