Re: ora-01031; insufficient privileges

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 21 Feb 2001 14:55:38 +0100
Message-ID: <14i79t406vttv9hup789ql30msa9m5kl91@4ax.com>

On Wed, 21 Feb 2001 14:39:38 -0500, Maciej Kwapulinski <pikpok_at_univ.gda.pl> wrote:

>Hallo
>I have the following problem :
>I succesfully created database 'dpikpok'
>when I'm trying to shutdown the database :
>oracle $ id
>uid=(1009) oracle gid=(102) oinstall
>
>oracle $ export ORACLE_SID=dpikpok
>
>oracle $ sqlplus
>..
>user-name : system
>password: manager
>
>sql> shutdown
>ora-01031; insufficient privileges
>
>I'm new to racle, so I installed oracle 8.1.7 for sun and creted
>database in usual (default) way
>
>Can You tell me what am I doing wrong ?
>
>greetings
>maciej

You need sysdba or sysoper privilege to shutdown the database. System doesn't have those privileges.
Use

sqlplus /nolog
connect / as sysdba

and in a correct install you should be OK now.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Feb 21 2001 - 07:55:38 CST