Re: Oracle RAC and external tables

From: Greg Rahn <greg_at_structureddata.org>
Date: Fri, 18 Dec 2009 13:59:21 -0800
Message-ID: <a9c093440912181359s3f5f9533x87582379e39f690a_at_mail.gmail.com>



The basics are this:

If you do not use services then each node must see the exact same directory and files. This can be either done by 1) putting the files 2 places (like a local file system) or 2) using either a clustered file system, shared nfs, or nfs export from one node to the other. Obviously some of these have some performance implications and are less scalable than others.

If you do use services then you can just use local storage and the "same view from both instances" requirement is relaxed.

On Fri, Dec 18, 2009 at 12:54 AM, Steven Rebello <Steven.Rebello_at_mastek.com> wrote:
> Need your inputs to help understand how RAC and external tables work.
> ...with Oracle RAC, since there 2 nodes having separate disks, it is possible that the file is FTP'ed into node 1 but the web application invokes the proc on node 2 due to load balancing. As node2 doesn't have the file on its local disk, the processing fails.

-- 
Regards,
Greg Rahn
http://structureddata.org
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 18 2009 - 15:59:21 CST

Original text of this message