frobie192
asked on
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/or acle/produ ct/10.2.0/ db_1
export ORACLE_BASE=/opt/nnoracle/ u01/app/or acle
export ORACLE_SID=titan
PATH=$PATH:$HOME/bin:$ORAC LE_HOME/bi n
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?
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/
export ORACLE_BASE=/opt/nnoracle/
export ORACLE_SID=titan
PATH=$PATH:$HOME/bin:$ORAC
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
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?
No, that is true of all versions of UNIX that I have ever worked with.
ASKER
I appreciate the assistance, thank you very much.
ASKER
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: