Re: insufficient privileges

EscVector wrote:
> orcldba2001_at_gmail.com wrote:
> > Oracle version 9.2.0.4.0
> > OS = Windows 2000 server
> >
> > I have a domain account on a server and I am a member of
> > ORA_DBA and Adminstrator group
> >
> > I open a command window and set
> > oracle_home and
> > oracle_sid
> >
> >
> > However when I try to login without a password
> >
> >
> >
> > sqlplus
> >
> > SQL*Plus: Release 9.2.0.4.0 - Production on Mon Nov 27 13:08:28 2006
> >
> > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> >
> > Enter user-name: /as sysdba
> > ERROR:
> > ORA-01031: insufficient privileges
>
> This is all that is necessary if the OS software was never restored.
>
> 1. you are in the ORA_DBA group - check
> 2. SQLNET.AUTHENTICATION_SERVICES=(NTS) in sqlnet.ora file
>
> Extras if still not working:
> 3. the sid is set locally or in registry - check
> 3a. you set the home if multihomed - check
> 3b. If multihomed, check your path with the univeral installer
> environment tab making sure current home is first in path.
> 4. NAMES.DEFAULT_DOMAIN=thenameofyourwindowdomain.com in sqlnet.ora
>
> If you've let the init auth levels default, steps 1&2 should get it to
> work.

Nice to have someone that works with oracle on windows help out! We don't do that around here ... and I often forget the steps. #2 is often a problem if I remember correctly. Received on Tue Nov 28 2006 - 06:39:23 CST