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: Howard J. Rogers <dba_at_hjrdba.com>
Date: Fri, 30 Nov 2001 19:47:07 +1100
Message-ID: <3c074783$0$7489$afc38c87@news.optusnet.com.au>


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?
Received on Fri Nov 30 2001 - 02:47:07 CST

Original text of this message

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