How to build an Oracle 8 Advanced Replication Environment

Source: Internet
Author: User

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 how to buildOracle 8System parameters that need to be set during the 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. After learning this article, you must use it flexibly and do not stick to it. I hope you will be able to gain some benefits after learning the above.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.