RE: /as sysdba insufficient privilege error

From: Robert Buda <rjbuda_at_budaconsulting.com>
Date: Wed, 4 Feb 2009 11:39:16 -0500
Message-ID: <00ec01c986e7$1ef50030$6610a8c0_at_BudaConsulting.local>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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_at_proquest.com> 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_at_il.proquest.com> mark.bobak_at_proquest.com

 <http://www.proquest.com> www.proquest.com

 <http://www.csa.com> 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 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



--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 04 2009 - 10:39:16 CST