Re: Remote Oracle Directory for LOB loading

We used to have an NFS mount on a remote Windows server mounted locally on the Linux database server. We use external tables to query data from files on that mount.
But the Windows NFS server was not very stable (either Microsoft problem or bad setup, we don't really know), so we switched to CIFS mounting. Now it is a Windows share on the Windows server, and the Linux database server CIFS mounts that share. It works much better for us than NFS. But that is because the NFS share came from Windows - those places where both sides are Unix or Linux we use NFS and it works good.

We have no experience with Direct NFS, but I read this link: http://www.pythian.com/blog/oracle-direct-nfs-how-to-start/ And it seems like there are advantages to using Direct NFS if it is an NFS mount you are using.

But no matter if it is NFS or CIFS, you introduce (like Øyvind states) something external that your database becomes dependent on. It'll depend on the use case if that's acceptable or not. Loading the files clientside with SQL*Loader eliminates that issue.

Regards

Kim Berg Hansen

http://dspsd.blogspot.com
kibeha_at_gmail.com
_at_kibeha

On Thu, Oct 30, 2014 at 3:04 PM, Newman, Christopher <cjnewman_at_uillinois.edu
> wrote:

> Good morning list,
>
> We’ve inherited a database that loads external files as LOBS. The
> database (11.2.0.4) had previously resided on the same machine as the
> directory/LOBS, however now we’re separating the database and the LOB files
> that it needs to load.
>
> I’ve checked Oracle directories, and there doesn’t appear to be a way to
> indicate a directory located on a remote server.
>
> A colleague suggested an NFS mount on the remote server that would appear
> local to ours. Has anyone run into this and if so, how did you solve it?
> My google-fu seems to indicate that this might be accomplished via Direct
> NFS, but we’ve not tried it yet.
>
> Thank you - Chris
>
>

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