Re: /as sysdba insufficient privilege error
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 4 Feb 2009 16:35:57 +0000
Message-ID: <7765c8970902040835w7e5a14c4k8817d126c75fe57_at_mail.gmail.com>
that implies that you are using os authentication.
Date: Wed, 4 Feb 2009 16:35:57 +0000
Message-ID: <7765c8970902040835w7e5a14c4k8817d126c75fe57_at_mail.gmail.com>
that implies that you are using os authentication.
You'll need to be a member of ORA_DBA or ORA_SID_DBA local group You'll need sqlnet.authentication_services=(NTS) set in sqlnet.ora.
Niall
On Wed, Feb 4, 2009 at 2:55 PM, nilesh kumar <nileshkum_at_gmail.com> wrote:
> Hello Good Morning!!
>
> Hope every one doing good.
>
> This morning I am trying to login to my windows database. It showing a
> strange error. How should I resolve this.
>
> D:\>sqlplus "/as sysdba"
>
> SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 4 20:22:29 2009
>
> Copyright (c) 1982, 2005, Oracle. All rights reserved.
>
> ERROR:
> ORA-01031: insufficient privileges
>
>
> Enter user-name:
>
>
> --
> Thanks
> Nilesh Soni
> Oracle is not a magic..it takes years of experiance :-)
> 9860584034
>
>
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 04 2009 - 10:35:57 CST