ORA-12535 TNS:operation timed out
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: ORA-12535 TNS:operation timed out

  1. #1
    Join Date
    Jul 2006
    Posts
    9

    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

  2. #2
    Join Date
    Jun 2006
    Location
    Wales, UK
    Posts
    62

  3. #3
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    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"

  4. #4
    Join Date
    Jul 2006
    Posts
    9
    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

  5. #5
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109
    Please let us know your operating system.

    Regards,
    Seelan

  6. #6
    Join Date
    Jul 2006
    Posts
    9
    Hi Seelan,

    It's Windows Server 2003. FYI. Thanks

    Rona

  7. #7
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109
    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
  •  


Click Here to Expand Forum to Full Width