O'Reilly logo

Oracle Distributed Systems by Charles Dye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Getting Started

Before setting up tables for replication, you must complete the preliminary tasks described in Chapter 10. These tasks include the following:

  • Determining and setting initialization parameters appropriately

  • Sizing rollback segments and redo logs

  • Running catproc.sql and catrep.sql (and optionally catrepad.sql )

  • Creating administrative accounts with appropriate privileges

  • Creating necessary database links

If you have accomplished these tasks, you are ready to create replication groups, configure tables, and other objects for replication and add master databases.

The Quick-and-Dirty Setup

Many people want to configure objects for replication as quickly and simply as possible so that they can get a sense of the administration and performance considerations and to learn about how replication works firsthand. To speed these people on their way, the steps required to set up a bare-bones replicated environment are included here. The main distinction between thisminimal configuration and one that is appropriate for production is that it does not include any conflict resolution logic.

Warning

Although these steps will indeed create a replicated environment, it is not suitable for a production installation because it does not take conflicts into account, rendering it anything but robust.

This procedure assumes that you have set the proper initialization parameters, run the required catalog scripts, and created necessary database links and administrative accounts. Now, with no further ado, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required