From owner-freebsd-questions Tue Jul 31 9: 1: 6 2001 Delivered-To: freebsd-questions@freebsd.org Received: from web13301.mail.yahoo.com (web13301.mail.yahoo.com [216.136.175.37]) by hub.freebsd.org (Postfix) with SMTP id E4A3B37B403 for ; Tue, 31 Jul 2001 09:01:03 -0700 (PDT) (envelope-from sumirati@yahoo.de) Message-ID: <20010731160100.78020.qmail@web13301.mail.yahoo.com> Received: from [193.174.9.99] by web13301.mail.yahoo.com; Tue, 31 Jul 2001 18:01:00 CEST Date: Tue, 31 Jul 2001 18:01:00 +0200 (CEST) From: =?iso-8859-1?q?m=20p?= Subject: Re: NFS v3 server locking fails To: jay@eziba.com Cc: freebsd-questions@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG > We're trying to get an Oracle db running on Solaris 2.6 to work with a > 4.3-Stable (7/24) system as the underlying filesystem via NFS. The > -Stable box has an ATA raid subsystem. The problem is that over NFS v3, > the Solaris system fails to acquire the lock, and NFSv2, though it > works, isn't really an option since it's (a) an order of magnitude > slower and more importantly, (b) we have files > 2gig. Why want you to do this? My experience says: DONT. And if you think about costs (using an IDE-raid): DONT. The problem is with the Oracle db that it is not nearly fast enough with NFS (have done only little tests with NFSv3; sure about NFSv2). Another point is: How do make sure that your network connection is permanent? Have you tested recovery of a database where network-outage happend in the middle of the update (eg pull the plug)? It is hard enough using only the local filesystem. Side-question: Why do you use Oracle databasefiles > 2gb? If you not have data per tablespace in the three-digit GB range, go with smaller ones. On the most (in this case HP-UX) you will get some percent more performance .. and a little admin overhead. My solution would be: Take some money and buy for the Sun more/bigger SCSI-discs. > > Are there any known problems with NFSv3 locking? If so, any know > workarounds? > > /etc/rc.conf has > > nfs_server_enable="YES" > rpc_lockd_enable="YES" > portmap_enable="YES" I can not help you with this. Sorry. Just my two cent marc __________________________________________________________________ Do You Yahoo!? Gesendet von Yahoo! Mail - http://mail.yahoo.de To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message