Federation Manager Release Notes › Known Issues › Installation, Startup and Upgrade Issues › Oracle RAC Default Propagation Value Causes Federation Manager Errors (80671)

Previous Topic: Startup Problems on Linux Systems Due to Insufficient Entropy (135665)

Next Topic: LANG Variable set to UTF-8 Causes Database Import Failure on UNIX Platforms (129593)

Oracle RAC Default Propagation Value Causes Federation Manager Errors (80671)

Symptom:

If an Oracle RAC is serving as the Federation Manager database, the default value for the MAX_COMMIT_PROPAGATION_DELAY database property can cause Federation Manager errors.

The MAX_COMMIT_PROPAGATION_DELAY determines the frequency of propagating changes between RAC instances. Oracle RAC nodes propagate changes from one node to another within 7 seconds. Federation Manager reads and writes objects to a policy store, user store, session store, or audit store at a greater frequency. As a result, the default Oracle RAC propagation value can result in Federation Manager errors. Errors occur because the write operation is made to one node while the read operation, to which the write operation is not yet propagated, is made to another node.

Solution:

To avoid errors, change the default value of the MAX_COMMIT_PROPAGATION_DELAY setting in the Oracle RAC cluster as follows:

MAX_COMMIT_PROPAGATION_DELAY=0

Additionally, synchronize the clock on the Oracle RAC node servers.

Note: For more information about this setting, see the Oracle documentation.