Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: insufficient privileges
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.
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
![]() |
![]() |