Mailing List Archive: Netapp: toasters

filer locks on oracle DB

Index | Next | Previous | View Threaded

Jochen.Willeke at wincor-nixdorf

Feb 15, 2008, 12:29 AM

Post #1 of 6 (363 views)
Permalink

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.

bmichael at netapp

Feb 15, 2008, 1:18 AM

Post #2 of 6 (349 views)
Permalink

Re: filer locks on oracle DB [In reply to]

Hi

You could first check if all RPC calls are registered symetrically on
the server and the client

rpcinfo -p localhost
rpcinfo -p filer

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

hollandwl at gmail

Feb 15, 2008, 1:27 AM

Post #3 of 6 (349 views)
Permalink

Re: filer locks on oracle DB [In reply to]

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
>

Jochen.Willeke at wincor-nixdorf

Feb 15, 2008, 1:29 AM

Post #4 of 6 (348 views)
Permalink

RE: filer locks on oracle DB [In reply to]

No,

never heard about that option so far.

Regards

Jochen

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

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

srinivas.pn at gmail

Feb 15, 2008, 4:43 AM

Post #5 of 6 (347 views)
Permalink

Re: filer locks on oracle DB [In reply to]

Clearing NFS locks are disruptive for other active sessions on the same host
connected to same filer. Below KB provides more info.

https://now.netapp.com/Knowledgebase/solutionarea.asp?id=ntapcs1386

-Srinivas

On Fri, Feb 15, 2008 at 1:59 PM, Willeke, Jochen <
Jochen.Willeke[at]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.
>
>
>

Jochen.Willeke at wincor-nixdorf

Feb 18, 2008, 5:01 AM

Post #6 of 6 (339 views)
Permalink

RE: filer locks on oracle DB [In reply to]

Hi toasters,

i did a bit more testing in the meanwhile.

One thing i now know is, that you can check with "lock status -h [host]
-p NLM" for all NFSv2/3 connections for a specific host.

Like that:

======== NLM host lolek
93 0x19396e07:0x001af399 0:0 0 GRANTED (0x627a7e30)
93 0x19396e07:0x001af3a1 0:0 0 GRANTED (0xa8bb5728)
93 0x19396e07:0x001af39b 0:0 0 GRANTED (0xe5bec7f0)
93 0x19396e07:0x001af39a 0:0 0 GRANTED (0x6ecd44d0)
93 0x19396e07:0x001af398 0:0 0 GRANTED (0x64df7e30)
93 0x19396e07:0x001af397 0:0 0 GRANTED (0xaee564d0)
93 0x19396e07:0x001af396 0:0 0 GRANTED (0x9558be30)
84 0x17396d96:0x000911bb 0:0 0 GRANTED (0x8049d980)
84 0x16396d56:0x00003720 0:0 0 GRANTED (0x719b1ef8)
84 0x19396e07:0x001af395 0:0 0 GRANTED (0x916c58b8)

There you have a PID (the first collumn) which can be used to kill locks
per PID. "sm_mon -l [host] -p PID"
But sadly this PID is not the PID i can see on the client. Has anybody
an idea if there is a link between those PID's??

Regards

Jochen

-----Original Message-----
From: owner-toasters[at]mathworks.com [mailto:owner-toasters[at]mathworks.com]
On Behalf Of Bill Holland
Sent: Friday, February 15, 2008 10:28 AM
To: Willeke, Jochen
Cc: toasters[at]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
>

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

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com