ORA-01031: insufficient privileges (520 Views)
Super Advisor
Posts: 1,166
Registered: ‎05-20-2005
Message 1 of 2 (520 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


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


Honored Contributor
Posts: 13,924
Registered: ‎06-21-2000
Message 2 of 2 (517 Views)

Re: ORA-01031: insufficient privileges

Have a look here:



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.