OraFAQ Forum: Server Administration » ORA-01031: insufficient privileges

Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01031: insufficient privileges [message #358104]

Sat, 08 November 2008 10:22

orcl dba
Messages: 68
Registered: August 2005

Member

Hi all,

I have an oracle 10.2.0.2 stand-alone database installed on a SuSE SLES10.1 machine. I would like the root user to have sysdba privilege. The user 'root' is a member of the "dba" group. However, when I try to connect to the database from the user 'root', it throws an error:
sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Nov 8 19:10:55 2008

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

ERROR:
ORA-01031: insufficient privileges

Other OS users part of the "dba" group have no problem connecting as sysdba. I dont understand why its only a problem with the user root.

Thanks.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #358107 is a reply to message #358104]

Sat, 08 November 2008 10:45

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Whatever you would like NEVER uses root for sysdba.

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #358110 is a reply to message #358104]

Sat, 08 November 2008 10:53

orcl dba
Messages: 68
Registered: August 2005

Member

It is the application requirement for user root to be part of the dba group

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #358115 is a reply to message #358110]

Sat, 08 November 2008 11:35

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

OK, put it but don't use it.

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #358116 is a reply to message #358115]

Sat, 08 November 2008 11:47

orcl dba
Messages: 68
Registered: August 2005

Member

But I dont understand why I get the error 'ORA-01031: insufficient privileges' from the user root

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #358119 is a reply to message #358116]

Sat, 08 November 2008 12:46

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Metalink note 18089.1

Regards
Michel

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #358136 is a reply to message #358119]

Sun, 09 November 2008 00:40

orcl dba
Messages: 68
Registered: August 2005

Member

The note also says to change the primary group of root to dba if it needs sysdba privileges:
[Edit MC: Metalink note content removed]

But I dont know the implications of making the primary group of user root as "dba"

[Updated on: Sun, 09 November 2008 00:53] by Moderator

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #358137 is a reply to message #358136]

Sun, 09 November 2008 00:54

Michel Cadot
Messages: 68666
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is one of the reasons why I said "don't do it".
I don't see any reason to use root for something it is not made for.
root manages the OS, to manage applications/software there must be other accounts.

Regards
Michel

[Updated on: Sun, 09 November 2008 00:55]

Report message to a moderator

Previous Topic:	query about system global area
Next Topic:	Archive log transfer...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 11:37:21 CDT 2024