Re: ORA-01031: insufficient privileges (351 Views)
Reply
Super Advisor
dictum9
Posts: 1,135
Registered: ‎05-20-2005
Message 1 of 2 (354 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,786
Registered: ‎06-21-2000
Message 2 of 2 (351 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.