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
It'd also be worth checking to see what the value of the environment
variable oracle_sid is set to.
Also I'm a bit confused. don't we also have to check if the instance is configured to use a password file and if so what the sysdba password is set at - or has that all gone under 9i?
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Rick Wessman" <Rick.Wessman_at_oracle.com> wrote in message news:soclmgbdkkv.fsf_at_rwessman-sun.us.oracle.com...Received on Tue Dec 11 2001 - 05:39:43 CST
> 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.