I had this problem just this morning. There were 2 processes haning around
and Oracle was waiting on them. Both these processes were from an
application that is having major stability issues and they probably were "in
a funny state". I have not experienced this otherwise although 8i does seem
to take quite a bit longer to start and shutdown than version 7 in general.
--
Dave A
"Livery Stable" <jbrigman-sp4mb10ck_at_ipass.net> wrote in message
news:39E6733B.CFA3FD7_at_ipass.net...
> Hey Oraclites:
>
> I'm a UNIX system admin managing some UNIX servers w/oracle databases
> running.
>
> Many times (but not always, and not consistently) the database won't
> shut down (even using "shutdown immediate") there are these LOCAL=NO
> processes hanging around that won't go away, and they hang the UNIX OS
> on the way down. If you kill the processes the database will shut down.
> But this seems to always bite me worst when I'm trying to do system
> maintenance, and I'm thinking about what I have to do, not killing the
> oracle-sql connections that are sticking around.
>
> Can anyone talk to me about this? Offer any kind of explanation or
> experience? I rarely see the problem mentioned on the oracle newsgroups,
> so I'm starting to think it's only at MY site.....?!?
>
> If there's any URL's that go into this topic, just the url posting would
> be OK. Thanks for any experiences or help;
>
> James Brigman
> UNIX System Admin
>
Received on Thu Oct 12 2000 - 23:01:47 CDT
