Step by Step configuration of OID Multi Master Replication - LDAP based in OID 11g

Step by Step configuration of OID Multi Master Replication – LDAP based in OID 11g

I discussed about OID replication concepts like supplier, consumer , replication agreement , ASR (Database Advanced Server Replication) vs LDAP based replication here and here

You can see Mahendra’s post on OID Multi-Master replication here and steps to configure OID 11g LDAP based multi-master replication here

Steps to configure OID in multi-master replication with screenshots are covered in My Oracle Support Note 1052278.1 How to Setup 11g OID Multimaster Replication.
In this post I am going to cover key points that supplement note 1052278.1 How to Setup 11g OID Multimaster Replication

Why and when to implement OID multi-master replication ?
OID uses Oracle database as its persistent store both for configuration and user data. For high availability (as shown on left side of above image) in one data center, you can configure two or more OID nodes connected to RAC Database (RAC database provides high availability for OID database). You can configure two OID application tier instances connected to same RAC database using steps in EDG here.

For OID high availability across sites (two data centers situated miles apart) or in situation where you don’t have RAC database license, You can achieve high availability across sites using OID Multi-Master replication. In OID multi-master replication, OID is always available (Active-Active) on both Primary and Standby site. Change on OID@standby are replicated to OID@Primary and vice versa and two OID’s remain in sync.

How OIDs configured in Multi-Master remain in sync ?
You can configure two or more OID’s in multi-master replication either using LDAP based replication (LDAP commands using change log are used to keep to OID stores in sync) or ASR based replication (database advanced replication feature is used to sync two OID stores)

Note1: LDAP based replication is preferred replication
Note2: ASR based replication is mandatory if you are using 10g SSO (OSSO)

Things good to know for OID LDAP based multi-master replication
1) If you have two OID application nodes (node1 & node2) connected to same OID database (RAC_DB1) and two another OID application nodes (node3 & node4) connected to second OID database (RAC_DB2) as shown in figure above, then to configure multi master replication between a) node1/2 with RACDB1 and b) node3/4 with RACDB2
a) configure/start OID replication daemon OIDREPLD only on one of two nodes from OID1 or OID2
and
b) configure/start OID replication daemon OIDREPLD only on one of two nodes from OID3 or OID04

2) You can configure OID Multi-master replication using Replication Wizard (using Enterprise Manager) or command line tool (remtool)
Note: Replication Wizard (via enterprise manager) is recommended approach to configure OID multi-master replication

3) You can configure replication on SSL or Non SSL. If you wish to configure replication on SSL then use LDAP SSL port between members of replication nodes

4) Bootstrap is the process to initially loading existing data (including OID schema extension) from one OID to another OID member in replication . You can bootstrap by selecting checkbox as shown below during configuration.

Note: Do not select bootstrap for both the replication members

More on OID multi master replication attributes and replication daemons in next post

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

7 comments

» OID 11g LDAP based Multi Master replication : Configuration Entries you must know Online Apps DBA: One Stop Shop for Apps DBA’s says October 7, 2012

[…] byAtul Kumar in oid I discussed about OID multi-master replication (LDAP based) in OID 11g here , In this post I am going to answer some of the question about OID replication that an OID […]

IgnitedMind says January 24, 2013

Hi Atul,

Will this work for cross domain as well ?

I mean I have two OID in different domain, can I use Multi Master Replica or DIP Sync to synchronize ?

Any Specific env/confg req at both end ?

Help Appreciated

Atul Kumar says January 24, 2013

@ IgnotedMind,
When you say cross domain here you mean different enterprise domain or network (and does not mean WebLogic Domain)

Yes this will work cross domain as long as two OID’s can talk to each other over LDAP (OID listener port)

Nothing specific requirement as long as each OID is in different Database and OID listener (LDAP) port is open across two domains where OIDs are deployed.

abhi says August 7, 2013

Hi atul

I want to connect oracle db via ldap.I have installed oraclercu,weblogic,oracle identity manage.I created users and roles in OID.But now im stuck and i am not understanding how should connect my oracle db with ldap.I enter the credential like cn=users,dc=com and enter the host where my OID error is running and port number 3131 and 3160 but nothing is working for me .I also made changes in ldap.ora file but nothing seems to be working for me.

abhi says August 7, 2013

abhi said, in August 7th, 2013 at 3:02 am
Hi atul

I want to connect oracle db via ldap.I have installed oraclercu,weblogic,oracle identity manage.I created users and roles in OID.But now im stuck and i am not understanding how should connect my oracle db with ldap.I enter the credential like cn=users,dc=com and enter the host where my OID is running and port number 3131 and 3160 but nothing is working for me .I also made changes in ldap.ora file but nothing seems to be working for me.

Vijay Kumar says March 11, 2015

How can we achive below

Master site with HA – read/write capability
Secondary sites will read only replica
=======================================

As with OID we have external Oracle Database which can be RAC for OID providing HA on Primary site. How can we achive same with OUD [BrkDb] in Primary site.

+ Read only replica on Secondary site.

Thanks
Vijay Kumar

quanns says March 23, 2016

Can you explain in details about “enable bootstrap” options when setting replication agreement.
If I check it on server oid2, so oid1 will gain all data from server oid1 or in reverse, oid1 will be the reception.

Add Your Reply