ORA-01031: insufficient privileges [message #312420] |
Tue, 08 April 2008 19:03 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
harshnayak
Messages: 12 Registered: July 2007 Location: Los Angeles
|
Junior Member |
|
|
I am trying to run the following command as oracle user
connect / as sysdba
and it gives me following error
ORA-01031: insufficient privileges
can anyone tell me how can i get rid of this?
|
|
|
|
|
|
|
|
|
|
|
Re: ORA-01031: insufficient privileges [message #313085 is a reply to message #312720] |
Thu, 10 April 2008 11:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
harshnayak
Messages: 12 Registered: July 2007 Location: Los Angeles
|
Junior Member |
|
|
yes, remote_login_passwordfile is set to EXCLUSIVE value
initially the dba group was not present. so i created the "dba" group and modified the oracle user to change the primary group to dba. so now, the user's primary group is "dba".
so if I am using operating system authentication and log in as oracle user, then shouldn't it pass the control to the OS to verify the identity and "connect / as sysdba" should work?
|
|
|
|
|
|
|
Re: ORA-01031: insufficient privileges [message #466657 is a reply to message #466646] |
Tue, 20 July 2010 07:51 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
babuknb
Messages: 1736 Registered: December 2005 Location: NJ
|
Senior Member |
![babu.knb@gmail.com](/forum/theme/orafaq/images/google.png) ![babudba](/forum/theme/orafaq/images/skype.png)
|
|
Welcome to Orafaq !!!
Quote:ORA-01031: insufficient privileges
Cause: An attempt was made to change the current username or password without the appropriate privilege.
This error also occurs if attempting to install a database without the necessary operating system privileges.
When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the current login.
Action: Ask the database administrator to perform the operation or grant the required privileges.
For Trusted Oracle users getting this error although granted the the appropriate privilege at a higher label,
ask the database administrator to regrant the privilege at the appropriate label
Further please create new thread & don't response existing (old) thread
Babu
[Updated on: Tue, 20 July 2010 07:51] by Moderator Report message to a moderator
|
|
|
Re: ORA-01031: insufficient privileges [message #466659 is a reply to message #466657] |
Tue, 20 July 2010 07:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Further please create new thread & don't response existing (old) thread
Why? It is closelyy related to the question posted in the current topic and so it is valid to keep on it rather than creating a new topic.
And please keep your line in 80 character width if you use code tags, otherwise use quote ones.
Regards
Michel
[Updated on: Tue, 20 July 2010 07:54] Report message to a moderator
|
|
|
|