Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01031 insufficient privileges - what am i missing?

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

From: <fitzjarrell_at_cox.net>
Date: Mon, 29 Oct 2007 05:56:03 -0700
Message-ID: <1193662563.592526.314780@o38g2000hse.googlegroups.com>


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 Received on Mon Oct 29 2007 - 07:56:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US