Re: Insuffient privileges for user SYS

"Marc Bruinsma" <marc.bruinsma_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 Received on Thu Aug 30 2007 - 07:38:41 CDT