topic Re: Problems with NFS mounted drives in Operating System - Linux

Problems with NFS mounted drives

Angie Meeks_1 — Thu, 09 Dec 2004 14:33:00 GMT

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

Re: Problems with NFS mounted drives

Chris Xu — Thu, 09 Dec 2004 15:04:35 GMT

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

Chris

Re: Problems with NFS mounted drives

Steven E. Protter — Thu, 09 Dec 2004 15:28:41 GMT

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

Re: Problems with NFS mounted drives

Angie Meeks_1 — Thu, 09 Dec 2004 15:54:59 GMT

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.

Re: Problems with NFS mounted drives

Michael Williams_6 — Fri, 10 Dec 2004 04:10:24 GMT

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

Re: Problems with NFS mounted drives

xyko_1 — Fri, 10 Dec 2004 05:33:32 GMT

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.

Re: Problems with NFS mounted drives

Angie Meeks_1 — Fri, 10 Dec 2004 12:35:28 GMT

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.

Re: Problems with NFS mounted drives

Michael Williams_6 — Fri, 10 Dec 2004 12:41:29 GMT

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.

Re: Problems with NFS mounted drives

Angie Meeks_1 — Fri, 10 Dec 2004 12:56:16 GMT

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

Re: Problems with NFS mounted drives

Angie Meeks_1 — Fri, 10 Dec 2004 13:09:13 GMT

The nfslock does show running now.