Re: Oracle RAC and external tables
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: Steven.Rebello@xxxxxxxxxx
- Date: Fri, 18 Dec 2009 13:59:21 -0800
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@xxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
