-
ORA-12535 TNS:operation timed out
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
-
-
Did you check the listener log at the time ORA-12535 occurs?
Remember to check the firewall and port open connections when you troubleshoot!
"What is past is PROLOGUE"
-
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
-
Please let us know your operating system.
Regards,
Seelan
-
Hi Seelan,
It's Windows Server 2003. FYI. Thanks
Rona
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|