Golden Gate for EBS running Exadata


Hi Everyone,

Recently have been doing GG setup for EBS 11i running on Exadata. Here are few notes that might help others.

Our EBS system was real busy system all 24/7, heavily used globally. Once of the step for setting up GG is to have supplemental logging. 

SQL>alter database add supplemental log data;

Enabling supplemental logging statement was hanging as it was looking for TX lock in shared mode when there are uncommitted transactions.  Hence we had to move this step during one of the downtime window.

Below notes can be used for integrating GG for EBS running on Exadata.

Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle E-Business Suite [ID 1112325.1]


Coming to Exadata specially, you can use DBFS for holding Golden Gate binaries however from the PDF you can see ‘DBFS is not supported for a Bounded Recovery checkpoint file location’.  Hence we planned to use NFS for holding GG binaries.
We were facing issues on NFS locking issues. Here are the mount options you need to use for GoldenGate to work correctly. On Linux OS

rw,bg,hard,nointr,rsize=32768,wsize=32768,tcp,actimeo=0,vers=3,timeo=600

You can read more on NFS options on the article 1232303.1

Oracle GoldenGate Best Practice: NFS Mount options for use with GoldenGate [ID 1232303.1]

Hope this helps someone out there around the world.
Happy Sharing!!


3 comments:

Jignesh Kankrecha said...

Suresh

This is very good notes, I have question did you hit any performance problem while running GG on NFS.

I m planing for this combination as limitation of checkpoint files locking issue on ACFS/DBFS.

Jignesh Kankrecha said...

Suresh

This is very good notes, I have question did you hit any performance problem while running GG on NFS.

I m planing for this combination as limitation of checkpoint files locking issue on ACFS/DBFS.

Suresh Lakshmanan said...

Jignesh,

we are good with NFS. it is been running for more than six months without any isuse.

Suresh