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.
