Re: /as sysdba insufficient privilege error
- From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>
- To: nileshkum@xxxxxxxxx
- Date: Wed, 4 Feb 2009 15:00:14 -0200
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
>>
>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
