We're here to help!

Step 4- Process Configuration

Follow
Step 4 - Process configuration
========================================
The fourth step is to configure the replication processes for each replication.
 
Following processes are defined:
1: FETCHER on SOURCEDB
  Not configured.
2: MINE on SOURCEDB
  Not configured.
3: APPLY on RDSTGT
  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): [dbvlin210.dbvisit.co.nz]

 

 

Server type (Windows/Linux/Unix): [Linux]

 

 

Enable email notifications about problems (yes/no)? [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/TEST_FETCH]

 

 

Following settings were pre-filled with defaults or your reloaded settings:
----------------------------------------
[FETCHER_REMOTE_INTERFACE]: Network remote interface: dbvlin210.dbvisit.co.nz:7901
[FETCHER_DATABASE]: Database TNS: SOURCEDB
[TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/11.2.0/db_1/network/admin
[LOG_FILE]: General log file: /home/oracle/TEST_FETCH/log/dbvrep_%N_%D.%E
[LOG_FILE_TRACE]: Error traces: /home/oracle/TEST_FETCH/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: FETCHER on SOURCEDB
  Host: dbvlin210.dbvisit.co.nz, SMTP: no, SNMP: no
2: MINE on SOURCEDB
  Not configured.
3: APPLY on RDSTGT
  Not configured.
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): [dbvlin210.dbvisit.co.nz] ec2-54-82-47-176.compute-1.amazonaws.com

 

 

Server type (Windows/Linux/Unix): [Linux]

 

 

Enable email notifications about problems (yes/no)? [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/TEST_FETCH]

 

 

Following settings were pre-filled with defaults or your reloaded settings:
----------------------------------------
[MINE_REMOTE_INTERFACE]: Network remote interface: ec2-54-82-47-176.compute-1.amazonaws.com:7902
[MINE_DATABASE]: Database TNS: SOURCEDB
[TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/11.2.0/db_1/network/admin
[MINE_STAGING_DIR]: Directory for files from fetcher: /home/oracle/TEST_FETCH/mine_stage
[MINE_PLOG]: Filemask for generated plogs: /home/oracle/TEST_FETCH/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/TEST_FETCH/log/dbvrep_%N_%D.%E
[LOG_FILE_TRACE]: Error traces: /home/oracle/TEST_FETCH/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: FETCHER on SOURCEDB
  Host: dbvlin210.dbvisit.co.nz, SMTP: no, SNMP: no
2: MINE on SOURCEDB
  Host: ec2-54-82-47-176.compute-1.amazonaws.com, SMTP: no, SNMP: no
3: APPLY on RDSTGT
  Not configured.
Enter number of process to modify it, or "done": [3]

 

 

Fully qualified name of the server for the process (usually co-located with the database, unless mine is offloaded using fetcher): [ip-10-139-39-29] ec2-54-82-47-176.compute-1.amazonaws.com

 

 

Server type (Windows/Linux/Unix): [Linux]

 

 

Enable email notifications about problems (yes/no)? [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/TEST_FETCH]

 

 

Following settings were pre-filled with defaults or your reloaded settings:
----------------------------------------
[APPLY_REMOTE_INTERFACE]: Network remote interface: ec2-54-82-47-176.compute-1.amazonaws.com:7903
[APPLY_DATABASE]: Database TNS: RDSTGT
[TNS_ADMIN]: tnsnames.ora path: /u01/app/oracle/product/11.2.0/db_1/network/admin
[APPLY_STAGING_DIR]: Directory for received plogs: /home/oracle/TEST_FETCH/apply
[LOG_FILE]: General log file: /home/oracle/TEST_FETCH/log/dbvrep_%N_%D.%E
[LOG_FILE_TRACE]: Error traces: /home/oracle/TEST_FETCH/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: FETCHER on SOURCEDB
  Host: dbvlin210.dbvisit.co.nz, SMTP: no, SNMP: no
2: MINE on SOURCEDB
  Host: ec2-54-82-47-176.compute-1.amazonaws.com, SMTP: no, SNMP: no
3: APPLY on RDSTGT
  Host: ip-10-139-39-29, SMTP: no, SNMP: no
Enter number of process to modify it, or "done": [done]

 

 

Created file /home/oracle/TEST_FETCH/TEST_FETCH-APPLY.ddc.
Created file /home/oracle/TEST_FETCH/TEST_FETCH-FETCHER.ddc.
Created file /home/oracle/TEST_FETCH/TEST_FETCH-MINE.ddc.
Created file /home/oracle/TEST_FETCH/config/TEST_FETCH-setup.dbvrep.
Created file /home/oracle/TEST_FETCH/config/TEST_FETCH-dbsetup_SOURCEDB.sql.
Created file /home/oracle/TEST_FETCH/config/TEST_FETCH-dbsetup_RDSTGT.sql.
Created file /home/oracle/TEST_FETCH/config/TEST_FETCH-grants_SOURCEDB.sql.
Created file /home/oracle/TEST_FETCH/config/TEST_FETCH-grants_RDSTGT.sql.
Created file /home/oracle/TEST_FETCH/config/TEST_FETCH-onetime.ddc.
Created file /home/oracle/TEST_FETCH/start-console.sh.
Created file /home/oracle/TEST_FETCH/TEST_FETCH-run-dbvlin210.dbvisit.co.nz.sh.
Created file /home/oracle/TEST_FETCH/TEST_FETCH-run-ec2-54-82-47-176.compute-1.amazonaws.com.sh.
Created file /home/oracle/TEST_FETCH/TEST_FETCH-run-ip-10-139-39-29.sh.
Created file /home/oracle/TEST_FETCH/Nextsteps.txt.
Created file /home/oracle/TEST_FETCH/TEST_FETCH-all.sh.
=============================================================================================================================================


Dbvisit Replicate wizard completed


Script /home/oracle/TEST_FETCH/TEST_FETCH-all.sh created. This runs all the above created scripts. Please exit out of dbvrep, review and run
script as current user to setup and start Dbvisit Replicate.
=============================================================================================================================================
Optionally, the script can be invoked now by this wizard.
Have more questions? Submit a request

Comments