How To Setup GoldenGate To Maintain A Heartbeat With The Database [ID 965415.1]
		修改时间 31-MAY-2011 类型 HOWTO 状态 PUBLISHED

In this Document
Solution

---

Applies to:

Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]
Information in this document applies to any platform.

Solution

PROBLEM
Some user accounts in the database are setup with session timeout values for idle processes. If the GoldenGate process is connected to a database that exceeds the set timeout, the process will be terminated.

SOLUTION SUMMARY
Use SQLEXEC at the root level to execute a query based on an interval of time. This technique will prevent the OGG process from becoming idle.

EXPLANATION OF SOLUTION
The method used for setting this up is a SQLEXEC statement in the parameter file. The SQLEXEC for the heartbeat can be put in the extract or replicat parameter file anywhere, but with the map statement.

Syntax for Oracle: SQLEXEC "select 'x' from dual" EVERY 30 SECONDS
Valid intervals are: SECONDS, MINUTES, HOURS, DAYS.

================================================================================

Sample Replicat: (SQL Server)

================================================================================

REPLICAT REPCUST

discardfile c:ggsdiroutrepcust.dsc, append, megabytes 10

sourcedefs c:ggsdirdefsource.def

TARGETDB GGSDB, USERID ggsuser, PASSWORD *****

SQLEXEC "select 'x' " EVERY 2 MINUTES

map source.customer, target target.customer;



=================================================================

Sample Extract: (ORACLE)

=================================================================



EXTRACT EXTCUST

USERID ggsuser, PASSWORD *****



SQLEXEC "select 'x' from dual" EVERY 2 MINUTES



RMTHOST houston, MGRPORT 7809
RMTTRAIL C:ggsdirdatet



TABLE source.CUSTOMER;

相关的 产品 Middleware > Data Integration > GoldenGate > Oracle GoldenGate 关键字 GOLDENGATE; HEARTBEAT; IDLE PROCESSES; TIME OUT

返回页首

[@more@]