OGG NSK MGR has excessive receive queue length and Collector for SQL/MX errors with Unable to lock file

(Doc ID 2317686.1)

Last updated on OCTOBER 17, 2017

Applies to:

Oracle GoldenGate - Version 12.2.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Following issues are seen

2017-08-30 07:18:20 Collector for SQL/MX: Unable to lock file "./dirdat/ff001902" (error 4013, Permission denied). Lock currently held by process id (PID) 738197567.

sys_mon_cpu_mem Process 0,541 has excessive receive queue length. $FC2.ZYQ00000.Z000DL78 qlen 9.7 Priority 180 C at 00:00

/opt/ggate:gtacl -c 'status 0,541'

Process Pri PFR %WT Userid Program file Hometerm

$X001A X 0,541 180 000 10,1 /opt/ggate12/mgr $ZHOME

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms