Re: please help: unknown command beginning "SHUTDOWN T..."

From: vgavan <vgavan_at_hotmail.com>
Date: 2000/06/09
Message-ID: <l_%%4.12416$e5.172177_at_news1.frmt1.sfba.home.com>#1/1


[Quoted] I use the same script with 8.16. How do you do scheduled shutdown to take a backup?

Thanks

--
~~~~~~~~~~~~~~~~~~~~~~~~~
[Quoted] Vadim Gavan
vgavan_at_hotmail.com
[Quoted] [Quoted] "Howard J. Rogers" <howardjr_at_www.com> wrote in message
[Quoted] news:394075d8$1_at_news.iprimus.com.au...

>
> "vgavan" <vgavan_at_hotmail.com> wrote in message
> news:_sW%4.31230$2X2.268558_at_newsread2.prod.itd.earthlink.net...
> > I am getting "unknown command" message while trying to shutdown:
> > ALTER SYSTEM CHECKPOINT;
> > SHUTDOWN TRANSACTIONAL;
> > EXIT;
> > /
>
> --------------------------------------------------------------------------
> --
> > --------------
> > (c) Copyright 1997 Oracle Corporation. All rights reserved.
> >
> > Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=ORAC))
> > The command completed successfully
> >
> > SQL*Plus: Release 8.0.5.0.0 - Production on Thu Jun 8 16:48:1 2000
> >
>
>
> I don't know if this is relevant, but SQL*Plus cannot be used to issue
> privileged commands. A Privileged action is, basically, startup,
shutdown,
> recover and create. If you want to do any of those things, you have got
to
> be using Server Manager (at least in 8.05 and before. I've been told
since
> day 1 that SQL*Plus will one day have the ability to perform these
> privileged actions, but I'm still waiting -though I think 8.1.6 has it).
>
> See if that helps.
> HJR
>
>
>
>
> > (c) Copyright 1998 Oracle Corporation. All rights reserved.
> >
> >
> > Connected to:
> > Oracle8 Release 8.0.5.0.0 - Production
> > PL/SQL Release 8.0.5.0.0 - Production
> >
> >
> > System altered.
> >
> > unknown command beginning "SHUTDOWN T..." - rest of line ignored.
> > Disconnected from Oracle8 Release 8.0.5.0.0 - Production
> > PL/SQL Release 8.0.5.0.0 - Production
> >
> > SQL*Plus: Release 8.0.5.0.0 - Production on Thu Jun 8 16:49:12 2000
> >
> > (c) Copyright 1998 Oracle Corporation. All rights reserved.
> >
> >
> >
>
>
Received on Fri Jun 09 2000 - 00:00:00 CEST

Original text of this message