Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Mystery messages every 5 minutes in alert_*.log; apply server restart

Dan MurphyNov 19 2024 — edited Nov 19 2024

Hi,

I'm seeing the following messages in the alert log, every 5 minutes

GoldenGate Apply Server AS07 for OGG$R1038173 with pid=81 OS id=11740 stopped
2024-11-15T03:20:35.587208-05:00

GoldenGate Apply Server for OGG$R1038173 started AS0D with pid=81 OS id=12723
2024-11-15T03:20:35.594306-05:00

I don't understand why the apply server associated with my replicat process is restarting every 5 minutes. I do have the following in my replicat parameter file:

REPORTCOUNT EVERY 5 MINUTES, RATE

Any help is much appreciated!

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.24.0.0.0

Oracle GoldenGate Command Interpreter for Oracle
Version 19.24.0.0.240716 OGGCORE_19.24.0.0.0OGGRU_PLATFORMS_240706.1245_FBO
Linux, x64, 64bit (optimized), Oracle 19c on Jul 6 2024 16:30:34

Best,

Dan

Comments

InoL Apr 29 2024

How doc gen treats nulls values?

You have to be more specific. Are your referring to the pre-built Document Generator function?

If so:

When my query return null in some columns

What is the JSON that is generated?

You should always include the element in the JSON, with an empty value. Don't leave it out.

Francois Robert-Oracle Jan 8 2025 — edited on Jan 8 2025

Since September 2024, when a tag has no corresponding value in the JSON data or the value is null, the tag is replaced by an empty string.

See the September Release Notes

1 - 2

Post Details

Added on Nov 19 2024
0 comments
96 views