Re: ORA-01031 insufficient privileges - what am i missing?

On Oct 29, 1:56 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Oct 29, 2:56 am, Helma <helma.vi..._at_hotmail.com> wrote:
>
>
>
> > On Oct 29, 8:29 am, Helma <helma.vi..._at_hotmail.com> wrote:
>
> > > Hello people,
>
> > > Just made a fresh Ora10 install, and i get the dreaded ora-01031
> > > insufficient privileges
> > > when i try a connect / as sysdba or a connect sys/change_on_install as
> > > sysdba from the console. Haven't had this one before when installing a
> > > 10.
>
> > > i checked the permissions of the oracle user:
>
> > > id
> > > uid=501(oracle) gid=501(oracle) groups=501(oracle)
>
> > > echo $ORACLE_HOME
> > > /home/oracle/product/10.2.0
>
> > > echo $ORACLE_SID
> > > production2
>
> > > the softlink $ORACLE_HOME/dbs/initproduction2.ora has user and group
> > > oracle , as has the file it points to.
>
> > > i changed the remote_password_file from exclusive to none.
>
> > > What should i check?
> > > Thanks in advance,
> > > Helma
>
> > Not the first time this happens to me, but right after i ask for help
> > i find some new information that could have helped me sorting it out
> > on my own: an ora-01031 checklist on metalink. Let me get back to you
> > if that doesn't do the trick.
>
> > HV- Hide quoted text -
>
> > - Show quoted text -
>
> The group should be 'dba', not 'oracle'.
>
> David Fitzjarrell

They are not using a DBA group here, they named it ORACLE as well. This how it works on the Ora9 machine, i should stick to this on the ora10 machine.

Helma Received on Mon Oct 29 2007 - 09:22:06 CDT