15 Haziran 2012 Cuma

sqlplus ORA-01031: insufficient privileges


You want to connect intance to start.(oracle 11g)

but there is an error.

like


[oracle@oratest01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue Jun 23 02:00:05 2009

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

ERROR:
ORA-01031: insufficient privileges


1-Check groups in linux.(if dba group doesn't exist firstly create it)

more /etc/group
.
....

oinstall:x:500:
dba:x:501:oracle


2-Check your oracle user groups

more /etc/passwd
.
....
oracle:x:500:500::/home/oracle:/bin/bash



[root@oratest01 ~]# id oracle
uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)




2 yorum:

  1. HEllo;
    I entered "oracle:x:500:500::/home/oracle:/bin/bash" to my passwd fine but when tyuid=500(oracle) gid=500 groups=500
    pe id oracle it says;

    YanıtlaSil
  2. Hi,
    Check your /etc/group file
    I must contain "dba:x:500:oracle" values

    and check your id command output
    # id oracle

    YanıtlaSil