...
Add process information for the MINE processand APPLY processes:
No Format | ||
---|---|---|
| ||
Step 4 - Process configuration ======================================== The fourth step is to configure the replication processes for each replication. Following processes are defined: 1: MINE on orcl_dbvisit210src Not configured. 2: APPLY on orcl_dbvisit230tgt 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):[dbvlin71.dbvisit] Server type (Windows/Linux/Unix): [Linux] dbvisit210 Enable email notifications about problems? (yesYes/noNo)? [NO] YESNo] Enable SNMP traps/notifications about problems? (yesYes/noNo)? [NO] No] Directory with DDC file and default where to create log files etc. (recommended: same as global setting, if possible)? [/home/oracle/orcl] sample] Following settings were pre-filled with defaults or your reloaded settings: ---------------------------------------- [MINE_LISTENREMOTE_INTERFACE]: Network listenremote interface: dbvisit210dbvlin71.dbvisit:7901 [MINE_DATABASE]: Database TNS: orcl_dbvisit210 src [TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/11.12.0/db_1/network/admin [MINE_USERPLOG]: Filemask Replicatefor databasegenerated usernameplogs: 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 /home/oracle/sample/mine/%S.%E (%S is sequence, %T thread, %F original filename (stripped extension), %P process type, %N process name, %E default extension) [LOG_FILE]: General log file: /home/oracle/orclsample/log/dbvrep_%N_%D.%E [LOG_FILE_TRACE]: Error traces: /home/oracle/orclsample/log/trace/dbvrep_%N_%D_%I_%U.%E Checking that these settings are valid... Do you want to change any of the settings? [noNo] (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_dbvisit210src Host: dbvisit210dbvlin71.dbvisit, SMTP: YESNo, SNMP: NONo 2: APPLY on orcl_dbvisit230tgt Not configured. |
Add process information for the APPLY process:
No Format | ||
---|---|---|
| ||
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)[dbvlin72.dbvisit] Server type (Windows/Linux/Unix): [Linux] dbvisit230 Enable email notifications about problems? (yesYes/noNo)? [YESNo] Enable SNMP traps/notifications about problems? (yesYes/noNo)? [NO] No] Directory with DDC file and default where to create log files etc. (recommended: same as global setting, if possible)? [/home/oracle/orclsample] Following settings were pre-filled with defaults or your reloaded settings: ---------------------------------------- [APPLY_LISTENREMOTE_INTERFACE]: Network listenremote interface: dbvisit230dbvlin72.dbvisit:7902 [APPLY_DATABASE]: Database TNS: orcl_dbvisit230 tgt [TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/11.12.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/orclsample/apply [LOG_FILE]: General log file: /home/oracle/orclsample/log/dbvrep_%N_%D.%E [LOG_FILE_TRACE]: Error traces: /home/oracle/orclsample/log/trace/dbvrep_%N_%D_%I_%U.%E Checking that these settings are valid... Do you want to change any of the settings? [noNo] 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_dbvisit210src Host: dbvisit210dbvlin71.dbvisit, SMTP: YESNo, SNMP: NONo 2: APPLY on orcl_dbvisit230tgt Host: dbvisit230dbvlin72.dbvisit, SMTP: YESNo, SNMP: NONo Enter number of process to modify it, or "done": [done] |