There are times when you may want to set up replication without going through the Setup Wizard. To that end, Dbvisit Replicate has the response file. A sample response file is created after you run the Setup Wizard one time. The file is called, name_of_your_replication-sample_response_file.txt. For example,
repfileexample-sample_response_file.txt or
demo-sample_response_file.txt
The file is created in the directory specified in the Setup Wizard along with all of the other files. The contents of the response file are all of the answers that you supplied to the Setup Wizard.
Contents of Response file:
No Format | ||
---|---|---|
| ||
EXAMPLE ======###Version of response file: 2.8.00 accept_license: yes DDC_NAME: repfileexample LICENSE_KEY: (trial) Replicate_edition: MAX SETUP_SCRIPT_PATH: /home/oracle/repfileexample TNS_ADMIN: /u01/app/oracle/product/11.2.0/db_1/network/admin ###Step 1 store_passwords: Yes rdbms: Oracle TNS_alias: SDB11 sysuser: SYS syspassword: pwd systemuser: SYSTEM systempassword: pwd dbvuser: dbvrep dvbpassword: dbvpasswd tablespace: DATA temp_tablespace: TEMP database#: add rdbms: Oracle TNS_alias: TDB11 sysuser: SYS syspassword: pwd systemuser: SYSTEM systempassword: pwd dbvuser: dbvrep dvbpassword: dbvpasswd tablespace: DATA temp_tablespace: TEMP database#: done ###Step 2 source db: 1 target db: 2 enable_ddl: Yes use_fetcher: No suplog_all: YES encrypt_network: No compress_network: No network_timeout: 60 prepare_type: single-scn instantiate_type: load load_create_or_keep: keep pair#: done ###Step 3 pair#: 1 tables_and_schemas: SCOTT add_more: No plsql_schemas: rename_or_filter: No PREPARE_SCHEMA_EXCEPTIONS: pair#: done ###Step 4 process#: 1 hostname: dbvlin701.dbvisit.co.nz OS: Linux email_notify: No snmp_notify: No SETUP_SCRIPT_PATH: /home/oracle/repfileexample change: No process#: 2 hostname: dbvlin702.dbvisit.co.nz OS: Linux email_notify: No snmp_notify: No SETUP_SCRIPT_PATH: /home/oracle/repfileexample change: No process#: done |