Re: force clean database shutdown

<div class="mail">
<address class="headers">
<span id="from">
<dfn>From</dfn>: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
</span>
<span id="date"><dfn>Date</dfn>: Thu, 08 Jun 2006 21:27:31 +0200</span>
<span id="message-id"><dfn>Message-ID</dfn>: <oeug82dd443ml346nt03e206k16sg8hfq7_at_4ax&#46;<!--nospam-->com>
</span>
</address>

<br>

On Thu, 08 Jun 2006 20:56:56 +0200, maxim2k <maxim2k_at_gmail&#46;<!--nospam-->com> wrote:

<i class="quotelev1">>On 6/8/06 6:30 PM, Brian Peasland wrote:</i><br>
<i class="quotelev2">>> Does your dbshut script perform a simple SHUTDOWN or SHUTDOWN NORMAL?</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">>The dbshut script I'm using is shipped with Oracle Database 10g R2 and </i><br>
<i class="quotelev1">>already uses SHUTDOWN IMMEDIATE.</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">>Any other idea?</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">>Thanks.</i><br>

Sometimes one can be forced to
<br>

shut down the job queue interface by setting job_queue_processes to 0 shut down the advanced queuing interface by setting aq_tm_processes to 0
<br>

shuttting down any agent connecting to the database.

--
Sybrand Bakker, Senior Oracle DBA


<span id="received"><dfn>Received on</dfn> Thu Jun 08 2006 - 14:27:31 CDT</span>

</div>