Re: /as sysdba insufficient privilege error

also, make sure db service is up and listener is up.

And that you have a password file ^_^

hth
Alan Bort
Oracle Certified Associate



On Wed, Feb 4, 2009 at 2:26 PM, Guillermo Alan Bort
<cicciuxdba@xxxxxxxxx> wrote:
> 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@xxxxxxxxx> 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-l


Other related posts: