Dear Sir ,
I have Oracle Database 7.3.4 on
digital Unix v4 . it is production 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
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: TNS:operation timed out
TNS-12560: TNS:protocol 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 : email@example.com
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 ;)