Problems with NFS mounted drives

[Angie Meeks_1]

We are attempting to put an oracle database on some NFS mounted drives. Our server is HP UX 11.0 and the NFS mounted drives are on a Linux server running SLES 8.
We are just putting datafiles on the NFS mounted drives and getting the following errors:
BTW - if i move any of the datafiles to local drives on the HP, we do not get the error for those datafiles:

ORA-01157: cannot identify/lock data file 3 - see DBWR trace file
ORA-01110: data file 3: '/ap4/MAUI/mauidata/system03.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
HP-UX Error: 13: Permission denied

[Chris Xu]

My first and only sugestion is "Don't use NFS filesystems for Oracle databases. Period."

Chris

[Steven E. Protter]

Angie NFS is too slow for an Oracle database.

You MIGHT be able to get away with it if you connect on a private Gigabit switch via all Gigabit cards. I run my websites like that. My websites are NOT hosted in a database.

But the bottom line is your configuration is not supported by Oracle and you need do to something different.

SEP

[Angie Meeks_1]

Thank you for the suggestions. We are only putting a development database on the NFS disks for a short period of time. We need another instance briefly. We don't have any more space and we are out of other options. I understand the issues with NFS, but it is only temporary.

[Michael Williams_6]

Looking at the error, if it's moaning about locking, it could be that lockd is not running on the client...

We have SLES8 here and we found that locking does not work over NFS is the nfslock service is not running.

To fix that, just run /etc/init.d/nfslock start and try again...

[xyko_1]

Angie,

the problem may be caused by wrong permissions also. Verify if you are having write access to the nfs from Hp-UX server.
Try to write and read regular files to the nfs space before trying to run oracle.

regards,
xyko

PS. I recommend not using nfs with oracle also. Ok, I know you say that it's a temporary situation but .... just in case your space problem become worst.

[Angie Meeks_1]

Thank you for the suggestions.

I did not see any process like nfslock running , so i started it.
I then did status and i get the following:
hecking for NFS file locking daemon: unused
Checking for NFS stat daemon: running

I'm not sure what it is supposed to look like?

I did try to start my dbs again and I'm getting the same errors.

I am able to write files to the nfs mounted directories. I am able to vi and save a file. I am able to run a shell script.
My dbs file have the correct permissions and owner.

[Michael Williams_6]

Oh dear, have you checked the messages file for errors?

There should be a lockd running, either run /etc/init.d/nfslock restart or just run it yourself by just typing lockd.

You have to be root to run these commands.

[Angie Meeks_1]

Thanks !
ps -ef | grep lock

shows nothing

There are no errors in /var/adm/messages
I tried to restart nfslock and it is showing the same status

[Angie Meeks_1]

The nfslock does show running now.