...
No Format | ||
---|---|---|
| ||
###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: dbvlin701source_machine.dbvisit.co.nz OS: Linux email_notify: No snmp_notify: No SETUP_SCRIPT_PATH: /home/oracle/repfileexample change: No process#: 2 hostname: dbvlin702target_machine.dbvisit.co.nz OS: Linux email_notify: No snmp_notify: No SETUP_SCRIPT_PATH: /home/oracle/repfileexample change: No process#: done |
You now have a template file. If are going to run the Setup Wizard again for different machines you can edit the response file, put in the appropriate server names, users, pwds, etc and then run the Setup Wizard again with the response file. This will then create all of the appropriate files that you need. In the example we rename the file to rtest-sample_response_file.txt and then edit the fields.
Run the Setup Wizard with the new response file:
No Format | ||
---|---|---|
| ||
oracle@source_machine[/home/oracle/v28/replicate]: ./dbvrep setup wizard respfile /home/oracle/rtest/rtest-sample_response_file.txt |
The Setup Wizard will now run without prompting or waiting for answers. It will populate all of the answers from the response file. The end result will be as if you went through the Setup Wizard. Files and scripts will be waiting in the new location specified.