ORA-01031: insufficient privileges (503 Views)
Reply
Highlighted
Super Advisor
Posts: 1,162
Registered: ‎05-20-2005
Message 1 of 2 (503 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
Posts: 13,910
Registered: ‎06-21-2000
Message 2 of 2 (500 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.