Oracle RAC and external tables
- From: Steven Rebello <Steven.Rebello@xxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 18 Dec 2009 14:24:19 +0530
Hi list members,
Need your inputs to help understand how RAC and external tables work.
We are planning to use external tables to upload large volumes of data from a
flat file, which is FTP'ed into the database server.
Currently, in the DEV environment we have a single-node Oracle instance
(non-RAC) which reads the files from the local disk and uploads the data. The
upload process is triggered from a web application which calls a PLSQL proc
doing the external table creation and loading. Everything works fine.
But now, in the planned production 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.
With this background, can you help with the queries below :
- First thought was to place the directory containing the files on the shared
SAN, but had been advised against it with the reason that OCFS does not support
non-DBF files. Is this a valid point? Couldn't find any reference document for
this.
- Planned to use NFS share and point the directory object to that, but then NFS
server becomes the single point of failure L Any workarounds for this?
- If we cannot share flat files on RAC, does that mean that RAC and external
tables don't gel together?
I've read the documentation and googled this out, but have not been able to get
a clear idea of what's the best practice for this situation.
Your inputs/experience/pointers to documentation would be much appreciated.
Oracle 10g Enterprise Edition Release 10.2.0.1.0 - 64bit - 2 node cluster RAC -
AIX 5.3
Regards
Steven Rebello
MASTEK LTD.
Mastek is in NASSCOM's 'India Top 20' Software Service Exporters List.
In the US, we're called MAJESCOMASTEK
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Opinions expressed in this e-mail are those of the individual and not that of
Mastek Limited, unless specifically indicated to that effect. Mastek Limited
does not accept any responsibility or liability for it. This e-mail and
attachments (if any) transmitted with it are confidential and/or privileged and
solely for the use of the intended person or entity to which it is addressed.
Any review, re-transmission, dissemination or other use of or taking of any
action in reliance upon this information by persons or entities other than the
intended recipient is prohibited. This e-mail and its attachments have been
scanned for the presence of computer viruses. It is the responsibility of the
recipient to run the virus check on e-mails and attachments before opening
them. If you have received this e-mail in error, kindly delete this e-mail from
desktop and server.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--
//www.freelists.org/webpage/oracle-l
Other related posts:
