...
| 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 Having target database to be in ARCHIVELOG mode . To determine if database is in archivelog mode run SQL command: SQL> archive log listExample output: Database log mode Archive Mode Automatic archival Enabled Archive destination /oracle/oraarch/orcl Oldest online log sequence 3959 . optional in one-way replication. |
| 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. |
...