How to build Oracle 8 Advanced Replication Environment

Oracle advanced replication, also known as symmetric replication. Unlike Oracle's other features, Oracle's advanced replication is not Plug and play, and users must have a deep understanding of how they work and the advantages and disadvantages of various replication scenarios. A deep understanding of the basic concepts of replication can help you design a reliable replication environment.

This paper mainly introduces some system parameters that need to be set up when the Oracle 8 advanced replication environment is built. It is necessary to remind readers that the specific configuration values of these parameters can only guarantee the successful construction of a relatively good advanced replication environment, but this paper does not carry out further in-depth discussion on the optimal configuration of these parameters.

Now we're officially starting. Suppose there are two nodes, and the section names are ORA_BJ and ORA_NB respectively.

1. System environment parameter (Init.ora file) set (for the accurate value)

If you want to build an Oracle 8.0.x advanced replication environment, you must set the following parameters in the initialization file, as shown in table 1.

Table 1:ORACLE8 Advanced replication Environment initialization parameter settings

Parameter name

Recommended values

Note

Processes

100

Shared_pool_size

30000000

At least 30M, if you have a lot of duplicate objects, you need more space.

Large_pool_size

500K

Db_block_buffers

550

Compatible

8.0.5.0

Db_file_multiblock_read_count

16

Dml_locks

100

Sequence_cache_entries

30

Sequence_cache_hash_buckets

23

Global_names

TRUE

Distributed_lock_timeout

300

Distributed_transactions

10

Open_links

6