How To Setup GoldenGate To Maintain A Heartbeat With The Database [ID 965415.1]

最新推荐文章于 2024-04-22 09:55:57 发布

cuanmo8775

最新推荐文章于 2024-04-22 09:55:57 发布

阅读量74

点赞数

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;

显示相关信息 相关的