Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: insufficient privileges PROBLEM. Can'T connect as SYSDBA
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