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: insufficient privileges PROBLEM. Can'T connect as SYSDBA

Re: insufficient privileges PROBLEM. Can'T connect as SYSDBA

From: Rick Wessman <Rick.Wessman_at_oracle.com>
Date: 10 Dec 2001 09:57:36 -0800
Message-ID: <soclmgbdkkv.fsf@rwessman-sun.us.oracle.com>


The parameter is indeed SQLNET.AUTHETICATION_SERVICES and I would definitely bet that it is set to NONE.

                               Rick

"Howard J. Rogers" <dba_at_hjrdba.com> writes:

> First make sure that there is a *local* ORA_DBA group, and that whoever you
> are logged in as when trying to connect is a member of that group. Second,
> your sqlnet.ora probably needs editing. I can't remember the exact name of
> the paramater, but it's something like SQLNET.AUTHENTICATION_SERVICES ...it
> needs to be set to NTS, but is probably sitting there right now set to NONE.
>
> Regards
> HJR
>
> --
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Oliver Berger" <oliver.berger_at_agro-norm.com> wrote in message
> news:d73160f5.0111300001.536f7f22_at_posting.google.com...
> > I've installed an Oracle 9.0.1.0.1 on a fresh W2K machine with SP2.
> > I want to create a new database. Therefore i have to connect
> > with sys/change_on_install as sysdba with sqlplus.
> >
> > Every time i try this, i get the following error:
> >
> > ERROR:
> > ORA-01031 insufficient privileges
> >
> > I am logged in as Administrator on the W2K machine.
> > The user Administrator is member of the ORA_DBA group.
> >
> > Why do i have insufficient privileges?
>
>

-- 
                                Rick Wessman
                                Security Assurance Group
                                Oracle Corporation
                                Rick.Wessman_at_oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.
Received on Mon Dec 10 2001 - 11:57:36 CST

Original text of this message

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