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: Helma <helma.vinke_at_hotmail.com>
Date: Mon, 29 Oct 2007 00:56:00 -0700
Message-ID: <1193644560.229276.222370@22g2000hsm.googlegroups.com>


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

Original text of this message

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