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@xxxxxxxxxxxxx' <oracle-l@xxxxxxxxxxxxx>
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