How to build an Oracle 8 Advanced Replication Environment

Oracle Advanced Replication, also known as symmetric replication. Unlike other Oracle functions, Oracle Advanced Replication is not plug-and-play. Users must have a deep understanding of how it works and the advantages and disadvantages of various replication solutions. A deep understanding of the basic concepts of replication helps you design a reliable replication environment.

This article mainly introduces some system parameters that need to be set when setting up the Oracle 8 Advanced Replication environment. It should be noted that the specific configuration values of these system parameters provided by the author can only ensure that a relatively good Advanced Replication environment can be established successfully, however, this article does not further discuss the optimization configurations of these parameters.

Now we officially start. Assume there are two nodes named ora_bj and ora_nb respectively.

1. The system environment parameter init. ora file)

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: initialization parameter settings of Oracle8 Advanced Replication Environment

Parameter Name

Recommended Value

Remarks

Processes

100

Shared_pool_size

30000000

At least 30 M. If there are many replication objects, more space is required.

Large_pool_size

500 K

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

If there are many replication nodes, you need to add

Sort_area_size

1000000

Db_name

ORA_BJ

Or ORA_NB

Job_queue_processes

6

Job_queue_interval

60

Parallel_max_servers

10

Only applicable to parallel propagation

Parallel_min_servers

2

Only applicable to parallel propagation

PEPLICATION_DEPENDENCY_TRACKING

True

If parallel propagation is adopted, it must be set to TRUE.

The recommended values of each parameter in Table 1 assume that the current replication environment has only two nodes and a simple Advanced Replication environment. If there are many nodes and the replication relationship is complex, if there are many tables to be copied, you need to increase the value of some parameters accordingly, which can be obtained through modifying different parameter experiments.

Delete all the SNAPSHOT _ or JOB_QUEUE_KEEP_CONNECTIONS parameters because these parameters are not supported by oracle8.

2. Net8 parameter file

(1) sqlnet. ora File Settings

Automatic_ipc = off

Names. default_domain = world

Name. default_zone = world

Sqlnet. expire_time = 0

DISABLE_OOB = ON

(2) tnsnames. ora File Settings

ORA_BJ.world =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (Host = 80.24.16.201) (Port = 1521 ))

(CONNECT_DATA = (SID = ORA8 ))

)

ORA_NB.world =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP) (Host = 80.24.16.14) (Port = 1521 ))

(CONNECT_DATA = (SID = ORA8 ))

)

The above Host is the IP address of each replication node. If there are many replication nodes, all are added to the tnsnames. ora file. In this example, there are two nodes.

3. tablespace

If you build an Oracle 8 advanced Advanced Replication environment, you need to increase the number of tablespaces. Table 2 is the recommended initial tablespace.

Table 2: Oracle System tablespace size settings

Tablespace

Recommended initial values

SYSTEM

At least 20 M

ROLLBACK SEGMENTS

At least 20 M

TEMPORARY

At least 10 M

TOOLS

At least 20 M

In addition, we recommend that you set the size of the next partition of the rollback segment to at least 100 kb.

The above recommended settings are space settings in a small replication environment. If there are many tables to be copied, the daily change volume is large, and the replication node is complex, the tablespace size needs to be increased accordingly.