Oracle Advanced Replication, also known as symmetric copy. And other features of different Oracle, Oracle's Advanced Replication is not a plug and play, the user must deeply understand how they work and the advantages and disadvantages of the various replication options. Deep understanding of the basic concepts of replication can help you design a reliable replication environment.
This paper introduces the advanced replication environment, Oracle 8 structures need to set some system parameters. Need to remind readers that the author of these system parameters given in the specific configuration values can only guarantee the success of a relatively good set up advanced replication environment, but this is not the optimal allocation of these parameters further in-depth Discussion.
Now we started. Suppose there are two nodes, node name, respectively ora_bj and ora_nb.
1. The system of environmental parameters (init.ora file) set (for non-do Province, value)
If you want to set up Oracle 8.0.x Senior replication environment, you must set the following parameters in the initialization file, see Table 1 below.
Table 1: Oracle8 advanced replication environment, set the initialization parameter
Parameter name
Recommended value
Notes
processes
100
shared_pool_size
30,000,000
At least 30M, if there is a lot of copying the object, then the need for 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
Copy the node number of words, need to increase
Sort_area_size
1000000
db_name
ORA_BJ
Or ORA_NB
job_queue_processes
6
job_queue_interval
60th
parallel_max_servers
10
Only applies to parallel communication
parallel_min_servers
2
Only applies to parallel communication
PEPLICATION_DEPENDENCY_TRACKING
true
If the parallel transmission, must be set to TRUE
Table 1 Recommended values of each parameter that a copy of the current environment, only two nodes, a simple high-level replication environment, if the node is more complex relationships and reproduction, many also need to copy the table, you need to increase the number of parameters corresponding value, which can test by modifying the different parameters obtained.
All the SNAPSHOT_ or JOB_QUEUE_KEEP_CONNECTIONS parameters are deleted because oracle8 no longer support these arguments later.
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 set
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))
)
Host for each copy above node IP address, if a lot of copy nodes, then all added to the tnsnames.ora file, in this case there are two nodes.
3. Tablespace
If you set up Oracle 8 senior high replication environment, the additional need to increase the number of table space, table 2 is the proposed initial table space.
Table 2: Oracle system table space set
Table space
The initial value of the proposed
SYSTEM
At least 20M
ROLLBACK SEGMENTS
At least 20M
TEMPORARY
At least 10M
TOOLS
At least 20M
At the same time, I also recommend the size of a district under the rollback set at least 100K.
The above set of these recommendations is a smaller copy of the space environment settings. If you want to copy the table many, the daily variation of large, complex replication nodes, you need to increase table space size accordingly.