Hi,
I am a newbie and i am going through the Oracle DBA guide. It says
you should be able to use connect / as sysdba. But i am not able to
connect. I get the following error.

ERROR:
ORA-01031: insufficient privileges

I am in ORA_DBA group in windows. My init.ora file says
remote_login_passwordfile=EXCLUSIVE
My sqlnet.ora has the line authentication line commented out like
#SQLNET.AUTHENTICATION_SERVICES= (NTS)

I would appreciate any help.

Regards,
Raj

On Mon, 08 May 2006 13:31:22 -0700, Raj wrote:

> Hi,
> I am a newbie and i am going through the Oracle DBA guide. It says
> you should be able to use connect / as sysdba. But i am not able to
> connect. I get the following error.
>
> ERROR:
> ORA-01031: insufficient privileges
>
> I am in ORA_DBA group in windows. My init.ora file says
> remote_login_passwordfile=EXCLUSIVE
> My sqlnet.ora has the line authentication line commented out like
> #SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> I would appreciate any help.
>

I assume you are on the same machine as the database.

Can you log on using the userid that installed the database software?

--
mailto: Fuzzy_dot_GreyBreard_at_gmail_dot_com
Top posting in newsgroups is a sure way to stop my replies!

I reserve the right to change my mind on anything. Especially when confronted with facts that are better than the ones I use right now.

Raj wrote:
> Hi,
> I am a newbie and i am going through the Oracle DBA guide. It says
> you should be able to use connect / as sysdba. But i am not able to
> connect. I get the following error.
>
> ERROR:
> ORA-01031: insufficient privileges
>
> I am in ORA_DBA group in windows. My init.ora file says
> remote_login_passwordfile=EXCLUSIVE
> My sqlnet.ora has the line authentication line commented out like
> #SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> I would appreciate any help.
>
> Regards,
> Raj
>
The OS user you log in as must be part of the DBA group in /etc/group
for SYSDBA connections and OPER group in /etc/group for SYSOPER connections.

Rgds.
Amogh

Amogh wrote:
> Raj wrote:
>
>> Hi,
>> I am a newbie and i am going through the Oracle DBA guide. It says
>> you should be able to use connect / as sysdba. But i am not able to
>> connect. I get the following error.
>>
>> ERROR:
>> ORA-01031: insufficient privileges
>>
>> I am in ORA_DBA group in windows. My init.ora file says
>> remote_login_passwordfile=EXCLUSIVE
>> My sqlnet.ora has the line authentication line commented out like
>> #SQLNET.AUTHENTICATION_SERVICES= (NTS)
>>
>> I would appreciate any help.
>>
>> Regards,
>> Raj

>>
> The OS user you log in as must be part of the DBA group in /etc/group
> for SYSDBA connections and OPER group in /etc/group for SYSOPER
> connections.
>
I'm sorry. I missed reading that you are on windows.

>>My sqlnet.ora has the line authentication line commented out like
>>#SQLNET.AUTHENTICATION_SERVICES= (NTS)

Un-comment the line:

SQLNET.AUTHENTICATION_SERVICES= (NTS)

HTH

Carlos.

Yes, the DB runs on my laptop and i am trying to connect from the same
machine. I installed it as myself and i can logon as
connect sys/sys as sysdba
but connect / as sysdba does not work.

Thanks,
Raj

I tried it. It doesn't work.

Thanks,
Raj

Raj wrote:
> Yes, the DB runs on my laptop and i am trying to connect from the same
> machine. I installed it as myself and i can logon as
> connect sys/sys as sysdba
> but connect / as sysdba does not work.
>

Seeing as how the "as sysdba" syntax ignores the username and password,
I'm sort of wondering what you are really doing:

C:\Documents and Settings\joelg>sqlplus "sdflj/boobobo as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Beta on Tue May 9 14:08:34 2006

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

SQL>

First of all, what version are you on?
How did you create the password file? Are you absolutely sure you
spelled the filename correctly? *pwd* instead of *pw* will blow you
off.
Have you tried remote_login_passwordfile=none? The parameters changed
from 9i to 10g. Are you conversant with the differences between pfile
and spfile?
What are the _exact_ commands you are entering?
What happens when you try it in quotes from the shell, like
sqlplus "/ as sysdba"
How are you setting up your environment? Do you have an environment
chooser?

Please remember to briefly quote what you are replying to, as in a
newsgroup your replies won't necessarily follow the posts.

jg
--
@home.com is bogus.
ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1, column 1
ORA-20000: Oracle Text error:
DRG-50901: text query parser syntax error on line 1, column 1
You might need to remove punctuation or the keywords AND, OR, NOT.

Raj wrote:
> I tried it. It doesn't work.
>
> Thanks,
> Raj

You need to be logged in to your machine as a local user e.g.
Administrator for this to work.

1) Create a local user and add him to Administrators and ORA_DBA groups
or if using Administrator then add Administrator to ORA_DBA group.
2) Put sqlnet.authentication_services = (NTS) in your sqlnet.ora file.

Try again.

Regards
/Rauf

Thanks. It works now. I used to login as a domain user without being
connected to domain. I had logged in as cad\raj from the domain cache.
It did not work then.

Now i created a local user raj and added it to ORA_DBA group. Now it
works for the local user. I am not sure if being actually connected to
the domain would help.

Regards,
Raj


++++++++++++++++++++++++++++++++
I get the following error.

ERROR:
ORA-01031: insufficient privileges

I am in ORA_DBA group in windows. My init.ora file says
remote_login_passwordfile=EXCLUSIVE
My sqlnet.ora has the line authentication line commented out like
#SQLNET.AUTHENTICATION_SERVICES= (NTS)