Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: insufficient privileges
hpuxrac wrote:
> 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.
I always used to bug me that we had so many windows problems and it always seemed a mystery, so I branched out and learned windows. My current favorite OS is AIX. Linux and Solaris tie for second, but this should be for a new thread...
The NTS issue always gets me annoyed. I can be a real problem if the machine is rebuilt. Received on Tue Nov 28 2006 - 09:13:11 CST