ORA-12535 TNS:operation timed out

[rona_a]

Hi,

I have a problem with my current database server.
It's only happening ones or twice a month that's why
it's very difficult for me to find out what's causing the error
ORA-12535. I have already configure my listener.ora
listener_connect_timeout = 0 but this error still occurs at one time or another. sqltrace & listenr trace shows no error. So i rly don't have any clue or whatsoever of what's going on. I have also ceheck any connection time-out setting in our current network but everything seems to be ok. btw, i'm using oracle 9i.

Pls help me asap if you can as this is causing some data lost in our company's daily data upload.


regards and thanks,
rona

[cis_groupie]

Try reading this link:

http://www.eiu.edu/~pingliu/tec5323/...leshooting.htm

[dbasan]

Did you check the listener log at the time ORA-12535 occurs?

Remember to check the firewall and port open connections when you troubleshoot!

[rona_a]

Hi guys,

Thanks for replying to my query.. i still encountered same error last Friday.
I already checked the port and firewall, db connection, tnsping from client, etc. =(


Regards,
rona

[seelan]

Please let us know your operating system.

Regards,
Seelan

[rona_a]

Hi Seelan,

It's Windows Server 2003. FYI. Thanks

Rona

[seelan]

1) Are you getting this error during peak load?
2) What is your Listener QUEUESIZE value?

The reason I am asking this question is

If you expect the listener to handle large volumes of concurrent connection requests, then you can specify a listener queue size for its TCP/IP listening endpoints.

Is there any limitation in windows for open file limit? Because I am not sure about this. Becuase in unix low values of ulimit -n will lead to these kind of issues during peak loads.

Regards,
Seelan