Versions Compared

Old Version 6

changes.mady.by.user KrupeshD (Deactivated)

Saved on

compared with

New Version 7

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 there is enough disk space and available memory for Dbvisit Replicate to runSee Dbvisit Replicate system requirements 
5Ensure Oracle listener is running on the source server  
56Ensure Oracle listener is running on the target server  
67Ensure 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.

 
78Ensure 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.  
89Ensure 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.

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

...