Re: SQL Statement Shutdown

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Mon, 3 Mar 2003 15:03:44 -0000
Message-ID: <l9K8a.31$pK2.230@news.indigo.ie>

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_at_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_at_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
> >
> >
> >
>
Received on Mon Mar 03 2003 - 09:03:44 CST