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

Re: insufficient privileges

From: EscVector <Junk_at_webthere.com>
Date: 27 Nov 2006 22:44:31 -0800
Message-ID: <1164696271.464992.43990@j72g2000cwa.googlegroups.com>

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. Received on Tue Nov 28 2006 - 00:44:31 CST

Original text of this message

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