RE: /as sysdba insufficient privilege error

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
  • To: "nileshkum@xxxxxxxxx" <nileshkum@xxxxxxxxx>, "JBECKSTROM@xxxxxxxxx" <JBECKSTROM@xxxxxxxxx>
  • Date: Wed, 4 Feb 2009 16:09:45 -0500

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@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of nilesh kumar
Sent: Wednesday, February 04, 2009 4:04 PM
To: JBECKSTROM@xxxxxxxxx
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@xxxxxxxxx<mailto:JBECKSTROM@xxxxxxxxx>> 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 44113

>>> Guillermo Alan Bort <cicciuxdba@xxxxxxxxx<mailto:cicciuxdba@xxxxxxxxx>> 
>>> 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@xxxxxxxxx<mailto: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


---------------------------------------------------------------------


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

Other related posts: