Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle needs to be restarted to accept new connections
"DavidDublin" <davidcotter_at_gmail.com> wrote in message
news:1130842868.695809.4920_at_g44g2000cwa.googlegroups.com...
> Hello,
>
> Over time (a few weeks) my Oracle 9i server on Linux begings to take a
> long time to open a connection (say 30 seconds to start sqlplus).
>
> I have about 50 remote JDBC connections open that are distributed over
> 10 or so tomcat web applications and these too begin to cause trouble
> where opening connections timeout.
>
> I'm pretty sure I do not have any connection or cursor leaks.
>
> If I restart Oracle the problem goes away.
>
> I do not see anything in sqlnet.log or listener.log.
>
> I have now set up a cron job that records open files (lsof), sockets
> (netstat), open connections and cursors (sqlplus) and processes (ps)
> that belong to oracle to see if there is a leak somewhere. I have also
> recorded different statuses like ESTABLISHED etc for the sockets.
>
> Does anyone know if there are other things I should be monitoring to
> try to diagnose this problem.
>
> Thanks,
> David
>
Is the connection as slow on the server itself or only if connecting remotely ? Any network saturation ? Wrong network speed settings ? Received on Tue Nov 01 2005 - 07:31:07 CST