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

Home » RDBMS Server » Server Administration » ORA-01031: insufficient privileges (Oracle 10g on solaris 10)

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

ORA-01031: insufficient privileges [message #312420]

Tue, 08 April 2008 19:03

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?

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #312421 is a reply to message #312420]

Tue, 08 April 2008 19:07

ebrian
Messages: 2794
Registered: April 2006

Senior Member

What is sqlnet.authentication_services set to in your sqlnet.ora file?

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #312422 is a reply to message #312421]

Tue, 08 April 2008 19:10

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.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #312430 is a reply to message #312422]

Tue, 08 April 2008 19:52

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

BlackSwan
Messages: 26766
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

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?

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #312716 is a reply to message #312420]

Wed, 09 April 2008 11:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please post results from command below:

more /etc/group | grep oinstall

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #312717 is a reply to message #312716]

Wed, 09 April 2008 11:45

harshnayak
Messages: 12
Registered: July 2007
Location: Los Angeles

Junior Member

->more /etc/group | grep oinstall
oinstall::102:bvadm,oracle

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #312720 is a reply to message #312420]

Wed, 09 April 2008 11:50

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #313085 is a reply to message #312720]

Thu, 10 April 2008 11:29

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?

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #313409 is a reply to message #313085]

Fri, 11 April 2008 15:14

harshnayak
Messages: 12
Registered: July 2007
Location: Los Angeles

Junior Member

I resolved the issue using the following document on metalink.

Doc: 67984.1

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #313410 is a reply to message #312420]

Fri, 11 April 2008 15:15

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

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #313419 is a reply to message #313410]

Fri, 11 April 2008 19:04

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.

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #466646 is a reply to message #313419]

Tue, 20 July 2010 07:25

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

Report message to a moderator

Re: ORA-01031: insufficient privileges [message #466657 is a reply to message #466646]

Tue, 20 July 2010 07:51

babuknb
Messages: 1736
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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Apologies on this and Thanks

Report message to a moderator

Previous Topic:	Issues with CLOB datatype in Orcle 10g
Next Topic:	Inrease SGA Parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 08:44:37 CST 2024