Configure Goldengate on Oracle Exadata

Goldengate configuration process is exactly same as 11g RAC environment except we use DBFS as the shared mount point for Goldengate files. The manager process must only run on one node. To prevent extract and replicat processes being started concurrently, mount DBFS on a single RAC node. Ensure the mount point configuration is added on node’s /etc/fstab file.

For example:

/sbin/mount.dbfs#/@DBconnectstring     /mnt/oracle/dbfs     fuse  rw,user, noauto 0 0

If the Goldengate home is not in shared storage, ensure goldengate is installed in each node in the cluster and that the parameter files exist in the local subdirectories. Checkpoint and trail files must be placed on shared storage.

Below are the steps for creating the goldengate configuration for shared storage.

1. Make sure the DBFS is mounted. As a root user  create directories “dirchk” and “dirdat”

mkdir /mnt/oracle/dbfs/ggs/dirchk

mkdir /mnt/oracle/dbfs/ggs/dirdat

2.As root, grant the read write permission on ggs directory to oracle user

chown –R oracle:oinstall /mnt/oracle/dbfs/ggs

3. On each node delete the dirchk and dirdat directories

rmdir $GGS_HOME/dirchk

rmdir $GGS_HOME/dirdat

4. Create a symbolic link to point the DBFS mount point directories

ln  –s  /mnt/oracle/dbfs/ggs/dirchk dirchk

ln  –s  /mnt/oracle/dbfs/ggs/dirdat dirdat

Now create the extract and replicat process ----> refer to 

my previous threads for ASM configuration, Extract and replicat process creation.