You are here: TWiki> VOMS Web>VOMSReplicationCNAF (2007-07-17, AndreaCeccanti)


Replication setup

Two oracle databases synchronized using the streams tecnology, across the two db servers VOMSDB1(MASTER) and VOMSDB2 (SLAVE). Connection details are in the tnsnames.ora file.

One VO is deployed, test_replication1. VOMS-Admin (on testbed008) is here. voms on testbed008 listens on port 55001. Contact info in the vomses.

DB Login information

  • username: voms_replication1
  • password = pwdvoms1

This login works on VOMSDB1 and VOMSDB2.



  • Replicated DBs accessible.
  • VOMSDB1 gets populated with fake users.


  • Stop Changes made to VOMSDB1 are not propagated to VOMSDB2. Proof in the attached log file. Waiting for feedback from the oracle group.


  • Capture and propagation frequencies for the oracle streams were incorrectly configured so the updates weren't noticeable. Barbara fixed the configuration and now it looks replication is working fine.
-- AndreaCeccanti - 13 Jul 2007
Topic attachments
I Attachment Action Size Date Who Comment
Texttxt error-log-130707.txt manage 0.8 K 2007-07-13 - 16:00 AndreaCeccanti Replication does not work between VOMSDB1 and VOMSDB2
Unknown file formatora tnsnames.ora manage 0.4 K 2007-07-13 - 15:39 AndreaCeccanti The oracle tnsnames.ora file
Unknown file formatEXT vomses manage 0.1 K 2007-07-13 - 15:40 AndreaCeccanti The vomses file for the test_replication1 VO
Topic revision: r4 - 2007-07-17 - AndreaCeccanti
This site is powered by the TWiki collaboration platformCopyright © 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback