RE: Datafiles on NFS mount

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Wed, 25 Oct 2000 09:39:52 -0700
Message-Id: <10660.120183@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_01C03EA2.35D5E330
Content-Type: text/plain;

charset="iso-8859-1"

I held a meeting with NetApp's Director of Database Marketing. He was in charge of justifying why NetApp filers were a perfect solution for Oracle databases. I don't know if the situation changed from 2 years ago, but he stated that he didn't want OLTP databases to be running on their filers because of performance problems that the customers might experience. He insisted that their solution is perfect for DSS and DW databases. If your company has the money to purchase a netapp filer (along with their over-priced hard drives) and is in a Mix environment (NT and Unix), then NetApp is a good solution. One thing I liked about NetApp was their ease of database administration.

By the way, isn't a "hard lockup" considered a problem with NetApp?

Regards,
Satar

> -----Original Message-----
> From: Tom Tyson [SMTP:tomtysonjr_at_yahoo.com]
> Sent: Wednesday, October 25, 2000 3:56 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Datafiles on NFS mount
>
> About 6 months ago on OTN there was an article discussing an
> implimentation of
> Oracle using a NetApp servers using NFS mounts. The implementation was
> using a
> modified NFS client done by VA Linux. There was some 500 databases
> running
> with the datafiles residing on the NetApp. I wouldn't typically put a
> datafile
> on a NFS mount, but after reading this I felt a little more comfortable
> with
> trying this out. Since then, I have tried this out on a HPUX-11 system
> running
> 8.1.6 EE, and have had no problems with it.. even had a hard lockup on the
> Netapp and all was well after restarting the netapp and database server.
>
> Tom Tyson
>
>
> --- Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com> wrote:
> > 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
> > >
> > >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> http://im.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Tom Tyson
> INET: tomtysonjr_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

------_=_NextPart_001_01C03EA2.35D5E330
Content-Type: text/html;

charset="iso-8859-1"
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 held a meeting = with NetApp's Director of Database Marketing. He was in charge of = justifying why NetApp filers were a perfect solution for Oracle = databases. I don't know if the situation changed from 2 years ago, but = he stated that he didn't want OLTP databases to be running on their = filers because of performance problems that the customers might = experience. He insisted that their solution is perfect for DSS and DW = databases. If your company has the money to purchase a netapp filer = (along with their over-priced hard drives) and is in a Mix environment = (NT and Unix), then NetApp is a good solution. One thing I liked about = NetApp was their ease of database administration.

By the way, isn't a = "hard lockup" considered a problem with NetApp?

Regards, Satar

</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">Tom Tyson [SMTP:tomtysonjr_at_yahoo.com] Sent:   Wednesday, October 25, 2000 3:56 AM To:     Multiple recipients of list ORACLE-L Subject:       = RE: Datafiles on NFS mount

About 6 months ago on OTN there was an = article discussing an implimentation of Oracle using a NetApp servers using = NFS mounts.  The implementation was using a modified NFS client done by VA = Linux.  There was some 500 databases running with the datafiles residing on the = NetApp.  I wouldn't typically put a datafile on a NFS mount, but after reading = this I felt a little more comfortable with trying this out.  Since then, I = have tried this out on a HPUX-11 system running 8.1.6 EE, and have had no problems = with it.. even had a hard lockup on the Netapp and all was well after = restarting the netapp and database server.

<P><FONT SIZE=3D2 FACE=3D"Arial">Tom Tyson</FONT>
</P>
<BR>

--- Satar Naghshineh = <Satar.Naghshineh_at_irvine.mellesgriot.com> wrote: > 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.

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Regards,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Satar </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; -----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?

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; Hi Bill,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; 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...

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; John Kanagaraj</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;&nbsp; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
</P>
<BR>

<FONT SIZE=3D2 =

FACE=3D"Arial">__________________________________________________</FONT>=

Do You Yahoo!? Yahoo! Messenger - Talk while you = surf!  It's FREE.
 <A = HREF=3D"http://im.yahoo.com/" =
TARGET=3D"_blank">http://im.yahoo.com/</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L =
FAQ:</FONT><U> <FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial"><A =

HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Tom Tyson</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

tomtysonjr_at_yahoo.com

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 To REMOVE yourself from this mailing = list, send an E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in
 the message BODY, include a line = containing: UNSUB ORACLE-L
 (or the name of mailing list you want = Received on Wed Oct 25 2000 - 11:39:52 CDT