Versions Compared

Old Version 4

changes.mady.by.user Arjen Visser

Saved on

compared with

New Version 5

changes.mady.by.user Arjen Visser

Saved on

Key

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

...

 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 Oracle listener is running on the source server  
5Ensure Oracle listener is running on the target server  
6Ensure Oracle SQL*Net connection to target database from source database.

Use tnsping to test if the SQL*Net connection

is working

can be made from source server to target database.

 
7Ensure Oracle SQL*Net connection to source database from target database.Use tnsping to test if the SQL*Net connection is workingcan be made from target server to source database.  
8Ensure 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:
- 7890
- 7891
For 2-way replication the default ports are:
- 7890
- 7891
- 7892
- 7893
These ports are configurable and can be changed if required.

 
9Ensure source server name can be resolved to correct IP address (not 127.0.0.1).On source server run: ping source_hostname 
10Ensure target server name can be resolved to correct IP address (not 127.0.0.1).On target server run: ping target_hostname 
11Ensure 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 
12For RAC, ensure all redo threads are on shared storage and accessible by all nodes.  

...