Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges (Oracle 10g on solaris 10)
ORA-01031: insufficient privileges [message #312420] Tue, 08 April 2008 19:03 Go to next message
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 #312421 is a reply to message #312420] Tue, 08 April 2008 19:07 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
What is sqlnet.authentication_services set to in your sqlnet.ora file?
Re: ORA-01031: insufficient privileges [message #312422 is a reply to message #312421] Tue, 08 April 2008 19:10 Go to previous messageGo to next message
harshnayak
Messages: 12
Registered: July 2007
Location: Los Angeles
Junior Member
I don't have sqlnet.ora file set up in my $TNS_ADMIN directory.
Re: ORA-01031: insufficient privileges [message #312430 is a reply to message #312422] Tue, 08 April 2008 19:52 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Still want to check in $ORACLE_HOME/network/admin directory for a sqlnet.ora file.

What do the following show from a command prompt:

id
more /etc/group | grep dba

[Updated on: Tue, 08 April 2008 19:59]

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #312434 is a reply to message #312420] Tue, 08 April 2008 20:04 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
I solved this very problem yesterday & yes the solution involved /etc/group

What is return after issuing the following OS command?

id

[Updated on: Tue, 08 April 2008 20:05] by Moderator

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #312677 is a reply to message #312434] Wed, 09 April 2008 10:40 Go to previous messageGo to next message
harshnayak
Messages: 12
Registered: July 2007
Location: Los Angeles
Junior Member
->id returns the following
uid=101(oracle) gid=102(oinstall)

->more /etc/group | grep dba
dba::300:oracle

How did you solve it?
Re: ORA-01031: insufficient privileges [message #312716 is a reply to message #312420] Wed, 09 April 2008 11:43 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Please post results from command below:

more /etc/group | grep oinstall
Re: ORA-01031: insufficient privileges [message #312717 is a reply to message #312716] Wed, 09 April 2008 11:45 Go to previous messageGo to next message
harshnayak
Messages: 12
Registered: July 2007
Location: Los Angeles
Junior Member
->more /etc/group | grep oinstall
oinstall::102:bvadm,oracle
Re: ORA-01031: insufficient privileges [message #312720 is a reply to message #312420] Wed, 09 April 2008 11:50 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
make sure
remote_login_passwordfile=EXCLUSIVE
is current value for this DB

try
oinstall::102:

If still no success run
orapwd
utility & the bounce DB
Re: ORA-01031: insufficient privileges [message #313085 is a reply to message #312720] Thu, 10 April 2008 11:29 Go to previous messageGo to next message
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 #313409 is a reply to message #313085] Fri, 11 April 2008 15:14 Go to previous messageGo to next message
harshnayak
Messages: 12
Registered: July 2007
Location: Los Angeles
Junior Member
I resolved the issue using the following document on metalink.

Doc: 67984.1
Re: ORA-01031: insufficient privileges [message #313410 is a reply to message #312420] Fri, 11 April 2008 15:15 Go to previous messageGo to next message
harshnayak
Messages: 12
Registered: July 2007
Location: Los Angeles
Junior Member
need to unset TWO_TASK variable in order to let the command work properly
Re: ORA-01031: insufficient privileges [message #313419 is a reply to message #313410] Fri, 11 April 2008 19:04 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Don't know of many shops that have TWO_TASK set in their environment. I typically will use it if needed in scripts.

Kinda confused though how Note 67984.1 indicated TWO_TASK.
Re: ORA-01031: insufficient privileges [message #466646 is a reply to message #313419] Tue, 20 July 2010 07:25 Go to previous messageGo to next message
skumar22k
Messages: 1
Registered: November 2009
Location: Madurai
Junior Member

Hi anybody can give solution for my problem.
My OS is OEL 4
Oracle 10g
My problem:
when i am try to connect database
>conn sys/sys@<service_id> as sysdba
error ORA-01031
at same time I can able to connect system user
>conn system/sys@<serice_id>
now I can access the database. But I can't connect as sys user.

init<sid>.ora
remote_login_passwordfile=Exclusive
Re: ORA-01031: insufficient privileges [message #466657 is a reply to message #466646] Tue, 20 July 2010 07:51 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

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 messageGo to next message
Michel Cadot
Messages: 64103
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

Re: ORA-01031: insufficient privileges [message #466783 is a reply to message #466659] Wed, 21 July 2010 02:46 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Apologies on this and Thanks
Previous Topic: Issues with CLOB datatype in Orcle 10g
Next Topic: Inrease SGA Parameter
Goto Forum:
  


Current Time: Sat Dec 03 22:00:10 CST 2016

Total time taken to generate the page: 0.08784 seconds