Re: NFS filesystems ok for Oracle tablespace?

Hi Dave,

In article <33415648.153735_at_news.demon.co.uk>, spu_at_dsds.demon.co.uk (David Spencer) wrote:

...
> Are you allowed to do that?

No it's definetly not supported by Oracle.

I had a problem a few years ago where i wanted to store a Forms-file in a NFS mounted filesystem. It was not possible. I wonder how Oracle did it. I opened a call to Oracle and they said it's not supported. So; even a simple asccii-like source code file is not supported to be stored on a NFS-mounted filesystem.

If you have any other chance you should avoid to store tablespace-data on NFS-vols.

> What would happen if the
> storage hub ever said 'stale file handle' to the Oracle server?

I guess you'll get the same error message as you get for disk-read errors. If you get a read-error you may trash you whole tablespace/database.

There are a lot of problems to solve without using NFS ;-)

Kind regards,

Toni

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  |            
Marchioninistr.15 81366 Muenchen 49-89-70953202 |