RE: Datafiles on NFS mount

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Tue, 24 Oct 2000 16:21:57 -0300
Message-Id: <10659.120085@fatcity.com>

I asked this question to Oracle last year, they told me that they do = not
support datafiles on NFS mounts, even if you set NFS to use TCP instead = of
UDP. They do support NFS mounts from a handful of vendors, but the = technician
told me it was really expensive.

Also, none of the names on the list of "approved" vendors had names I recognized - no SUN, no HP, no Compaq, in fact none of the NFS that = come
with a version of UNIX are approved by Oracle.

We wanted to store our exports on NFS mounts, generally we didn't have = any
problems, but as Joe mentioned, one day you restore while the network = is
busy, or the export is done while the network is busy, and... oops why = is
the export file bad.

It's better to buy more local disk, if you want to store Oracle files.

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique=20
Maritimes Region, DFO      | R=E9gion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20

	-----Original Message-----
	From:	Joseph S. Testa [SMTP:teci_at_oracle-dba.com]
	Sent:	Tuesday, October 24, 2000 4:41 PM
	To:	Multiple recipients of list ORACLE-L
	Subject:	Re: Datafiles on NFS mount

	Oracle's stand on NFS is this:

	put the binaries on nfs is ok, but NOT the datafiles, what do you
expect
	oracle to do when the network burps?

	joe
	Bill Becker wrote:



	> Hello,

	>

	> 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?

	>

	> Thanks to any responders.

	> beckerb_at_dgabby.mfldclin.edu

	> --

	> Please see the official ORACLE-L FAQ: http://www.orafaq.com

	> --

	> Author: Bill Becker

	>   INET: beckerb_at_mfldclin.edu

	>

	> 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).

	--
	Joe Testa  http://www.oracle-dba.com
	No you can't fix and ORA-600 error, call Oracle Support.



	--=20
	Please see the official ORACLE-L FAQ: http://www.orafaq.com
	--=20
	Author: Joseph S. Testa
	  INET: teci_at_oracle-dba.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

Received on Tue Oct 24 2000 - 14:21:57 CDT