Re: Oracle needs to be restarted to accept new connections

David,

How do you resolve your databases? If with Oracle names then take a look at it. I had a similar problem a few years ago and the cause was ONames taking to long to resolve. Try a tnsping <database> to see if it resolves quickly.

regards,

Ivan

On Tue, 01 Nov 2005 03:01:08 -0800, DavidDublin wrote:

> 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
Received on Tue Nov 01 2005 - 08:31:36 CST