beautypg.com

Advanced replication option, Installation requirements, Upgrading – Oracle A423961 User Manual

Page 103

background image

Advanced

Replication

5 – 7

Database Administration

Advanced Replication Option

This section includes details not contained in the source documents for
the Advanced Replication Option.

Additional Information:

There are many configuration and

usage possibilities with Advanced Replication. For more
information about Advanced Replication, see Oracle7 Server
Distributed Systems, Volume II: Replicated Data
, Oracle7 Server
Concepts
, Oracle7 Server Administrator’s Guide, and other
appropriate documentation.

Installation Requirements

Certain requirements must be met during the installation process for the
Advanced Replication Option to function properly. These installation
requirements are:

advanced replication option must be installed at all sites
participating in replication (both master and updatable snapshot
sites)

PL/SQL and the distributed database option must also be
installed

catproc.sql

and

catalog.sql

must already have been run if

you are not using the starter database

advanced replication option cannot be used with releases prior to
release 7.1.6. All sites must upgrade to Version 7.1.6 or later to use
the advanced replication option

SHARED POOL SIZE must be at least 10MB (this requirement
may be greater depending on your replication needs. If you
receive an error, increase the SHARED POOL SIZE.)

SQL*Net V2. Consult the SQL*Net documentation on how to set
up V2.

You should monitor the installation of the replication scripts and
increase the amount of rollback segment resources as necessary.

Upgrading

If you are migrating from a previous version of Oracle7 Server for
Windows NT and want to use the advanced replication option, you
must first complete the migration (see Migrating from Earlier Oracle7
Versions
in this Guide). After migrating, you can choose the advanced