| 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:
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:
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 #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:
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
|
|
|
|
|
|
|
|
| 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:
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
