OraFAQ Forum: Networking and Gateways » Very slow LSNRCTL

Home » RDBMS Server » Networking and Gateways » Very slow LSNRCTL - listener response time (Oracle RDBMS - 10.2.0.4, Win 64 2003, RAC, ASM )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Very slow LSNRCTL - listener response time [message #419696]

Tue, 25 August 2009 04:04

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

Im having a strange problem on one of my nodes in a three node RAC.

Grid Control suddenly reports this:

Code: [Select all] [Show/ hide]

Failed to connect to database instance: ORA-12547: TNS:lost contact (DBD ERROR: OCIServerAttach).

I use LSNRCTL to check the listener. It takes for ever to complete the folowing commands: services and status.

The listener response time seems very high.

Grid Control reported this during some time:

Code: [Select all] [Show/ hide]

The listener is down: LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 25-AUG-2009 10:30:12 Copyright (c) 1991, 2007, Oracle. All rights reserved. Welcome to LSNRCTL, type "help" for information. LSNRCTL> Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=xxx)(PORT=1521)) TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact 64-bit Windows Error: 54: Unknown error LSNRCTL> .

I have restarted the listener, but the problem came back. There are nothing in the listener.log/SQLnet.log.

I can log in on the affected node, but it takes over one minute.

What can be wrong?

Regards
Hristo

[Updated on: Tue, 25 August 2009 06:22]

Report message to a moderator

Re: Very slow LSNRCTL - listener response time [message #419729 is a reply to message #419696]

Tue, 25 August 2009 06:24

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

I found out that unknown error 54 = net helpmsg 54

The network is busy

So, any idea where to look now?

Regards
Hristo

Report message to a moderator

Re: Very slow LSNRCTL - listener response time [message #419744 is a reply to message #419696]

Tue, 25 August 2009 07:45

hristo
Messages: 258
Registered: May 2007

Senior Member

Hello again!

Found this on metalink:

Code: [Select all] [Show/ hide]

Error Description: 
ERROR_NETWORK_BUSY 
54 
0x36 
The network is busy. 

Cause: 
This indicates a bottleneck at the network layer(TCP/IP). 

Action: 
1.Try increasing dispatchers and shared servers.

Is there a way to verify that this is the problem?

Regards
Hristo

Report message to a moderator

Re: Very slow LSNRCTL - listener response time [message #419772 is a reply to message #419696]

Tue, 25 August 2009 09:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Does any of this reside in/on a virtual system?
If so, which part(s) and what VM name & version?

Report message to a moderator

Re: Very slow LSNRCTL - listener response time [message #419773 is a reply to message #419772]

Tue, 25 August 2009 09:52

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

No, it does not.

Regards
Hristo

Report message to a moderator

Re: Very slow LSNRCTL - listener response time [message #419893 is a reply to message #419696]

Wed, 26 August 2009 01:20

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi again!

I tried to restart the listener yesterday. The same problem came back. Then I checked the listener.log more closely.

I found this:

Code: [Select all] [Show/ hide]

25-AUG-2009 10:20:29 * services * 12537
TNS-12537: TNS: Anslutningen stängd
 TNS-12560: TNS: protokolladapterfel
  TNS-00507: Anslutningen stängd
   64-bit Windows Error: 232: Unknown error

TNS-12571: TNS: Fel vid lagring av paket
 TNS-12560: TNS: protokolladapterfel
  TNS-00530: Protokolladapterfel
   64-bit Windows Error: 54: Unknown error
    TNS-12518: TNS: Lyssnaren kunde inte överlämna klientanslutning
     TNS-12560: TNS: protokolladapterfel
      TNS-00530: Protokolladapterfel
       64-bit Windows Error: 233: Unknown error

TNS-12518: TNS: Lyssnaren kunde inte överlämna klientanslutning
 TNS-12560: TNS: protokolladapterfel
  TNS-00530: Protokolladapterfel
   64-bit Windows Error: 233: Unknown error

Regards
Hristo

Report message to a moderator

Re: Very slow LSNRCTL - listener response time [message #419921 is a reply to message #419696]

Wed, 26 August 2009 03:36

hristo
Messages: 258
Registered: May 2007

Senior Member

Hello again!

I have solved the issue!

It was lack of available memory on the server that caused the listener to behave in the way it did.

More info at metalink doc:371983.1

Regards
Hristo

Report message to a moderator

Previous Topic:	Getting data from db2
Next Topic:	Two Oracle server on same unix box can have same listener port or different listener port?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 12:29:16 CDT 2025