This example show an Oracle-to-Oracle one-way replication using the following information.
Click here for prerequisite checklist.
| Server/Database | Name |
|---|---|
| Source database | orcl |
| Source server | dbvisit210 |
| Target database | orcl |
| Target server | dbvisit230 |
| TNS alias for source database: | orcl_dbvisit210 |
| TNS alias for target database | orcl_dbvisit230 |
Throughout the wizard, defaults are shown in [brackets]. Just press enter to accept them. The replication name in this example is "orcl".
dbvrep> setup wizard This wizard configures Dbvisit Replicate to start a replication process. The setup wizard creates configuration scripts, which need to be run after the wizard ends. No changes to the databases are made before that. The progress is saved every time a list of databases, replications, etc. is shown. It will be re-read if wizard is restarted and the same DDC name and script path is selected. Run the wizard now? [yes] Accept end-user license agreement? (view/yes/no) [view] yes Before starting the actual configuration, some basic information is needed. The DDC name and script path determines where all files created by the wizard go (and where to reread them if wizard is rerun) and the license key determines which options are available for this configuration. (DDC_NAME) - Please enter a name for this replication (suggestion: use the name of the source database): [] orcl (LICENSE_KEY) - Please enter your license key (or just enter "(trial)"): [(trial)] (SETUP_SCRIPT_PATH) - Please enter a directory for location of configuration scripts on this machine: [/home/oracle/orcl]
Network configuration (TNS)
Dbvisit Replicate will detect tnsnames.ora locations on your system. Choose the TNS configuration that is applicable.
Network configuration files were detected on this system in these locations: /u01/app/oracle/product/11.1.0/db_1/network/admin /u03/app/oracle/product/11.2.0/dbhome_3/network/admin /u01/app/oracle/product/11.2.0/xe/network/admin (TNS_ADMIN) - Please enter TNS configuration directory for this machine: [/u01/app/oracle/product/11.1.0/db_1/network/admin]
Assure that TNS configuration is same for all the servers involved. Dbvisit Replicate remembers DBID of databases specified in the setup wizard. When dbvrep is then run, it checks these DBIDs to verify the TNS are set consistently across the nodes.
This DBID check is also done when dropping and creating the Replicate user, as these are the first steps in the *-all.sh script.