| 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
|
|
|
|
| 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
|
|
|
|
| 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
|
|
|
|
| Re: listner timeout [message #123958 is a reply to message #67339] |
Wed, 15 June 2005 13:25 |
Frank Naude
Messages: 4579
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:
listener_name=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=hr-server)(PORT=1521)(QUEUESIZE=20)))
Best regards.
Frank
|
|
|
|
| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
