On Fri, Feb 15, 2008 at 1:59 PM, Willeke, Jochen <Jochen.Willeke@wincor-nixdorf.com> 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.