Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: please help: unknown command beginning "SHUTDOWN T..."

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

From: Howard J. Rogers <howardjr_at_www.com>
Date: 2000/06/09
Message-ID: <394075d8$1@news.iprimus.com.au>#1/1

"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 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US