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 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
dbvisit230
[TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/11.1.0/db_1/network/ admin
admin
[APPLY_USER]: Replicate database username: dbvrep dbvrep
[APPLY_PASSWORD]: Replicate database password: *********
[APPLY_STAGING_DIR]: Directory for received plogs: /home/oracle/orcl/ apply
apply
[LOG_FILE]: General log file: /home/oracle/orcl/log/dbvrep_%N_%D. %E
%E
[LOG_FILE_TRACE]: Error traces: /home/oracle/orcl/log/trace/dbvrep_%N_%D_%I_%U. %E
%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] |