RE: RE : Oracle RAC and external tables
- From: "Tyfanie Wineriter" <tyfaniew@xxxxxxxxxxx>
- To: <robertgfreeman@xxxxxxxxx>, <bertrand.guillaumin@xxxxxxxxxx>, <Steven.Rebello@xxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 18 Dec 2009 16:17:48 -0800
Here at the U of Oregon, we do exactly that: A shared NFS mount on all
nodes.
~ Tyfanie Wineriter ~
Database Administrator
University of Oregon
1212 University of Oregon
Eugene, OR 97402-1212
(541) 346-1366
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Robert Freeman
Sent: Friday, December 18, 2009 1:13 PM
To: bertrand.guillaumin@xxxxxxxxxx; Steven.Rebello@xxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx
Subject: Re: RE : Oracle RAC and external tables
I believe that a Shared NFS mount on a SAN might also work as a solution.
Robert G. Freeman
Oracle ACE
Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
Author:
Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS WAY
SOON!
OCP: Oracle Database 11g Administrator Certified Professional Study Guide
(Sybex)
Oracle Database 11g New Features (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Other various titles
Blog: http://robertgfreeman.blogspot.com
Check out my new blog series on installing Oracle Database 11gR2 on Windows
using VMWare!
_____
From: Bertrand Guillaumin <bertrand.guillaumin@xxxxxxxxxx>
To: "Steven.Rebello@xxxxxxxxxx" <Steven.Rebello@xxxxxxxxxx>;
"oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Fri, December 18, 2009 2:57:34 AM
Subject: RE : Oracle RAC and external tables
Hi,
What you can do is use a service to always connect to the same node for your
uploading batch.
But then if the node is down, so is the possibility to use the file so
you're back to having a spof. Well normally, the node should restart by
itself but in case of hardware failure... Now maybe that kind of failure is
acceptable for your batch I'm not sure of your requirements.
Another solution is to push the file on both servers.
Yet another solution is to upgrade ASM to 11GR2(when it's out for AIX), and
use acfs(which is a general purpose cluster filesystem). Or use another
cluster filsystem. I'm not sure whether OCFS2 is available on AIX or not.
Best regards,
Bertrand Guillaumin
________________________________________
De : oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] de la
part de Steven Rebello [Steven.Rebello@xxxxxxxxxx]
Date d'envoi : vendredi 18 décembre 2009 09:54
À : oracle-l@xxxxxxxxxxxxx
Objet : Oracle RAC and external tables
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
