Operating System - Linux
1828637 Members
7309 Online
109983 Solutions
New Discussion

Problems with NFS mounted drives

 
Angie Meeks_1
Occasional Advisor

Problems with NFS mounted drives

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
9 REPLIES 9
Chris Xu
Trusted Contributor

Re: Problems with NFS mounted drives

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

Chris
Steven E. Protter
Exalted Contributor

Re: Problems with NFS mounted drives

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Angie Meeks_1
Occasional Advisor

Re: Problems with NFS mounted drives

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
Trusted Contributor

Re: Problems with NFS mounted drives

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
Esteemed Contributor

Re: Problems with NFS mounted drives

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
Occasional Advisor

Re: Problems with NFS mounted drives

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
Trusted Contributor

Re: Problems with NFS mounted drives

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
Occasional Advisor

Re: Problems with NFS mounted drives

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
Occasional Advisor

Re: Problems with NFS mounted drives

The nfslock does show running now.