ORA-01031: insufficient privileges (326 Views)
Reply
Super Advisor
dictum9
Posts: 1,132
Registered: ‎05-20-2005
Message 1 of 2 (326 Views)

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

Honored Contributor
Patrick Wallek
Posts: 13,777
Registered: ‎06-21-2000
Message 2 of 2 (323 Views)

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"

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.