RE: Datafiles on NFS mount

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Tue, 24 Oct 2000 14:52:42 -0700
Message-Id: <10659.120110@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C03E04.C099CAA0
Content-Type: text/plain

I researched this same subject roughly two years ago, and I learned that Oracle does not support NFS datafiles. However, they do support/certify some vendors of NFS systems (Filers), such as NetApp.

Did you consider raping/bastardizing the other server's available hard drives to add more disk space to the Oracle server? Or you can NFS Mount the other server and move static files and old backups.

Regards,
Satar

> -----Original Message-----
> From:	John Kanagaraj [SMTP:JKanagaraj_at_mfi.com]
> Sent:	Tuesday, October 24, 2000 9:26 PM
> To:	Multiple recipients of list ORACLE-L
> Subject:	Re: Datafiles on NFS mount
> 
> > Is Oracle 8.1.6 capable of creating and using a datafile
> > on an NFS-mounted disk on another machine? We have two
> > Sun machines (OS block size is 8k on both); the machine running
> > Oracle is short on disk, while there is plenty available on the
> > second machine. We are planning to purchase another larger machine,
> > but in the meantime would like to get by for a short period without
> > investing more in the present machines. We are not using hot backups
> > (it's a small datawarehouse). What problems occur when either of the
> > machines is rebooted?
> 
> Hi Bill,
> 
> AFAIK, Oracle does NOT support NFS based datafiles. My understanding is
> that this is because there is no guarantee that the write request made
> to the local OS is complete when the remote OS is the one that performs
> it. The local OS returns a positive signal once the request is
> acknowledged, but not necessarily completed by the remote OS. I wouldn't
> do it - and Oracle will not support it...
> 
> John Kanagaraj
>  
>

------_=_NextPart_001_01C03E04.C099CAA0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Datafiles on NFS mount</TITLE>
</HEAD>
<BODY>

I researched this =
same subject roughly two years ago, and I learned that Oracle does not = support NFS datafiles. However, they do support/certify some vendors of = NFS systems (Filers), such as NetApp.

Did you consider =
raping/bastardizing the other server's available hard drives to add = more disk space to the Oracle server? Or you can NFS Mount the other = server and move static files and old backups.

Regards, 
Satar 

<UL>
-----Original Message-----
 From:   John Kanagaraj [SMTP:JKanagaraj_at_mfi.com]
 Sent:   Tuesday, October 24, 2000 9:26 PM
 To:     Multiple recipients of list ORACLE-L
 Subject:       =
 Re: Datafiles on NFS mount


> Is Oracle 8.1.6 capable of =
creating and using a datafile
 > on an NFS-mounted disk on =
another machine? We have two
 > Sun machines (OS block size is =
8k on both); the machine running
 > Oracle is short on disk, while =
there is plenty available on the
 > second machine. We are planning =
to purchase another larger machine,
 > but in the meantime would like =
to get by for a short period without
 > investing more in the present =
machines. We are not using hot backups
 > (it's a small datawarehouse). =
What problems occur when either of the
 > machines is rebooted?


Hi Bill,


AFAIK, Oracle does NOT support NFS =
based datafiles. My understanding is
 that this is because there is no =
guarantee that the write request made
 to the local OS is complete when the =
remote OS is the one that performs
 it. The local OS returns a positive =
signal once the request is
 acknowledged, but not necessarily =
completed by the remote OS. I wouldn't
 do it - and Oracle will not support =
it...


John Kanagaraj
Received on Tue Oct 24 2000 - 16:52:42 CDT