DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    May 2001


    Dear Sir ,
    I have Oracle Database 7.3.4 on
    digital Unix v4 . it is production database
    24x7 Database.
    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


    Santosh sardesai : santosh_74@yahoo.com
    Santosh sardesai

  2. #2
    Join Date
    Feb 2001
    Paris, France
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.