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]
Â
Â