Versions Compared

Key

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

...

Add process information for the MINE processand APPLY processes:

No Format
bgColorCCC
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
bgColorCCC


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]