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: Helma <helma.vinke_at_hotmail.com>
Date: Thu, 30 Aug 2007 06:03:12 -0700
Message-ID: <1188478992.976537.272500@y42g2000hsy.googlegroups.com>


On Aug 30, 2:38 pm, "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

su - oracle , not su oracle if you want to have the oracle environment.
H. Received on Thu Aug 30 2007 - 08:03:12 CDT

Original text of this message

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