Re: Need help creating a database

<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. Received on Mon Nov 07 2005 - 22:27:48 CST