RE: OGG trailfile to NAS

In case anyone is interested, the problem was with the option "local_lock=none". One of our sysadmins changed this to "local_lock=all" and afterwards trailfiles had no issues getting created.

Regards,

Dave

From: Herring, David
Sent: Tuesday, December 24, 2019 8:58 AM To: 'oracle-l_at_freelists.org' <oracle-l_at_freelists.org> Subject: OGG trailfile to NAS

Folks, I'm having a rather difficult time tracking down exactly what is wrong in our configuration related to OGG and writing to it's trailfile directory.

OGG Version - 19.1.0.0.4, RHEL 7.6

We created a symlink pointing the directory "dirdat" to a NAS:

% ln -s /dnbusr1/dnbinas/gg_dnbi/dirdat /u01/app/oracle/ACS/OGG/gg19c/dirdat

The NAS is mounted as:

<NAS> on /dnbusr1/dnbinas type nfs (rw,relatime,sync,vers=3,rsize=32768,wsize=32768,namlen=255,acregmin=0,acregmax=0,acdirmin=0,acdirmax=0,hard,noac,proto=tcp,timeo=600,retrans=2,sec=sys,mountaddr=<IP addr>,mountvers=3,mountport=635,mountproto=udp,local_lock=none,addr=<IP addr>)

Once the extract starts we get the error:

ERROR OGG-01454 Unable to lock file "/u01/app/oracle/ACS/OGG/gg19c/dirdat/E0000000000" (error 37, No locks available).

Research says nfslock service needs to be restarted (done), mount options changed (done), permissions changed (done), yet we still get the same problem. If we repoint the symlink to local storage the OGG extract process works fine, so it's got to be something with the NAS yet we can't figure out what. I even strace'd the extract process which showed the following, yet wasn't helpful (to me):

[pid 83896] openat(AT_FDCWD, "/u01/app/oracle/ACS/OGG/gg19c/dirdat/", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC <unfinished ...>
[pid 83897] <... futex resumed> ) = -1 ETIMEDOUT (Connection timed out)

Any ideas on how to find out exactly what the issue is? We're stuck as we need a ton of space for the extract files and there's no way to allocate that much space to local storage.

Thx.

Regards,

Dave

--
http://www.freelists.org/webpage/oracle-l