We run an oracle 10g database server running on a windows 2003 server for a web application and we are noticing when our reporting application tries to access the database or we try to access the database through sql developer there are connection wait times up to 6 minutes.
We have 3 TNS listeners on ports 1521, 1522 and 1526 whats strange is our web application running on tomcats uses listener 1526 and thankfully queries are run immediately and never encounter a problem but outside of tomcat we getting a lot of "ORA-12518: TNS: listener could not hand off client connection tips" errors
Since the issue started we rebooted the database server to resolve it and until it occurred again but it's becoming more frequent and we can't keep rebooting everytime as a solution.
I tried restarting TNS listener service in the services panel but it does nothing to resolve the issue.
Would anyone know how we determine what is happening and how we can resolve it.