Re: insufficient privileges

From: Svend Jensen <svend.jensenKILLSPAM_at_it.dk>
Date: Tue, 19 Nov 2002 21:52:35 +0000
Message-ID: <3DDAB2A3.5080606@it.dk>

Try
sqlplus /nolog
SQL> connect sys/password_at_tns_name as sysdba SQL> shutdown ....

/Svend

Thomas Aichinger wrote:
> 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.
>
> oracle_at_coconut:~> sqlplus
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Mon Nov 18 21:52:04 2002
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> Enter user-name: SYS AS SYSDBA
> Enter password:
>
> Connected to:
> Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.1 - Production
>
> SQL> shutdown normal;
> ORA-01031: insufficient privileges
> SQL>
>
> Please help - I'm stuck
>
> Regards
> Thomas
Received on Tue Nov 19 2002 - 15:52:35 CST