Before installing Dbvisit Replicate please ensure that the following prerequisites are met:
| Anchor | ||||
|---|---|---|---|---|
|
| Task | Comment | |
|---|---|---|
| 1 | Oracle software is installed on source and target servers. | The Oracle software version can be different between the source and target servers.Dbvisit Replicate supports Oracle 9.2 and later. |
| 2 | Oracle 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 |
| 3 | Oracle 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 |
| 4 | Ensure there is enough disk space and available memory for Dbvisit Replicate to run | See System Requirements |
| 5 | Ensure Oracle listener is running on the source server | |
| 6 | Ensure Oracle listener is running on the target server (only if target database is Oracle). | |
| 7 | Ensure 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. |
| 8 | Ensure Oracle SQL*Net connection to source database from target database. | Use tnsping to test if the SQL*Net connection can be made from target server to source database. |
| 9 | Ensure that the firewall port is opened between the source and the target servers for the Dbvisit Replicate ports. | Dbvisit Replicate uses the following default ports for communication between the source and target servers: |
| 10 | Ensure source server name can be resolved to correct IP address (not 127.0.0.1). | On source server run: ping source_hostname |
| 11 | Ensure target server name can be resolved to correct IP address (not 127.0.0.1). | On target server run: ping target_hostname |
| 12 | Ensure 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 |
| 13 | For RAC, ensure all redo threads are on shared storage and accessible by all nodes. |
| Anchor | ||||
|---|---|---|---|---|
|
| Task | Comment | Comment |
|---|---|---|
| 1 | Oracle software is installed on source server. | Dbvisit Replicate supports Oracle 9.2 and later. |
| 2 | SQL Server is installed on target servers. | Dbvisit Replicate supports SQL Server 2005 and later |
| 3 | Oracle 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 |
| 4 | Ensure there is enough disk space and available memory for Dbvisit Replicate to run. | See System Requirements |
| 5 | Ensure Oracle listener is running on the source server. | |
| 6 | Ensure Oracle SQL*Net connection to source database from target database. | Use tnsping to test if the SQL*Net connection can be made from target server to source database. Click here for more information |
| 7 | Ensure that the firewall port is opened between the source and the target 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. |
| 8 | Ensure source server name can be resolved to correct IP address (not 127.0.0.1). | On source server run: ping source_hostname |
| 9 | Ensure target server name can be resolved to correct IP address (not 127.0.0.1). | On target server run: ping target_hostname |
| 10 | Ensure 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 in source database. Few datatypes can not be replicated from Oracle to SQL Server. Click here for more information. |
| 11 | For RAC, ensure all redo threads are on shared storage and accessible by all nodes. | |
| 12 | Ensure that the firewall port is opened on the target server for SQL Server. | SQL Server uses 1433 port by default. |
| 13 | Remote connection is enabled in SQL Server. | |
| 14 | User must have required privileges. | Dbvisit Replicate creates dbvrep database in SQL Server as metadata repository followed by executing SQL statements through APPLY service. You can either use single username or two different usernames for each task. |
| 15 | System DSN connecting to SQL Server must exist. | System DSN is required for executing *-all.bat script that configures source and target database for replication and to run APPLY service. Click here for more information. |
| Anchor | ||||
|---|---|---|---|---|
|
...
Replication : Prerequisite Checklist
| Task | Comment | Comment |
|---|---|---|
| 1 | Oracle software is installed on source server. | Dbvisit Replicate supports Oracle 9.2 and later. |
| 2 | MySQL is installed on target servers. | Dbvisit Replicate supports MySQL 4 and later. |
| 3 | Oracle 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 |
| 4 | Ensure there is enough disk space and available memory for Dbvisit Replicate to run. | See System Requirements |
| 5 | Ensure Oracle listener is running on the source server. | |
| 6 | Ensure Oracle SQL*Net connection to source database from target database. | Use tnsping to test if the SQL*Net connection can be made from target server to source database. Click here for more information |
| 7 | Ensure that the firewall port is opened between the source and the target 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. |
| 8 | Ensure source server name can be resolved to correct IP address (not 127.0.0.1). | On source server run: ping source_hostname |
| 9 | Ensure target server name can be resolved to correct IP address (not 127.0.0.1). | On target server run: ping target_hostname |
| 10 | Ensure 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 in source database. Few datatypes can not be replicated from Oracle to MySQL. Click here for more information. |
| 11 | For RAC, ensure all redo threads are on shared storage and accessible by all nodes. | |
| 12 | Ensure that the firewall port is opened on the target server for SQL Server. | MySQL uses 3306 port by default. |
| 13 | User must have required privileges. | Dbvisit Replicate creates dbvrep database in MySQL as metadata repository followed by executing SQL statements through APPLY service. You can either use single username or two different usernames for each task. Use "grant all privileges on *database.* to 'username'@'%' identified by 'userpassword' " command. |
...