Databases
Showing results for 
Search instead for 
Do you mean 

ORA-01031: insufficient privileges

Highlighted
Super Advisor

ORA-01031: insufficient privileges

11.31 hpux. Trying to connect to the database as sysdba, getting this authentication error. (ORA-01031: insufficient privileges) Below are all the relevant files and environmental variables. It looks like I have all the permissions yet obviously something is going wrong.  The permissions look OK in $ORACLE_HOME.

 

sqlplus "/ as sysdba"

 

 

# oracle is in both groups, sidpers and dba.

 

(#/home/oracle-> grep oracle /etc/passwd /etc/group
/etc/passwd:oracle:xxxxxxxxx:980:106:,,,:/home/oracle:/usr/bin/sh
/etc/group:sidpers::105:oracle
/etc/group:dba::106:oracle

 

(#/home/oracle)-> echo $ORACLE_SID; echo $ORACLE_HOME
ldev3

/oracle/app/product/11.2.0

1 REPLIES
Honored Contributor Honored Contributor

Re: ORA-01031: insufficient privileges

Have a look here:

http://oradbastuff.blogspot.com/2011/03/ora-01031-insufficient-privilege-while.html

 

Particularly item # 2 under the "Facts About Operating System Authentication"