Insuffient privileges for user SYS

Odd Bjørn Andersen

unread,

Aug 30, 2007, 6:17:10 AM8/30/07

to

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

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

Marc Bruinsma

unread,

Aug 30, 2007, 6:46:47 AM8/30/07

to

Odd Bjørn Andersen wrote:

Are you logged into SQL+ as root? su to the oracle software owner, set the
variables (or use . oraenv) and try again.

Odd Bjørn Andersen

unread,

Aug 30, 2007, 8:38:41 AM8/30/07

to

"Marc Bruinsma" <marc.b...@chello.nl> wrote in message
news:zexBi.695$9V2.458@amstwist00...
> <posted & mailed>

I did su to oracle, and used oraenv, but still got the same messages
'insuffisient privileges'.

Odd B Andersen

Helma

unread,

Aug 30, 2007, 9:03:12 AM8/30/07

to

On Aug 30, 2:38 pm, "Odd Bjørn Andersen" <oba...@online.no> wrote:
> "Marc Bruinsma" <marc.bruin...@chello.nl> wrote in message

su - oracle , not su oracle if you want to have the oracle
environment.
H.

fitzj...@cox.net

unread,

Aug 30, 2007, 9:18:56 AM8/30/07

to

On Aug 30, 7:38 am, "Odd Bjørn Andersen" <oba...@online.no> wrote:
> "Marc Bruinsma" <marc.bruin...@chello.nl> wrote in message

> Odd B Andersen- Hide quoted text -
>
> - Show quoted text -

You need to use 'su - oracle' to get the proper environment:

bash-2.03# su - oracle
$

Also you need to verify that the proper user group (dba) is assigned
to 'oracle' at login:

$ touch testfile
$ ls -l testfile
-rw-rw-r-- 1 oracle dba 0 Aug 30 08:16 testfile

At this point you can verify the ORACLE_SID is correct, invoke sqlplus
and start your database. And you should have no further 'insufficient
privileges' errors.

David Fitzjarrell