Re: Need help creating a database

From: Ronald Rood <devnull_at_ronr.nl>
Date: Tue, 8 Nov 2005 20:24:26 +0100
Message-ID: <0001HW.BF96B9FA0093AF7DF0305550@news.individual.net>

On Tue, 8 Nov 2005 05:27:48 +0100, Randy Harris wrote (in article <8PVbf.9970$Lv.6170_at_newssvr24.news.prodigy.net>):

> 
> <fitzjarrell_at_cox.net> wrote in message
> news:1131419862.042156.16930_at_o13g2000cwo.googlegroups.com...

>>
>> Randy Harris wrote:

>>> <bdbafh_at_gmail.com> wrote in message
>>> news:1131403346.235726.187250_at_g44g2000cwa.googlegroups.com...
>>>> what is your server operating system?
>>>> 
>>> 
>>> Solaris 8
>>> Oracle is 9.2.0.4

>>
>>
>> Simply because the 'dba' group is one of many assigned to the 'oracle'
>> account does not make it the default. My guess is the default group
>> for 'oracle' is 'oinstall' and 'dba' is simply another group to which
>> 'oracle' has access. Do this:
>>
>> $ newgrp dba
>> $ sqlplus "/ as sysdba"
>> ....
>>
>> You SHOULD see 'Connected to an idle instance.' If this is the case
>> you then need to edit the /etc/passwd file to make the 'dba' group the
>> primary group for 'oracle' by assigning its group number to the oracle
>> account entry in place of the current group id referencing the
>> 'oinstall' group. Then, log out from the 'oracle' UNIX account and log
>> in again. You should see all of your 'insufficient privileges' errors
>> disappear for 'connect / as sysdba'.
>>
>>
>> David Fitzjarrell
>>

> 
> Thanks for the suggestion. I double checked, dba is the default (and only)
> group for the oracle user. I tried the "newgrp dba" to be sure, bit it
> didn't help. Still getting insufficient privileges with connect / as sysdba.
> 
> Any other ideas? I'm getting desperate.

What is the privileged group in $ORACLE_HOME/rdbms/lib/config.s ? Your dba account should be member of that group. (Look for something like SS_DBA_GRP) With kind regards / met vriendelijke groeten, Ronald

http://ciber.nl
http://homepage.mac.com/ik_zelf/oracle Received on Tue Nov 08 2005 - 13:24:26 CST