OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » listner timeout

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

listner timeout [message #67327]

Wed, 05 May 2004 11:49

Adam Dennis
Messages: 2
Registered: May 2004

Junior Member

I have a problem with my listener

I am running 9i on win 2k with IIS

I am developing an application that uses a VB COM. When I connect to the database through TOAD I have no problem but when I connect through the web front end using the COM every 30 minutes or so�the TNS times out.

The error I get is this

Description:ORA-12535: TNS:operation timed out

I have altered my listner.ora file to set the timeout to be 60 seconds!

There is nothing in the event viewer that would suggest anything else is going wrong so I cannot link the error to another process.

Any suggestions?

Thanks

Adam

Report message to a moderator

Re: listner timeout [message #67338 is a reply to message #67327]

Sun, 16 May 2004 21:49

Himanshu
Messages: 457
Registered: December 2001

Senior Member

there is

CONNECT_TIMEOUT_LISTENER= 120 (SECONDS)

IN LISTENER.ORA, WHICH SPECIFIES NUMBER OF SECONDS LISTENER WAITS TO GET A VALID DATABASE QUERY AFTER IT HAS BEEN STARTED

Report message to a moderator

Re: listner timeout [message #67339 is a reply to message #67338]

Mon, 17 May 2004 01:39

Adam Dennis
Messages: 2
Registered: May 2004

Junior Member

Thanks Himanshu

but I have already altered that, I have also set it to 0 ie listener should not timeout.
but it still does.
When I load test the component calling the open connection, again the listener times out.
Is there a patch for this?

Adam

Report message to a moderator

Re: listner timeout [message #123958 is a reply to message #67339]

Wed, 15 June 2005 13:25

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Hi,

Your listener might be overloaded. Try to create more listeners and spread the connections across them. Alternatively, specify a large QUEUESIZE:

Code: [Select all] [Show/ hide]

listener_name=
(DESCRIPTION=
 (ADDRESS=(PROTOCOL=tcp)(HOST=hr-server)(PORT=1521)(QUEUESIZE=20)))

Best regards.

Frank

Report message to a moderator

Re: listner timeout [message #126573 is a reply to message #67327]

Tue, 05 July 2005 14:07

suzieq
Messages: 1
Registered: July 2005

Junior Member

I am running into the same Oracle error from a web front-end (and can connect to TOAD without a problem).

I have tried everything in this post, yet I'm still getting TNS: Operation timed out.

Any more ideas?

Thanks.

Report message to a moderator

Previous Topic:	Protocol Adapter Error
Next Topic:	Old client new DB Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 07:16:54 CDT 2025