Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Before installing Dbvisit Replicate please ensure that the following prerequisites are met:

 TaskCommentCompleted?
1Oracle software is installed on source and target servers. The Oracle software version can be different between the source and target servers. 
2Oracle source database is up and running.

We require database to be in ARCHIVELOG mode. To determine if database is in archivelog mode run SQL command:

SQL> archive log list
Example output:
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/oraarch/orcl
Oldest online log sequence 3959
..
 
3Oracle target database is up and running.

We require database to be in ARCHIVELOG mode. To determine if database is in archivelog mode run SQL command:

SQL> archive log list
Example output:
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/oraarch/orcl
Oldest online log sequence 3959
..
 
4Ensure there is enough disk space and available memory for Dbvisit Replicate to runSee System Requirements 
5Ensure Oracle listener is running on the source server  
6Ensure Oracle listener is running on the target server (only if target database is Oracle).  
7Ensure Oracle SQL*Net connection to target database from source database (only if target database is Oracle).

Use tnsping to test if the SQL*Net connection can be made from source server to target database.

 
8Ensure Oracle SQL*Net connection to source database from target database (only if target database is Oracle).Use tnsping to test if the SQL*Net connection can be made from target server to source database.  
9Ensure that the firewall port is opened between the primary and the standby servers for the Dbvisit Replicate ports.

Dbvisit Replicate uses the following default ports for communication between the source and target servers:
- 7901
- 7902
For 2-way replication the default ports are:
- 7901
- 7902
- 7903
- 7904
These ports are configurable and can be changed if required.

 
10Ensure source server name can be resolved to correct IP address (not 127.0.0.1).On source server run: ping source_hostname 
11Ensure target server name can be resolved to correct IP address (not 127.0.0.1).On target server run: ping target_hostname 
12Ensure all data types that need to be replicated are supported by Dbvisit Replicate.Run the SQL query in Supported and Unsupported Datatypes to determine if there are any unsupported datatypes 
13For RAC, ensure all redo threads are on shared storage and accessible by all nodes.  

 

 

 

 

  • No labels