Re: Need help creating a database

From: <fitzjarrell_at_cox.net>
Date: 7 Nov 2005 20:59:54 -0800
Message-ID: <1131425994.065182.62230@g47g2000cwa.googlegroups.com>

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

Not without actually seeing your installation, however another suspiscion I have is you didn't run root.sh during the installation, thus leaving incorrect permissions on some executables in $ORACLE_HOME/bin.

David Fitzjarrell Received on Mon Nov 07 2005 - 22:59:54 CST