3 Replies Latest reply: Nov 15, 2011 1:27 AM by user2966648 RSS

    ORA-01031: insufficient privileges

    877182
      Hello

      I am working in RAC 11g R1 environment as a trainee. I have Oracle, Asm and Crs users.

      when I do,
      node1>> su - asm
      password: ******

      asm_node1>>echo $ORACLE_SID=+asm1
      asm_node1>>sqlplus / as sysdba

      ERROR:
      ORA-01031: insufficient privileges

      I would like to know why this is hapenning.
        • 1. Re: ORA-01031: insufficient privileges
          877175
          Hello.


          Verify the user account privileges to directory of ORACLE_HOME.

          [root@producao ~]# cd $ORACLE_HOME
          [root@producao ~]# ls -lrt |grep bin
          drwxr-xr-x 2 oracle dba 12288 Jan 18 2011 bin


          after veryfied if your owner is this group

          [root@producao ~]# su - asm
          password: ******

          [root@producao ~]# id

          you have to be part of the group that owns the oracle

          if you dont owner this directory, you can to add your user to group.


          [root@producao ~]# id asm
          uid=1100(grid) gid=1000(oinstall) grupos=1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper)

          you need to add your username in the user group asm oracle owner.


          [root@producao ~]# cat /etc/group |grep dba:
          dba:x:101:
          asmdba:x:1201:grid


          Change this line "dba:x:101:" to "dba:x:101:grid"

          [root@producao ~]# id asm
          uid=1100(grid) gid=1000(oinstall) grupos=1000(oinstall),101(dba),1200(asmadmin),1201(asmdba),1202(asmoper)


          And try again.


          Remenber, you need to log in again on the user to work.


          example:

          [grid@producao ~]$ sqlplus

          SQL*Plus: Release 11.2.0.2.0 Production on Thu Jul 21 16:41:49 2011

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

          Enter user-name: / as sysdba
          ERROR:
          ORA-01031: insufficient privileges


          [grid@producao ~]$ exit
          [root@producao ~]# cat /etc/group |grep dba:
          dba:x:101:
          asmdba:x:1201:grid

          [root@producao ~]# vi /etc/group
          [root@producao ~]# su - grid
          [grid@producao ~]$ id
          uid=1100(grid) gid=1000(oinstall) grupos=101(dba),1000(oinstall),1200(asmadmin),1201(asmdba),1202(asmoper)

          [grid@producao ~]$ cat /etc/group |grep dba:
          dba:x:101:grid
          asmdba:x:1201:grid

          [grid@producao ~]$ sqlplus

          SQL*Plus: Release 11.2.0.2.0 Production on Thu Jul 21 16:43:29 2011

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

          Enter user-name: / as sysdba
          Connected to an idle instance.

          SQL>

          Edited by: user1107977 on 21/07/2011 12:44
          • 2. Re: ORA-01031: insufficient privileges
            877182
            Thank you that was helpful...
            • 3. Re: ORA-01031: insufficient privileges
              user2966648
              Use ..
              Set ORACLE_HOME ORACLE_SID
              And

              sqlplus "/ as sysasm"
              shutdown

              Ajay..