ORA-01031: insufficient privileges

From: Branimir Petrovic <BranimirP_at_cpas.com>
Date: Fri, 13 Feb 2009 14:50:50 -0500
Message-ID: <3BD1FF9AC8239B4DA50B8FB4A749C200839207_at_vs-exchange1.cpas.com>

Please help me see what am I doing wrong or missing.

My system is (freshly installed):
 OS: OEL 5.2 64 bit
 Oracle: 10.2.0.3 64 bit

dba' group is primary group for user 'oracle' (created via 'oracle validated' rpm):
  ~]# cat /etc/passwd | grep oracle
  oracle:x:500:500::/home/oracle:/bin/bash

[root_at_s-ora-004 ~]# cat /etc/group | grep dba dba:x:500:

sqlnet.ora has:
  SQLNET.AUTHENTICATION_SERVICES= (NTS) When I try to log on as 'oracle' (after sourcing environment and SID):   ~]$ sqlplus '/ as sysdba'

I get:
  ERROR:
  ORA-01031: insufficient privileges

but providing user name and password:
  Enter user-name: sys as sysdba
  Enter password:

does get me there:
  Connected to:
  Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

Looks like without ability successfully log on with '/ as sysdba' dbshut and dbstart scripts will not stop or start database services (TNS listener starts but not the database). What should I be looking at to restore '/ as sysdba' login capability?

Thanks,  

Branimir

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 13 2009 - 13:50:50 CST