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:
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
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,
we are good with NFS. it is been running for more than six months without any isuse.
Suresh
Post a Comment