Re: force clean database shutdown

<div class="mail">
<address class="headers">
<span id="from">
<dfn>From</dfn>: maxim2k <maxim2k_at_gmail.com>
</span>
<span id="date"><dfn>Date</dfn>: Fri, 09 Jun 2006 10:09:26 +0200</span>
<span id="message-id"><dfn>Message-ID</dfn>: <1c84e$44892cac$5277c1be$5661_at_news0&#46;<!--nospam-->easynet.it>
</span>
</address>

<br>

On 6/8/06 9:27 PM, Sybrand Bakker wrote:
<br>
<i class="quotelev1">> Sometimes one can be forced to </i><br>
<i class="quotelev1">> shut down the job queue interface by setting job_queue_processes to 0</i><br>
<i class="quotelev1">> shut down the advanced queuing interface by setting aq_tm_processes to</i><br>
<i class="quotelev1">> 0</i><br>

Can I do that using ALTER DATABASE commands?

<i class="quotelev1">> shuttting down any agent connecting to the database.</i><br>

Thanks, I'll have to look some documentation about that, I'm not very experienced with Oracle.

I've another quick question: when rebooting the server, should the automatic script shutdown the listener before the database, or the other way around?

Thanks.
<span id="received"><dfn>Received on</dfn> Fri Jun 09 2006 - 03:09:26 CDT</span>
</div>
Received on Fri Jun 09 2006 - 03:09:26 CDT