Home » RDBMS Server » Security » ORA-01031: insufficient privileges
ORA-01031: insufficient privileges [message #260960] Tue, 21 August 2007 06:32 Go to next message
jainarayan5484
Messages: 38
Registered: August 2006
Location: DELHI
Member
i issue the command like


C:\>sqlplus "/ as sysdba" on window environment

but give the error like

ERROR:
ORA-01031: insufficient privileges

how can resolve error
Re: ORA-01031: insufficient privileges [message #260966 is a reply to message #260960] Tue, 21 August 2007 06:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
how can resolve error

Just searching.
This error is made and posted almost once per week.

Regards
Michel
Re: ORA-01031: insufficient privileges [message #260967 is a reply to message #260960] Tue, 21 August 2007 06:47 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member



The user by which you are invoking sqlplus commnad that user must be a member of OSDBA group.

In unix make the user of group dba and in windows ORA_DBA.
Re: ORA-01031: insufficient privileges [message #261024 is a reply to message #260967] Tue, 21 August 2007 09:37 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
In addition to ARJU

change sqlnet.ora file "sqlnet.authentication_services=NTS"
Re: ORA-01031: insufficient privileges [message #261121 is a reply to message #260960] Tue, 21 August 2007 22:04 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I want to say one thing, May be I am wrong.



The parameter sqlnet.authentication_services enables just no or one or more authentication services.(NONE,'...',ALL).
sqlnet.authentication_services=NTS


1.This setting has no impact if you are in server machine.Only if you are the user of OSDBA group you can connect by / as sysdba

2. Above settings has no impact if the server and client machine are both run on linux.

3. That settings will have only impact if the client machine is WINDOWS NT Native ( that is Windows XP,2003).
Re: ORA-01031: insufficient privileges [message #261175 is a reply to message #261121] Wed, 22 August 2007 01:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
1.This setting has no impact if you are in server machine.Only if you are the user of OSDBA group you can connect by / as sysdba

These 2 points are in conflict.
This has impact if you are on server and want to connect with /.
This has no impact if you are not on server or don't want to connect with /.
Quote:
2. Above settings has no impact if the server and client machine are both run on linux

The NTS setting is specific to Windows (as its name says).
If you put this in linux you will no more be able to connect as /.
Quote:
3. That settings will have only impact if the client machine is WINDOWS NT Native

It is important on server side.

Regards
Michel


Re: ORA-01031: insufficient privileges [message #261190 is a reply to message #260960] Wed, 22 August 2007 02:11 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Thank You Michel for clarifying it. I should write it after testing.
Previous Topic: Find IP Addresses
Next Topic: Prevent DBA to change password of owner of encrypted data
Goto Forum:
  


Current Time: Thu Mar 28 16:55:03 CDT 2024