Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Insuffient privileges for user SYS
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
![]() |
![]() |