Capture from Oracle RAC

Fivetran Local Data Processing supports capturing changes from Oracle Real Application Clusters (RAC). Capture from Oracle RAC is only supported using the or capture method.

When capturing from Oracle RAC, Local Data Processing will typically connect with its own protocol to a installed in the RAC nodes. The should be configured to run inside all cluster nodes using the same Port, User/Login, and Password for all the Nodes. The hub then connects to one of the remote nodes by first interacting with the Oracle RAC 'SCAN' address.

The Local Data Processing channel only needs one location for the RAC and there is only one capture job at runtime. This capture job connects to just one node and keeps reading changes from the shared redo archives for all nodes.

Directory HVR_HOME and HVR_CONFIG should exist on both machines but does not normally need to be shared. If HVR_TMP is defined, then it should not be shared.

In Local Data Processing UI, the must be supplied while with Oracle RAC in Step 2. Select Agent Connection.