Step by Step Configuration Example

This example show an Oracle-to-Oracle one-way replication using the following information.

Click here for prerequisite checklist.

Server/DatabaseName
Source databaseorcl
Source serverdbvisit210
Target databaseorcl
Target serverdbvisit230
TNS alias for source database:   orcl_dbvisit210
TNS alias for target databaseorcl_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.
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] 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:
[(trial)]                                                                                                                     

Which Replicate edition do you want to trial (LTD/XTD/MAX):
[MAX]                                                                                                             

(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.

Â