"utkanbir" <hopehope_123_at_yahoo.com> wrote in message
news:f6c90ebe.0309160340.4fe970da_at_posting.google.com...
> Hi Gurus ,
>
> I have a question about Oracle Real Application Clusters . My system
> is Linux - Itanium , EMC , oracle 9x . This is a datawarehouse system
> . Our data files are stored by using Oracle clustered file system on
> EMC disk array.
> In order to extract and load data from source system to datawarehouse
> system , i use external tables. Basically , i load data by using
> external tables . My problem is with the locations of external files.
> At first i used oracle clustered file system but strange things
> happened there . ( tried to edit file or scripts by using vi , when i
> save the file , the contents are lost!!!)
>
> If i use a file system on one of the hosts , the other one cant see
> the external tables since the files are not stored in a clustered file
> system but regular file system. How can solve this problem apart from
> copying all data from one host to another? (One solution may be to
> have an ability which allows me to force RAC to use only one server
> for my external tables , is there such a method?)
>
>
>
> Kind Regards,
> hope
At Oracle World I went to a presentation where they talked about this. It
was on a 16 node RAC cluster set up. The guy was emphatic that you needed
shared area for things so you could have 1 shared Oracle home (not do 16
installs) and same for archive logs and external tables. If you have a
shared area then external tables work very well. You can do parallel query
on them across nodes for data warehouse etl loads. For that reason they
used a file system from Polyserve (I think).
Jim
Received on Tue Sep 16 2003 - 08:51:57 CDT
