RE: /as sysdba insufficient privilege error

  • From: "Robert Buda" <rjbuda@xxxxxxxxxxxxxxxxxx>
  • To: <nileshkum@xxxxxxxxx>, "'Bobak, Mark'" <Mark.Bobak@xxxxxxxxxxxx>
  • Date: Wed, 4 Feb 2009 11:39:16 -0500

Try setting the TWO_TASK environment variable to the SID. 

 

 

 

Robert Buda

Buda Consulting, Inc

100 Overlook Center, 2nd Floor

Princeton, NJ 08540

609 375-2368

www.budaconsulting.com

  _____  

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of nilesh kumar
Sent: Wednesday, February 04, 2009 11:26 AM
To: Bobak, Mark
Cc: ORACLE-L
Subject: Re: /as sysdba insufficient privilege error

 

yes i see those entires

On Wed, Feb 4, 2009 at 9:30 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx> wrote:

Do you have:

SQLNET.AUTHENTICATION_SERVICES=(NTS)

 

In your sqlnet.ora?

 

Is your Windows user in the ORA_DBA group?

 

-Mark

 

--
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
 <mailto:mark.bobak@xxxxxxxxxxxxxxx> mark.bobak@xxxxxxxxxxxx
 <http://www.proquest.com> www.proquest.com
 <http://www.csa.com> 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 9:56 AM
To: ORACLE-L
Subject: /as sysdba insufficient privilege error

 

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




-- 
Thanks
Nilesh Soni
Oracle DBA--OCA 10g
Oracle is not a magic..it takes years of experiance :-)
9860584034

Other related posts: