Re: Using FreeBSD as an NFS server for oracle datafiles

On 30 Jul 2001 11:34:58 -0700, jzlemon_at_hotmail.com (John) wrote:

>Hello,
>I'm trying to setup a FreeBSD NAS box to use for storage for datafiles
>running on a solaris 2.6 box.
>This worked fine when the NAS box was linux or using NFS version 2 on
>FreeBSD, but we ran into a limit at 2 gigs.
>We are now running nfs version 3 on the FreeBSD side, but when oracle
>accesses the datafiles it cannot lock the files and writes errors to
>the dbwr trace file like the following:
>
>ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
>ORA-01110: data file 1: '/oradata/nas1/OAD/data/l1_sys01.dbf'
>ORA-27086: skgfglk: unable to lock file - already in use
>SVR4 Error: 22: Invalid argument
>Additional information: 8
>
>kgffsubmit: failed to unlock file
>'/oradata/nas1/OAD/data/l1_sys01.dbf'
>
>lockd is running.
>Anyone know how to resolve this issue?
>Thanks

Don't use NFS file systems for Oracle datafiles. Oracle's been saying this for years. If you do, Oracle will not guarantee recoverability.

--
Chuck Hamilton
chuck_hamilton_at_yahoo.com

"Do not be deceived, God is not mocked; 
for whatever a man sows, this he will also
reap." (Gal 6:7 NASB)