Corporation Server User Manual

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.