Versions Compared

Old Version 18

changes.mady.by.user Arjen Visser

Saved on

compared with

New Version 19

changes.mady.by.user Arjen Visser

Saved on

Key

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

Before installing Dbvisit Replicate please ensure that the following prerequisites are met.

Dbvisit Replicate software can be run with any OS user id except root. It does not have to be the same user id as the Oracle software. However, file system read access to the redo and archive logs is required and that is why the user has to be part of the oinstall or dba group. If ASM is used on MINE, a bequeath connection must be made to the ASM instance and the user may also have to be a member of the sysasm group.

Anchor
prerequisite_o_o
prerequisite_o_o
Oracle to Oracle Replication : Prerequisite Checklist

 TaskComment
1Oracle 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.
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:

No Format
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.

Having target database in ARCHIVELOG mode is optional in one-way replication.

4Ensure there is enough disk space and available memory for Dbvisit Replicate to runSee System Requirements
5Ensure Oracle listener is running on the source server 
6Ensure Oracle listener is running on the target server (only if target database is Oracle). 
7Ensure 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.

8Ensure 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.
9Ensure 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.

10Ensure source server name can be resolved to correct IP address (not 127.0.0.1).On source server run: ping source_hostname
11Ensure target server name can be resolved to correct IP address (not 127.0.0.1).On target server run: ping target_hostname
12Ensure all data types that need to be replicated are supported by Dbvisit Replicate.Run the SQL query in Supported Datatypes to determine if there are any unsupported datatypes
13For RAC, ensure all redo threads are on shared storage and accessible by all nodes. 
14For AIX, please ensure the following packages are installed

These are available from the install CD or the IBM website:

No Format
bos.adt.libm
bos.adt.debug

These packages need to be installed as root using smit.

15Dbvisit Replicate software can be run with any OS user id except root. It does not have to be the same user id as the Oracle software. However, file system read access to the redo and archive logs is required and that is why the user has to be part of the oinstall or dba group. If ASM is used on MINE, a bequeath connection must be made to the ASM instance and the user may also have to be a member of the sysasm group. 

 

Anchor
prerequisite_o_s
prerequisite_o_s
Oracle to SQL Server Replication : Prerequisite Checklist

...