Versions Compared

Old Version 1

changes.mady.by.user Copy Space for Confluence

Saved on

compared with

New Version 2

changes.mady.by.user Chris Lawless

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

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

 

No Format
bgColorCCC
oracle@dbvlin701[/home/oracle/v28/replicate]:  ./dbvrep

Initializing......done
Dbvisit Replicate version 2.8
Copyright (C) Dbvisit Software Limited.  All rights reserved.

No DDC file loaded.

Run "setup wizard" to start the configuration wizard or try "help" to see all commands available.

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? [yesYes] yes                                                                                               

Accept end-user license agreement? (View/Yes/No) [View] 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): [] orclsample                                                         

(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/sample]                  (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.

No Format
bgColorCCC
Network configuration files were detected on this system in these locations:
/u01/app/oracle/product/1110.12.0/db_1/network/admin
/u03u01/app/oracle/product/11.2.0/dbhomedb_31/network/admin
/u01/app/oracle/product/1112.21.0/xedb_1/network/admin

(TNS_ADMIN) - Please enter TNS configuration directory for this machine:                                                  [/u01/app/oracle/product/1110.12.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.

...

  /u01/app/oracle/product/11.2.0/db_1/network/admin