Re: Need help creating a database

On Tue, 08 Nov 2005 04:27:48 GMT, "Randy Harris" <randy_at_SpamFree.com> wrote:

>
><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.
>
>

Check the Oracle executable, which group it belongs too, and whether the suid bit has been set.
Also check the installation log, to find out, whether you really linked Oracle using the dba group.

--
Sybrand Bakker, Senior Oracle DBA