RE: /as sysdba insufficient privilege error
Date: Wed, 4 Feb 2009 11:29:13 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F0B7092E1_at_AAPQMAILBX02V.proque.st>
Hmm....I'm by no means a Windows expert.
Have you tried MetaLink Doc Id 114384.1 "WIN: Checklist for Resolving CONNECT AS SYSDBA Issues" ??
Hope that helps,
-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
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: nilesh kumar [mailto:nileshkum_at_gmail.com]
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<mailto: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
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> [mailto: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:29:13 CST