Oracle A423961 Manuel d'utilisateur télécharger pdf (Page 105)

5 – 9Database Administration

Initialization Parameters for Advanced Replication

The following initialization parameters must be set or added to the

INITsid.ORA file (recommended values are included):

Master Site Parameters

Parameter Name Recommended Value

COMPATIBLE 7.3.2

SHARED_POOL_SIZE at least 10 MB

DISTRIBUTED_LOCK_TIMEOUT 300 seconds

DISTRIBUTED_TRANSACTIONS 5

GLOBAL_NAMES TRUE

OPEN_LINKS 4

PROCESSES add 9 to current value

JOB_QUEUE_PROCESSES 2 (depends on number

of n–way sites)

JOB_QUEUE_INTERVAL 10 seconds

JOB_QUEUE_KEEP_CONNECTIONS FALSE

Note:

A practical limit of 10 Master Sites can be set up.

Snapshot Site Parameters (add these parameters for snapshot sites)

Parameter Name Recommended Value

SNAPSHOT_REFRESH_PROCESSES 2

SNAPSHOT_REFRESH_INTERVAL 60 seconds

SNAPSHOT_REFRESH_KEEP_CONNECTIONS FALSE

Setup Procedures

After setting up the INITsid.ORA file with the initialization parameters

for Advanced Replication, run SVRMGR23. Connect as

INTERNAL/password and start the database. Once the database has

started, execute the script: CATREP.SQL. The script can be found in the

%ORACLE_HOME%\RDBMS73\ADMIN directory. It will take

approximately one hour to run. A good idea is to spool to a log file first

before running CATREP.

1 2 ... 100 101 102 103 104 105 106 107 108 109 110 ... 201 202

Pas de commentaire

Oracle A423961 Manuel d'utilisateur Page 105