Oracle RAC

Oracle RAC

The Oracle RAC environment increases performance, improves fault tolerance, and provides scalability. Determine whether your business requires the benefit of using Oracle RAC with the MDM Hub.
For information about Oracle RAC, see the Oracle documentation.

Considerations for using Oracle RAC

Based on the following considerations, decide on the Oracle RAC environment setup:
  • Use Oracle service names instead of Oracle SIDs for Oracle RAC installations. Provides flexibility to specify the connection and to dynamically reallocate database servers.
  • Configure all the Oracle RAC nodes in the
    tnsnames.ora
    file.
  • Use Oracle RAC load-balanced connections. Distributes the workload among all the available nodes in a cluster. If a node becomes unavailable, the MDM Hub batch job fails, but the job can be started on the available nodes in the cluster.
The MDM Hub supports load balancing for the following operations and components:
  • Hub Console operations
  • All batch jobs except the Generate Match Tokens job
    The MDM Hub supports load balancing for the fuzzy matching portion of the Match jobs and for the cleanse process portion of the Stage jobs.
    Batch jobs cannot use load balancing when called from the Hub Console.
  • Services Integration Framework (SIF)
  • Outbound JMS message queues
  • Hub Server
  • Process Server
  • Provisioning tool
  • Repository Manager
    Repository Manager
    cannot use load balancing when DDL is required because DDL uses a direct JDBC connection.
The MDM Hub does not support load balancing for
Data Director
.

0 COMMENTS

We’d like to hear from you!