Step 4 - Configure Processes

This steps configures the replication processes for each replication. This includes setting the

  • hostnames
  • port numbers
  • Notification settings and thresholds

Click here for more information on step-4.

Add process information for the MINE process:

Step 4 - Process configuration
========================================
The fourth step is to configure the replication processes for each replication.

Following processes are defined:
1: MINE on orcl_dbvisit210
Not configured.
2: APPLY on orcl_dbvisit230
Not configured.
Enter number of process to modify it, or "done": [1] 
Fully qualified name of the server for the process (usually co-located with the database, unless mine is offloaded using fetcher): [] dbvisit210 
Enable email notifications about problems (yes/no)? [NO] YES
Enable SNMP traps/notifications about problems (yes/no)? [NO] 
Directory with DDC file and default where to create log files etc. (recommended: same as global setting, if possible)? [/home/oracle/orcl] 
Following settings were pre-filled with defaults or your reloaded settings:
----------------------------------------
[MINE_LISTEN_INTERFACE]: Network listen interface: dbvisit210:7901 
[MINE_DATABASE]: Database TNS: orcl_dbvisit210 
[TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/11.1.0/db_1/network/admin 
[MINE_USER]: Replicate database username: dbvrep 
[MINE_PASSWORD]: Replicate database password: ********* 
[ORACLE_HOME]: ASM ORACLE_HOME: /u01/app/oracle/product/11.1.0/db_1 
[MINE_PLOG]: Filemask for generated plogs: /home/oracle/orcl/mine/%S.%E 
[LOG_FILE]: General log file: /home/oracle/orcl/log/dbvrep_%N_%D.%E 
[LOG_FILE_TRACE]: Error traces: /home/oracle/orcl/log/trace/dbvrep_%N_%D_%I_%U.%E 
Checking that these settings are valid...
Do you want change any of the settings? [no] 
(MAILCFG_SMTP_SERVER) - Specify mail (SMTP) server hostname: [] mail.dbvisit.com 
(MAILCFG_USE_SSL) - Use SSL to connect to the mail server (yes/no)? [] no 
(MAILCFG_PORT) - Specify port for SMTP server (usually 25; for SSL, usually 465): [25] 
(MAILCFG_AUTH_USER) - If SMTP server requires username and password,
specify the username. Specify OFF if no login is required: [OFF] 
(MAILCFG_AUTH_PASSWD) - If SMTP server requires username and password,
specify the password. Specify OFF if no login is required: [OFF] 
(MAILCFG_FROM) - Specify the email address to be used as 'From:' address:
[oracle@dbvisit210] oracle@dbvisit210.com 
Following processes are defined:
1: MINE on orcl_dbvisit210
Host: dbvisit210, SMTP: YES, SNMP: NO
2: APPLY on orcl_dbvisit230
Not configured.

 

Add process information for the APPLY process:

Enter number of process to modify it, or "done": [2] 
Fully qualified name of the server for the process (usually co-located with the database, unless mine is offloaded using fetcher): [] dbvisit230 
Enable email notifications about problems (yes/no)? [YES] 
Enable SNMP traps/notifications about problems (yes/no)? [NO] 
Directory with DDC file and default where to create log files etc. (recommended: same as global setting, if possible)? [/home/oracle/orcl] 
Following settings were pre-filled with defaults or your reloaded settings:
----------------------------------------
[APPLY_LISTEN_INTERFACE]: Network listen interface: dbvisit230:7902 
[APPLY_DATABASE]: Database TNS: orcl_dbvisit230 
[TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/11.1.0/db_1/network/admin 
[APPLY_USER]: Replicate database username: dbvrep 
[APPLY_PASSWORD]: Replicate database password: ********* 
[APPLY_STAGING_DIR]: Directory for received plogs: /home/oracle/orcl/apply 
[LOG_FILE]: General log file: /home/oracle/orcl/log/dbvrep_%N_%D.%E 
[LOG_FILE_TRACE]: Error traces: /home/oracle/orcl/log/trace/dbvrep_%N_%D_%I_%U.%E 
Checking that these settings are valid...
Do you want change any of the settings? [no]
Add notification thresholds settings: 
(MAILCFG_SMTP_SERVER) - Specify mail (SMTP) server hostname: [mail.dbvisit.com] 
(MAILCFG_USE_SSL) - Use SSL to connect to the mail server (yes/no)? [no] 
(MAILCFG_PORT) - Specify port for SMTP server (usually 25; for SSL, usually 465): [25] 
(MAILCFG_AUTH_USER) - If SMTP server requires username and password, specify the username.
Specify OFF if no login is required: [OFF] 
(MAILCFG_AUTH_PASSWD) - If SMTP server requires username and password, specify the password.
Specify OFF if no login is required: [OFF] 
(MAILCFG_FROM) - Specify the email address to be used as 'From:' address: [oracle@dbvisit210.com] 
(NOTIFY_ALL_EMAIL) - Specify 'To:' address(es) to receive all emails
(separate multiple addresses by ',') - OFF for empty list
(you can specify success/alert addressee separately later). [OFF] replicate@mycompany.com 
(NOTIFY_SUCCESS_EMAIL) - Specify 'To:' adress(es) for hearbeat/progress emails - OFF for empty list. [OFF] 
(NOTIFY_ALERT_EMAIL) - Specify 'To:' adress(es) for alert (problem-reporting) emails - OFF for empty list. [OFF] 
(NOTIFY_SEQUENCE_DIFFERENCE) - How many plogs (redo plogs) must apply lag behind mine
(or mine behind fetcher) to send notification? [10] 
(NOTIFY_SCN_DIFFERENCE) - How many SCNs must apply lag behind mine to send notification? [1000] 
(NOTIFY_PROGRESS_DIFFERENCE_PERC) - How much must apply lag behind mine for any table to send notification (in %)? [10] 
(NOTIFY_CONFLICT_THRESHOLD) - How many conflicts must apply encounter to send notification? [100] 
(NOTIFY_DAILY_LIST_PROGRESS_TIME24) - When to send periodic progress summary email? (use 24-h format,
separate multiple times by semicolon, e.g. '0630:1230:1830' or OFF to disable) [0700] 
(NOTIFY_SEND_HEARTBEAT_TIME24) - When to send periodic heartbeat email? (use 24-h format,
separate multiple times by semicolon, e.g. '0630:1230:1830' or OFF to disable) [0800:1300] 
Following processes are defined:
1: MINE on orcl_dbvisit210
Host: dbvisit210, SMTP: YES, SNMP: NO
2: APPLY on orcl_dbvisit230
Host: dbvisit230, SMTP: YES, SNMP: NO
Enter number of process to modify it, or "done": [done]