Re: Killing oracle process

From: Bass Chorng <bchorng_at_yahoo.com>
Date: 17 Jan 2002 14:33:53 -0800
Message-ID: <bd9a9a76.0201171433.3cec5a21@posting.google.com>

ilker_at_hiperaktif.com (ilker ARABACI) wrote in message news:<6fcdbf89.0201160951.72d250c6_at_posting.google.com>...
> Hi,
>
> At some cases sqlplus connot terminate oracle
> shutdown / shutdown immidiate hanges up my system
> so I tried to kill the oracle process and restart oracle
>
> but whenever I restart , and reconnect to db , Oracle says;
> db is still on shutdown process, it it related to sumthing like .pid
> file ?
> if I kill the oracle ( I know it is so violate :) ) , may i also
> delete some temp/pid file or any like ?

It is because Oracle touches a file under $ORACLE_HOME/dbs. If you just kill one of the background processes, this file is not removed and next time it comes up it thinks it is already running.

You can manually remove the file after the kill. But the best way is thru shutdown. Received on Thu Jan 17 2002 - 16:33:53 CST