"Oracle Lock Won't Go Away : ORA-00054: resource busy and acquire with NOWAIT specified

Put the following in your sqlnet.ora:

sqlnet.expire_time = ...

where you fill in a number on the dots. This is the number of minutes between polls of the PMON process, where it checks which hanging processes to remove. Worked for me...

Regards,

Bas

> -----Original Message-----
> From: EXE [SMTP:exe_at_exesolutions.com]
> Posted At: Thursday, August 06, 1998 6:39 AM
> Posted To: server
> Conversation: "Oracle Lock Won't Go Away : ORA-00054: resource busy
> and acquire with NOWAIT specified
> Subject: Re: "Oracle Lock Won't Go Away : ORA-00054: resource
> busy and acquire with NOWAIT specified
>
> > Hi: I've got a scenario where a UNIX script acquired a DML lock on a
> table.
> > This was evident by performing query "select v$session". The script
> was
> > terminated prematurely, but the lock still exists on the table. No
> INSERTs
> > or DROP of table is allowed or the message "ORA-00054: resource busy
> and
> > acquire with NOWAIT specified" is presented. A simple SELECT works
> ok. I
> > performed an "alter system kill session '22,33'" in an attempt to
> remove the
> > lock. The status of the lock changed to "killed", but the lock
> still exists.
> > The method of "alter system ..." had worked previously for other
> locks
> > resulting from the initial lock. If I can't commit or rollback, and
> I can't
> > drop the table, how do I remove the lock? Stopping and starting the
> db did
> > nothing to the lock.
>
> Drop the indices on the table and rebuild them.
>
> Regards,
>
> Daniel A. Morgan
Received on Fri Aug 07 1998 - 13:00:50 CDT