OAAM 11g Multisite Cluster Implementation: How To Do Partial Replication Of DB? (Doc ID 1477715.1)

Last updated on APRIL 28, 2014

Applies to:

Oracle Adaptive Access Manager - Version 11.1.1.5.0 and later
Information in this document applies to any platform.

Goal

We have 3 sites in production for SSO and we are performing native OAAM integration with OpenSSO. Each site has its own database and accordingly we would need OAAM tables to be present in all the three data centers. We would need assistance on getting information on which tables can be replicated and which data cannot be.
Give these requirements; we see three categories of data (tables) with their own peculiar replication needs

1. Configuration tables [these need only be synced from the "main" data center to the other two one way]
2. Static tables like IPGeoLocation data [this does not need to be synchronized, the load scripts can be run on the 3 data centers]
3. Transactional tables [These will need to be replicated 3 way]


We need your help in dividing up the 250+ tables into these 3 categories. Is this possible in the architecture for OAAM deployment topologies?
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms