topic HP-UX Lock error in Operating System - HP-UX

HP-UX Lock error

Ed Velasco — Fri, 13 Nov 2009 03:40:08 GMT

Hi Guys,

We have a HP Itanium server runninh HP-UX 11.23 OS. When we start our Oracle database, we get the below error:

ORA-27086: skgfglk: unable to lock file - already in use
HPUX-ia64 Error: 46: No locks available

Your help will be very much appreciated.

Thanks
Ed

Re: HP-UX Lock error

Michael Steele_2 — Fri, 13 Nov 2009 04:04:44 GMT

Hi

I found one thread reporting the same error. The root cause is NFS based. Look it over and get back.

http://forums11.itrc.hp.com/service/forums/questionanswer.do?threadId=760141

Re: HP-UX Lock error

Kapil Jha — Fri, 13 Nov 2009 04:13:56 GMT

As asuggested above please check if ur DB is using any NFS file system and check for any permission issue.

ORA-27086: unable to lock file - already in use
Cause: the file is locked by another process, indicating that it is currently in use by a database instance.

Action: determine which database instance legitimately owns this file.

Check if you have shut the DB completely before.

More info required!!

BR,
Kapil+