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>: Fri, 09 Jun 2006 12:03:51 +0200</span>
<span id="message-id"><dfn>Message-ID</dfn>: <nohi8259c28bhmhvukte4p2otdgqute130_at_4ax&#46;<!--nospam-->com>
</span>
</address>

<br>

On Fri, 09 Jun 2006 10:09:26 +0200, maxim2k <maxim2k_at_gmail&#46;<!--nospam-->com> wrote:

<i class="quotelev1">>On 6/8/06 9:27 PM, Sybrand Bakker wrote:</i><br>
<i class="quotelev2">>> Sometimes one can be forced to </i><br>
<i class="quotelev2">>> shut down the job queue interface by setting job_queue_processes to 0</i><br>
<i class="quotelev2">>> shut down the advanced queuing interface by setting aq_tm_processes to</i><br>
<i class="quotelev2">>> 0</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">>Can I do that using ALTER DATABASE commands?</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev2">>> shuttting down any agent connecting to the database.</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">>Thanks, I'll have to look some documentation about that, I'm not very </i><br>
<i class="quotelev1">>experienced with Oracle.</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">>I've another quick question: when rebooting the server, should the </i><br>
<i class="quotelev1">>automatic script shutdown the listener before the database, or the other </i><br>
<i class="quotelev1">>way around?</i><br>
<i class="quotelev1">></i><br>
<i class="quotelev1">>Thanks.</i><br>

You would need to use
<br>

alter system set job_queue_processes=0 [scope=memory] /
<br>

and
<br>

alter system set aq_tm_processes=0 [scope=memory]

I would shutdown the listener first. The other way around and you have a small chance people connect just when you start shutting the database.

--
Sybrand Bakker, Senior Oracle DBA


<span id="received"><dfn>Received on</dfn> Fri Jun 09 2006 - 05:03:51 CDT</span>

</div>