Fwd: Re: Remote Oracle Directory for LOB loading
Date: Thu, 30 Oct 2014 12:16:49 -0400
Message-ID: <54526471.7000908_at_oracle.com>
Hi Christopher, it's documented that you can use an NFS mount for external files, in the RAC documentation (Because external files for RAC must be accessible by all instances) :
http://docs.oracle.com/cd/E11882_01/install.112/e48195/postinst.htm#CHDEFBAG
> If your Oracle RAC database uses files that are external to the
> database, then the external files should be located on shared storage
> that is accessible to all nodes. Each node should use the same mount
> point to access the file. Acceptable shared file systems include
> Database File System (DBFS), Oracle ASM Cluster File System (Oracle
> ACFS), Oracle Cluster File System (OCFS) for Windows, or a supported
> network file system (NFS).
Direct NFS is totally optional. It means that the Oracle database accesses the NFS server directly, instead of using the OS kernel's NFS client. To use it, you have to relink with option dnfs_on: cd $ORACLE_HOME/rdbms/lib; make -f ins_rdbms.mk dnfs_on . I have never used Direct NFS with external files or seen it used for that, only with datafiles. With datafiles there's a performance boost.
If you're interested, the dNFS instructions are in the 11.2 DB platform install guide under "postinstallation tasks". Not sure offhand whether it's available on all platforms, definitely available on Linux.
-Natalka
-- Natalka Roshak | RAC/Storage BDE Oracle <http://www.oracle.com/index.html>Global Product Support 45 O'Connor St, Suite 400 | Ottawa, Canada On 30/10/2014 10:04 AM, Newman, Christopher wrote:Received on Thu Oct 30 2014 - 17:16:49 CET
> 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