Re: Oracle NT services stop responding - more info

"Chuck" <chuck_hamilton_at_yahoo.com> wrote in message news:9u84qd$6ln1i$1_at_ID-85580.news.dfncis.de...
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> "Chuck" <chuck_hamilton_at_yahoo.com> wrote in message
> news:9u847s$6ql3t$1_at_ID-85580.news.dfncis.de...
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > We started having a strange problem where the oracle services won't
> > respond to anything. All remote connections fail at the client side
> > but the failed connections are not recorded in the listener.log.
> > Neither is any error recorded in the database alert log (though log
> > switches are, so the service appears to be running). Connect
> > internal via sqlplus and svrmgrl on the server fail too. Attempts
> > to stop the Oracle database service also fail. It's like the
> > service is still
> > running but refusing to respond to any requests. The only way to
> > get things working normally is to use task manager to kill the
> > oracle.exe executable and then restart the service. This database
> > has been
> > running for a year but this problem started happening about 3 weeks
> > ago. Any ideas?
>
> I wanted to add that the error the clients get is ORA-12560
> "TNS:protocol adapter error".
>
>

What's Oracle database version? Do you ever apply any patches for the server? It sounds like a bug, you may need to search www.oracle.com to find suitable patches.

-chen zhao Received on Fri Nov 30 2001 - 13:25:36 CST