Sqlplus says insufficient privileges

When I try to connect to my oracle database on my RHEL4 server I get this error:
ORA-01031: insufficient privileges
to connect I am typing:
[oracle@pavo3 ~]$ sqlplus / as sysdba
This is my bash_profile
             unset USERNAME
             export ORACLE_HOME=/opt/nnoracle/u01/app/oracle/product/10.2.0/db_1
             export ORACLE_BASE=/opt/nnoracle/u01/app/oracle
             export ORACLE_SID=titan
             PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
             export PATH
I have the owenership on directories u01-8 all as oracle:oinstall
I have done several oracle installs but I cant seem to figure this out.  Any ideas?
frobie192Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

johnsoneSenior Oracle DBACommented:
Normally to connect as sysdba, you need to be in the dba group on the UNIX side.  What do you get if you run id in UNIX?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
frobie192Author Commented:
[oracle@pavo3 ~]$ id
uid=500(oracle) gid=500(oinstall) groups=500(oinstall)

However when I look at the groups file the oracle user is in the dba group:
root:x:0:root
bin:x:1:root,bin,daemon
daemon:x:2:root,bin,daemon
sys:x:3:root,bin,adm
adm:x:4:root,adm,daemon
tty:x:5:
disk:x:6:root
lp:x:7:daemon,lp
mem:x:8:
kmem:x:9:
wheel:x:10:root
mail:x:12:mail
news:x:13:news
uucp:x:14:uucp
man:x:15:
games:x:20:
gopher:x:30:
dip:x:40:
ftp:x:50:
lock:x:54:
nobody:x:99:
users:x:100:
dbus:x:81:
floppy:x:19:
vcsa:x:69:
rpm:x:37:
haldaemon:x:68:
utmp:x:22:
netdump:x:34:
nscd:x:28:
slocate:x:21:
sshd:x:74:
rpc:x:32:
rpcuser:x:29:
nfsnobody:x:4294967294:
mailnull:x:47:
smmsp:x:51:
pcap:x:77:
xfs:x:43:
ntp:x:38:
gdm:x:42:
oinstall:x:500:
dba:x:501:500:
0
johnsoneSenior Oracle DBACommented:
Try doing

newgrp dba

That should change you to the dba group and then it should work.  I would guess that if you look in /etc/passwd the dba group is not your default group.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

frobie192Author Commented:
ok I got it, 500 was put in there because that is the uid of the user oracle, it has to be the actual username and not the uid.  Is that true in all distrobutions or only RHEL?
0
johnsoneSenior Oracle DBACommented:
No, that is true of all versions of UNIX that I have ever worked with.
0
frobie192Author Commented:
I appreciate the assistance, thank you very much.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.