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: Rocr <rolland.cright_at_pwgsc.gc.ca>
Date: Fri, 13 Oct 2000 11:17:36 -0400
Message-ID: <8s792h$nkn9@shark.ncr.pwgsc.gc.ca>

Try killing the LOCK files i.e. for Database MyDB look for LCKMyDB in ORACLE_HOME then rm it.

"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 - 10:17:36 CDT

Original text of this message

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