Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!c03.atl99!news.webusenet.com!newsfeed.icl.net!newsfeed.fjserv.net!nntp.theplanet.net!inewsm1.nntp.theplanet.net!newspeer.lavaseals.co.uk!diablo.theplanet.net!news.indigo.ie!not-for-mail
Reply-To: "Telemachus" <ihatespam@pleasenospam.org>
From: "Telemachus" <telemachus@ulysseswillreturn.net>
Newsgroups: comp.databases.oracle.server
References: <1046683618.662160@ftp.adept.co.za> <3e6368db.22201921@read.news.fr.uu.net>
Subject: Re: SQL Statement Shutdown
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <l9K8a.31$pK2.230@news.indigo.ie>
Date: Mon, 3 Mar 2003 15:03:44 -0000
NNTP-Posting-Host: 62.77.170.89
X-Complaints-To: abuse@eircom.net
X-Trace: news.indigo.ie 1046703825 62.77.170.89 (Mon, 03 Mar 2003 15:03:45 GMT)
NNTP-Posting-Date: Mon, 03 Mar 2003 15:03:45 GMT
Organization: Eircom.Net http://www.eircom.net
Xref: newsfeed1.easynews.com comp.databases.oracle.server:178258
X-Received-Date: Mon, 03 Mar 2003 08:03:38 MST (news.easynews.com)

Groan....


Check out  the intelligent agent documentation.

Shutdown is not an SQL statement; it is an SQL*Plus command. Please use OEM
if you want to do this sort of thing.
"Patrice Castet" <patrice.castet@___nospaaaaam____in-fusio.com> wrote in
message news:3e6368db.22201921@read.news.fr.uu.net...
> what do you want to shutdown ? the database ? a dispatcher ?
> by the way "shutdown abort" is like you "kill" your database, it has
> to perform a recovery when restarting !
> I advice you to use "shutdown immediate" which stop it cleanly instead
> of "abort". The "abort" option must not be used except for emergency
> issues.
>
>
>
> On Mon, 3 Mar 2003 11:26:51 +0200, "James" <james@nothing.com> wrote:
>
> >Hi there
> >I've also posted this question on comp.databases.oracle.server!
> >I want to shutdown using a sql statement. The SQL plus statement is
SHUTDOWN
> >ABORT
> >What is the SQL statement for this?
> >I thought it was ALTER SYSTEM SHUTDOWN dispatcher_name but it is not
working
> >for me.
> >
> >I'm using Oracle 9 on windows
> >Cheers
> >James
> >
> >
> >
>