Oracle A423961 Manual Do Utilizador
5 – 9
Database Administration
Initialization Parameters for Advanced Replication
The following initialization parameters must be set or added to the
INITsid.ORA file (recommended values are included):
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)
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.
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.