Re: filer locks on oracle DB

> 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.
>
>
>
>