Re: TNS Listener dies sporadically

I have seen a similar thing on Win2K Oracle 10g very much as you describe - no new connections at random intervals (usually at least a month apart) and no obvious cause. Since this was on development, rather than test or production, we haven't yet spent a lot of time digging into it. However, in our case a listener reload worked in every case but one, and for that single case stopping and starting the listener was all that was necessary. If you do take the time to solve this please email me or post to the group.

Thanks,

"Walt" <walt_askier_at_yahoo.com> wrote in message news:415829C5.56C5F148_at_yahoo.com...
>
> We upgraded to W2K3, Oracle 9.2 last January (a new instance on new
> hardware). Since then the database has gone down about six or sever
> times. The symptom is that the TNSListener will not accept new
> connections; users who are already connected are able to continue their
> sessions but no new connections can be made.
>
> If we simply restart the TNSListener it will work for about an hour or
> so before dying again. If we reboot the OS everything wakes up happy.
> We have not tried just restarting the Oracle services without a reboot.
>
> The outages are aperiodic - we've gone for three months without a
> problem, and once two outages occurred within three days of one another.
>
> I've looked through the Event Log (Windows Event Viewer) and the bdump
> file, but I don't see anything that points to a source of the problem.
> Anybody seen this behavior before? Can you suggest a plan of attack?
>
> Thanks.
>
>
> --
> //-Walt
Received on Mon Sep 27 2004 - 12:49:20 CDT