Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shutdown of Oracle Database Hangs
This is painful! What you should do is stop the listeners first before stopping the database. Use LSNRCTL and issue a 'stop' command. Then issue a 'stop' command from SQL*Plus while logged in as internal. This should always work.
Pat
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 Fri Oct 13 2000 - 07:24:27 CDT