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: Marc Bruinsma <marc.bruinsma_at_chello.nl>
Date: Thu, 30 Aug 2007 12:46:47 +0200
Message-ID: <zexBi.695$9V2.458@amstwist00>


<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

Original text of this message

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