RE: filer locks on oracle DB

No,

never heard about that option so far.

Regards

Jochen

-----Original Message-----
From: Bill Holland [mailto:hollandwl@...]
Sent: Friday, February 15, 2008 10:28 AM
To: Willeke, Jochen
Cc: toasters@...
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
>


--
Wincor Nixdorf International GmbH
Sitz der Gesellschaft: Paderborn
Registergericht Paderborn HRB 3507
Geschäftsführer: Eckard Heidloff (Vorsitzender), Stefan Auerbach, Dr. Jürgen Wunram
Vorsitzender des Aufsichtsrats: Karl-Heinz Stiller
Steuernummer: 339/5884/0020 - Ust-ID Nr.: DE812927716 - WEEE-Reg.-Nr. DE44477193

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser E-Mail ist nicht gestattet.

This e-mail may contain confidential information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorised copying, disclosure or distribution of the material in this e-mail is strictly forbidden.