Before installing Dbvisit Replicate please ensure that the following prerequisites are met:
| Task | Comment | Completed? | |
|---|---|---|---|
| 1 | Oracle software is installed on source and target servers. | The Oracle software version can be different between the source and target servers. | |
| 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 Oracle listener is running on the source server | ||
| 5 | Ensure Oracle listener is running on the target server | ||
| 6 | Ensure Oracle SQL*Net connection to target database from source database. | Use tnsping to test if the SQL*Net connection can be made from source server to target database. | |
| 7 | 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. | |
| 8 | Ensure 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: | |
| 9 | Ensure source server name can be resolved to correct IP address (not 127.0.0.1). | On source server run: ping source_hostname | |
| 10 | Ensure target server name can be resolved to correct IP address (not 127.0.0.1). | On target server run: ping target_hostname | |
| 11 | Ensure all data types that need to be replicated are supported by Dbvisit Replicate. | Run the SQL query in Supported and not supported Datatypes to determine if there are any unsupported datatypes | |
| 12 | For RAC, ensure all redo threads are on shared storage and accessible by all nodes. |