Re: /as sysdba insufficient privilege error
From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Wed, 4 Feb 2009 14:26:26 -0200
Message-ID: <172762180902040826r7bb528fwc61cdf4c93753e33_at_mail.gmail.com>
check that your user is member of the ORA_DBA group in windows, that both LOCAL and ORACLE_SID env variables are pointing to a valid tnsnames entry, that TNS_ADMIN is pointing to a valid directory (containing a tnsnames.ora) and that SQLNET.AUTHENTICATION_SERVICES is pointing to NTS.
Date: Wed, 4 Feb 2009 14:26:26 -0200
Message-ID: <172762180902040826r7bb528fwc61cdf4c93753e33_at_mail.gmail.com>
check that your user is member of the ORA_DBA group in windows, that both LOCAL and ORACLE_SID env variables are pointing to a valid tnsnames entry, that TNS_ADMIN is pointing to a valid directory (containing a tnsnames.ora) and that SQLNET.AUTHENTICATION_SERVICES is pointing to NTS.
hth
Alan Bort
Oracle Certified Associate
On Wed, Feb 4, 2009 at 12: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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 04 2009 - 10:26:26 CST