Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Shutdown of Oracle Database Hangs

Re: Shutdown of Oracle Database Hangs

From: Pat Joyce <patrick.joyce_at_openet-telecom.com>
Date: Fri, 13 Oct 2000 12:24:27 GMT
Message-ID: <%9DF5.5999$44.18862@news.iol.ie>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US