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, don't keep us in suspense!  What was  the resolution???

Mark J. Bobak
Senior Database Administrator, System & Product Technologies
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059  or +1.800.521.0600 x 4059

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
Subject: Re: /as sysdba insufficient privilege error

Hello All,

It got resolved!!
Thanks for all your help.

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.

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 - Production on Wed Feb 4 20:22:29 2009
> Copyright (c) 1982, 2005, Oracle.  All rights reserved.
> ORA-01031: insufficient privileges
> Enter user-name:
> --
> Thanks
> Nilesh Soni
> Oracle is not a takes years of experiance :-)
> 9860584034


Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with
virus detection software.

Nilesh Soni
Oracle DBA--OCA 10g
Oracle is not a takes years of experiance :-)

Other related posts: