No,
never heard about that option so far.
Regards
Jochen
-----Original Message----- From: Bill Holland [mailto:hollandwl@gmail.com] Sent: Friday, February 15, 2008 10:28 AM To: Willeke, Jochen Cc: toasters@mathworks.com Subject: Re: filer locks on oracle DB
have you set "vol options <volname> nvfail on"?
On Fri, 2008-02-15 at 09:29 +0100, Willeke, Jochen wrote:
Hello toasters,
we have a problem with some of our oracle databases (LINUX, NFS on Filers). Sometimes when the database crashes, we have locks left on
the
filer.
Currently we use "priv set diag; lock status -f" to check for those locks. And with "priv set diag; sm_mon -l [servername]" we can delete all locks for a specific server.
But this is a problem, if one server hosts more DB's than one. Is
there
any possibility to find out which locks are the blocking ones and
delete
only those?
Does anyone have the same problem and has an interesting solution to that?!?
Best Regards and thanks in advance
Jochen