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: insufficient privileges

Re: insufficient privileges

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 20 Nov 2002 21:17:21 -0000
Message-ID: <3ddc287a$2_3@mk-nntp-1.news.uk.worldonline.com>


"Thomas Aichinger" <taich_at_gmx.at> wrote in message news:92c0776e.0211181302.4773ca1_at_posting.google.com...
> Hi!
>
> I installed oracle 8.1.7 on my linux box. It runs quite well.
> I can create tables and so on. I can use svrmgr to start and stop my
> database, but I cant shutdown from sqlplus. I need that to change
> CHARACTER SET.
>

As a privileged user (oracle or dba group on unix, Admin member on windows):

set ORACLE_SID env variable

sqlplus '/ as sysdba' on unix
same on windows but double quotes.

shutdown (mode)

Regards,
Paul Received on Wed Nov 20 2002 - 15:17:21 CST

Original text of this message

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