Versions Compared

Key

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

...

For each replication pair, the source and target servers and processes have to be configured. For simplicity, email and smtp notification has been turned off.

All the defaults can be chosen. 

Section
Column
width5%

 

Column
width95
Panel
bgColorCCC

Step 4 - Process configuration
========================================
The fourth step is to configure the replication processes for each replication. Although most options have reasonable defaults, manual input is required.

Following processes are defined:
1: MINE on orcl
Not configured.
2: APPLY on test11202
Not configured.
3: MINE1 on test11202
Not configured.
4: APPLY1 on orcl
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): [rac11202node1]
Enable email notifications about problems (yes/no)? [YES] NO
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: rac11202node1:7901
[MINE_DATABASE]: Database TNS: orcl
[TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin
[MINE_USER]: Replicate database username: dbvrep
[MINE_PASSWORD]: Replicate database password: *********
[ORACLE_HOME]: ASM ORACLE_HOME: /u01/app/11.2.0/grid
[MINE_PLOG]: Filemask for generated plogs: /home/oracle/orcl/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/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]

Following processes are defined:
1: MINE on orcl
Host: rac11202node1, SMTP: NO, SNMP: NO
2: APPLY on test11202
Not configured.
3: MINE1 on test11202
Not configured.
4: APPLY1 on orcl
Not configured.
Enter number of process to modify it, or "done": [2]
<usually co-located with the database, unless mine is offloaded using fetcher): [dbvisit400.dbvisit.com]
Enable email notifications about problems (yes/no)? [YES] NO
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: dbvisit400.dbvisit.com:7902
[APPLY_DATABASE]: Database TNS: test11202
[TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/11.2.0/dbhome_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]

Following processes are defined:
1: MINE on orcl
Host: rac11202node1, SMTP: NO, SNMP: NO
2: APPLY on test11202
Host: dbvisit400.dbvisit.com, SMTP: NO, SNMP: NO
3: MINE1 on test11202
Not configured.
4: APPLY1 on orcl
Not configured.
Enter number of process to modify it, or "done": [3]
<usually co-located with the database, unless mine is offloaded using fetcher): [dbvisit400.dbvisit.com]
Enable email notifications about problems (yes/no)? [YES] NO
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: dbvisit400.dbvisit.com:7903
[MINE_DATABASE]: Database TNS: test11202
[TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin
[MINE_USER]: Replicate database username: dbvrep
[MINE_PASSWORD]: Replicate database password: *********
[MINE_PLOG]: Filemask for generated plogs: /home/oracle/orcl/mine1/%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/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]

Following processes are defined:
1: MINE on orcl
Host: rac11202node1, SMTP: NO, SNMP: NO
2: APPLY on test11202
Host: dbvisit400.dbvisit.com, SMTP: NO, SNMP: NO
3: MINE1 on test11202
Host: dbvisit400.dbvisit.com, SMTP: NO, SNMP: NO
4: APPLY1 on orcl
Not configured.
Enter number of process to modify it, or "done": [4]
Fully qualified name of the server for the process (usually co-located with the database, unless mine is offloaded using fetcher): [rac11202node1]
Enable email notifications about problems (yes/no)? [YES] NO
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: rac11202node1:7904
[APPLY_DATABASE]: Database TNS: orcl
[TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin
[APPLY_USER]: Replicate database username: dbvrep
[APPLY_PASSWORD]: Replicate database password: *********
[APPLY_STAGING_DIR]: Directory for received plogs: /home/oracle/orcl/apply1
[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]

Following processes are defined:
1: MINE on orcl
Host: rac11202node1, SMTP: NO, SNMP: NO
2: APPLY on test11202
Host: dbvisit400.dbvisit.com, SMTP: NO, SNMP: NO
3: MINE1 on test11202
Host: dbvisit400.dbvisit.com, SMTP: NO, SNMP: NO
4: APPLY1 on orcl
Host: rac11202node1, SMTP: NO, SNMP: NO
Enter number of process to modify it, or "done": [done]

...