Insuffient privileges for user SYS

From: Odd Bjørn Andersen <obande_at_online.no>
Date: Thu, 30 Aug 2007 12:17:10 +0200
Message-ID: <46d69926$0$90272$14726298@news.sunsite.dk>

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 Received on Thu Aug 30 2007 - 05:17:10 CDT