LISTENER : operation timed out problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: LISTENER : operation timed out problem

  1. #1
    Join Date
    May 2001
    Posts
    4

    Angry

    Dear Sir ,
    I have Oracle Database 7.3.4 on
    digital Unix v4 . it is production database
    24x7 Database.
    (DEDICATED SERVER CONFIGURATION )
    At typical day time , more
    than 330 sessions use the database, besides
    this there is another "RATING" database
    on the same machine. which is also 24x7
    Both database have high transaction /DATA
    activity .
    Now many times ,listener comes down in a
    typical day time .
    (MAny times it comes down thrice in 5 MIN)

    the listener.log shows :

    TNS-12535: TNSperation timed out
    TNS-12560: TNSrotocol adapter error
    TNS-00505: Operation timed out

    so I need your help. Is anyone can tell me
    what should be done so that listener will not fell
    also is there any script so that listener will be started automatically after it is OFF.

    I need your help / guidance


    Regards

    Santosh sardesai : santosh_74@yahoo.com
    Santosh sardesai

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    look in listener.ora for CONNECT_TIMEOUT or CONNECT_TIMEOUT_LISTENER.
    the first one gives time before disconnecting, you can try and increase it, you can also try and set CONNECT_TIMEOUT_LISTENER to 0. This is the number of seconds that the listener waits to get a valid connection request once a connection has been started.
    hope this helps

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