Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01031: insufficient privileges

Highlighted
dictum9
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 REPLY
Patrick Wallek
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"