Re: Oracle NT services stop responding - more info

"Chen Zhao" <czhao_at_cs.helsinki.fi> wrote in message news:9u8mdp$2q2$1_at_oravannahka.helsinki.fi...
>
> "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.

8.1.7.2.1 on Windows NT. Received on Fri Nov 30 2001 - 13:28:56 CST