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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Insuffient privileges for user SYS

Re: Insuffient privileges for user SYS

From: <fitzjarrell_at_cox.net>
Date: Thu, 30 Aug 2007 06:18:56 -0700
Message-ID: <1188479936.321761.232550@r34g2000hsd.googlegroups.com>


On Aug 30, 7:38 am, "Odd Bjørn Andersen" <oba..._at_online.no> wrote:
> "Marc Bruinsma" <marc.bruin..._at_chello.nl> wrote in message
>
> news:zexBi.695$9V2.458_at_amstwist00...
>
>
>
>
>
> > <posted & mailed>
>
> > Odd Bjrn Andersen wrote:
>
> >> I am fairly new to oracle, and have run into a problem that confuses me.
> >> I
> >> tried to create a database manually, and for some reason the create
> >> database script failed. After correcting what was wrong and cleaned up
> >> all
> >> the files I try once again. But now I'm not able to start due to
> >> insufficient privileges for user SYS. Se below:
>
> >> bash-2.03# export ORACLE_HOME=/opt/app/oracle9202
> >> bash-2.03# export ORACLE_SID=testfms
> >> bash-2.03# export PATH=/opt/app/oracle9202/bin:$PATH
> >> bash-2.03# sqlplus /nolog
>
> >> SQL*Plus: Release 9.2.0.2.0 - Production on Thu Aug 30 12:10:25 2007
>
> >> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> >> SQL> connect sys as sysdba
> >> Enter password:
> >> Connected to an idle instance.
> >> SQL> startup nomount
> >> ORA-01031: insufficient privileges
> >> SQL>
>
> >> I used the same user (SYS) the first time, and then it was no problem
> >> starting in nomount mode. This is Oracle 9.2 on Sun OS 5.8.
>
> >> Regards
> >> Odd B Andersen
> >> ErgoGroup AS
> >> Oslo, Norway
> > Are you logged into SQL+ as root? su to the oracle software owner, set the
> > variables (or use . oraenv) and try again.
>
> I did su to oracle, and used oraenv, but still got the same messages
> 'insuffisient privileges'.
>
> Odd B Andersen- Hide quoted text -
>
> - Show quoted text -

You need to use 'su - oracle' to get the proper environment:

bash-2.03# su - oracle
$

Also you need to verify that the proper user group (dba) is assigned to 'oracle' at login:

$ touch testfile
$ ls -l testfile
-rw-rw-r-- 1 oracle dba 0 Aug 30 08:16 testfile

At this point you can verify the ORACLE_SID is correct, invoke sqlplus and start your database. And you should have no further 'insufficient privileges' errors.

David Fitzjarrell Received on Thu Aug 30 2007 - 08:18:56 CDT

Original text of this message

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