RE: /as sysdba insufficient privilege error
From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Wed, 4 Feb 2009 16:09:45 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F0B709EE9_at_AAPQMAILBX02V.proque.st>
Ok....so, don't keep us in suspense! What was the resolution???
Date: Wed, 4 Feb 2009 16:09:45 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F0B709EE9_at_AAPQMAILBX02V.proque.st>
Ok....so, don't keep us in suspense! What was the resolution???
-- Mark J. Bobak Senior Database Administrator, System & Product Technologies ProQuest 789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346 +1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak_at_proquest.com<mailto:mark.bobak_at_il.proquest.com> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com> ProQuest...Start here. From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of nilesh kumar Sent: Wednesday, February 04, 2009 4:04 PM To: JBECKSTROM_at_gcrta.org Cc: ORACLE-L Subject: Re: /as sysdba insufficient privilege error Hello All, It got resolved!! Thanks for all your help. Thanks Nilesh On Wed, Feb 4, 2009 at 10:09 PM, Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org<mailto:JBECKSTROM_at_gcrta.org>> wrote: Check that you are logged into the domain server. In the past, when the domain server would go down, we would get this error. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113Received on Wed Feb 04 2009 - 15:09:45 CST
>>> Guillermo Alan Bort <cicciuxdba_at_gmail.com<mailto:cicciuxdba_at_gmail.com>> 2/4/09 11:26 AM >>>
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<mailto: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-l --------------------------------------------------------------------- Scanning of this message and addition of this footer is performed by SurfControl E-mail Filter software in conjunction with virus detection software. -- Thanks Nilesh Soni Oracle DBA--OCA 10g Oracle is not a magic..it takes years of experiance :-) 9860584034 -- http://www.freelists.org/webpage/oracle-l