Re: db hang on shutdown

Ed_Stevens_at_nospam.noway.nohow (Ed Stevens) wrote in message news:<3c433fbd.7157151_at_ausnews.austin.ibm.com>...

> Any takers to either question?
> 1 - Why does this one db seem to hang on a shutdown immediate
> 2 - Why does this one db show well over 100 sessions (some up to several days
> old) when there are only six client machines in existence?

I had exactly the same problem few years ago. Some session just hanged and had no intentions to die honorably. I had advantage that platform was HP-UX, so I used "kill -9" and everything was OK. These zombie sessions were not killable by internal Oracle tools. You can use timeout in listener.ora, or check if your applications are logging out correctly. However neither first or second helped me.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.