Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Insuffient privileges for user SYS
<posted & mailed>
Odd Bjørn 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.
Received on Thu Aug 30 2007 - 05:46:47 CDT