10 Replies Latest reply on Dec 2, 2018 7:59 AM by Shaik Ahmed Ali Bajubair

    getting error of ORA-01031: insufficient privileges

    user637405

      i have installed 11.2.0.1.0 on oel 5.9 64 bit.

       

       

       

       

       

       

       

       

       

       

       

       

      rman target sys/abcd123@RAC auxiliary sys/abcd123@DRRAC

       

       

      Recovery Manager: Release 11.2.0.1.0 - Production on Sun Nov 18 23:21:28 2018

       

       

      Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

       

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-00554: initialization of internal recovery manager package failed

      RMAN-04005: error from target database:

      ORA-01031: insufficient privileges

       

       

       

       

       

       

       

       

       

       

      ----------------------------------------------------

       

       

      SQL> select * from v$pwfile_users;

       

       

      USERNAME                       SYSDB SYSOP SYSAS

      ------------------------------ ----- ----- -----

      SYS                            TRUE  TRUE  FALSE

       

       

       

       

      -----------------------------------

       

       

      show parameter password;

       

       

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      remote_login_passwordfile            string      EXCLUSIVE

       

       

       

       

      ###################################

       

       

       

       

       

       

       

       

      cat $ORACLE_HOME/rdbms/lib/config.c

       

       

      /*  SS_DBA_GRP defines the UNIX group ID for sqldba adminstrative access.  */

      /*  Refer to the Installation and User's Guide for further information.  */

       

       

      /* IMPORTANT: this file needs to be in sync with

                    rdbms/src/server/osds/config.c, specifically regarding the

                    number of elements in the ss_dba_grp array.

      */

       

       

      #define SS_DBA_GRP "oinstall"

      #define SS_OPER_GRP "oinstall"

      #define SS_ASM_GRP ""

       

       

      char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP, SS_ASM_GRP};

       

       

       

       

       

       

       

       

       

       

       

       

      any solutions are much appreciated.

       

       

      thanks

        • 1. Re: getting error of ORA-01031: insufficient privileges
          Jim-D

          Welcome!  The Getting Started space is intended for discussions about the Oracle Community website, not for product-specific questions.

          There are tips on how to find the correct space on the Getting Started  page, which also has instructions on how to change your display name so you're not just a number.

          In the ACTIONS box on the top right of your post, you should be able to click on "Move", and then specify the correct space - such as Recovery Manager (RMAN) - so the right experts can see your question.

          Thanks and good luck!

          MOSC Move.png

          • 2. Re: getting error of ORA-01031: insufficient privileges
            user637405

            srvctl status database -d RAC

            Instance RAC1 is not running on node ebsnode1

            Instance RAC2 is running on node ebsnode2

            [oracle@ebsnode1 admin]$ srvctl stop database -d RAC

            [oracle@ebsnode1 admin]$ srvctl start database -d RAC

            PRCR-1079 : Failed to start resource ora.rac.db

            ORA-01031: insufficient privileges

            ORA-01034: ORACLE not available

            ORA-27101: shared memory realm does not exist

            Linux-x86_64 Error: 2: No such file or directory

            Process ID: 0

            Session ID: 0 Serial number: 0

             

             

            ORA-01031: insufficient privileges

            ORA-01031: insufficient privileges

            CRS-2674: Start of 'ora.rac.db' on 'ebsnode1' failed

            ORA-01034: ORACLE not available

            ORA-27101: shared memory realm does not exist

            Linux-x86_64 Error: 2: No such file or directory

            Process ID: 0

            Session ID: 0 Serial number: 0

             

             

            ORA-01031: insufficient privileges

            ORA-01031: insufficient privileges

            CRS-2632: There are no more servers to try to place resource 'ora.rac.db' on that would satisfy its placement policy

            • 3. Re: getting error of ORA-01031: insufficient privileges
              Dude!

              Is there any particular reason why you are avoiding to show us the username who is executing the commands? E.g. root vs. oracle?

              • 4. Re: getting error of ORA-01031: insufficient privileges
                user637405

                im executing with oracle user .

                • 5. Re: getting error of ORA-01031: insufficient privileges
                  WadhahDaouehi

                  Hi,

                   

                  I guess should be like that dba and not oinstall:

                  #define SS_DBA_GRP "dba"

                  #define SS_OPER_GRP "dba"

                  #define SS_ASM_GRP ""

                   

                  is the user oracle also the owner of the grid infrastructure?

                   

                  Best regards

                  • 6. Re: getting error of ORA-01031: insufficient privileges
                    user637405

                    yes oracle is owner of grid infrastructure .

                     

                     

                    i gave oracle:oinstall permissions every where.

                    • 7. Re: getting error of ORA-01031: insufficient privileges
                      Dude!

                      It's not possible to guess where:

                       

                      rman target sys/abcd123@RAC auxiliary sys/abcd123@DRRAC

                       

                      is connecting too. I suggest to try sqlplus and connect to each instance as sysdba. e.g.

                       

                      sqlplus "sys/abcd123@RAC as sysdba"

                       

                      Does this work?

                      • 8. Re: getting error of ORA-01031: insufficient privileges
                        user637405

                        sqlplus "sys/abcd123@RAC as sysdba"

                         

                        this is also giving

                         

                        ORA-01031: insufficient privileges

                        • 9. Re: getting error of ORA-01031: insufficient privileges
                          Dude!

                          I suggest to check were @RAC and @DRRAC point to according to your tnsnames.ora. You can also try the command tnsping RAC and tnsping DRRAC to see what machines you are using.

                           

                          Are you using the TWO_TASK environment variable?

                          • 10. Re: getting error of ORA-01031: insufficient privileges
                            user637405

                            from primary i did tnsping standby service :

                             

                             

                            [oracle@ebsnode2 ~]$ tnsping DRRAC

                             

                             

                            TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 23-NOV-2018 22:17:46

                             

                             

                            Copyright (c) 1997, 2009, Oracle.  All rights reserved.

                             

                             

                            Used parameter files:

                             

                             

                             

                             

                            Used TNSNAMES adapter to resolve the alias

                            Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.101)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DRRAC)))

                            OK (10 msec)

                             

                             

                             

                             

                             

                             

                             

                             

                            while from standby i did tnsping primary tns service :

                             

                             

                            [oracle@drnode1 ~]$ tnsping RAC

                             

                             

                            TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 23-NOV-2018 22:18:20

                             

                             

                            Copyright (c) 1997, 2009, Oracle.  All rights reserved.

                             

                             

                            Used parameter files:

                             

                             

                             

                             

                            Used TNSNAMES adapter to resolve the alias

                            Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.111)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = RAC)))

                            OK (60 msec)

                             

                             

                             

                             

                             

                             

                             

                             

                             

                             

                             

                             

                            [oracle@ebsnode2 ~]$ echo $TWO_TASK

                             

                             

                            [oracle@ebsnode2 ~]$ cat /home/oracle/db_env

                             

                             

                            ORACLE_SID=RAC2; export ORACLE_SID

                            ORACLE_HOME=$DB_HOME; export ORACLE_HOME

                            PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH

                             

                             

                            LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

                            CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

                             

                             

                            ###############################

                             

                             

                            [oracle@ebsnode2 ~]$ cat /home/oracle/grid_env

                             

                             

                            ORACLE_SID=+ASM2; export ORACLE_SID

                            ORACLE_HOME=$GRID_HOME; export ORACLE_HOME

                            PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH

                             

                             

                            LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

                            CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

                             

                             

                            ################################

                             

                             

                             

                             

                            [oracle@ebsnode2 ~]$ cat /home/oracle/.bash_profile

                            # .bash_profile

                             

                            # Get the aliases and functions

                            if [ -f ~/.bashrc ]; then

                                    . ~/.bashrc

                            fi

                             

                             

                            # User specific environment and startup programs

                             

                             

                            #PATH=$PATH:$HOME/bin

                            #export PATH

                             

                             

                            TMP=/tmp; export TMP

                            TMPDIR=$TMP; export TMPDIR

                             

                             

                            ORACLE_HOSTNAME=ebsnode2.oracledba.org; export ORACLE_HOSTNAME

                            #ORACLE_UNQNAME=RAC; export ORACLE_UNQNAME

                            DB_UNIQUE_NAME=RAC;export DB_UNIQUE_NAME

                            ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

                            GRID_HOME=/u01/app/11.2.0.3/grid; export GRID_HOME

                            DB_HOME=$ORACLE_BASE/product/11.2.0.3/db_1; export DB_HOME

                            ORACLE_HOME=$DB_HOME; export ORACLE_HOME

                            ORACLE_SID=RAC2; export ORACLE_SID

                            ORACLE_TERM=xterm; export ORACLE_TERM

                            BASE_PATH=/usr/sbin:$PATH; export BASE_PATH

                            PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH

                             

                             

                            LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH

                            CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

                             

                             

                            alias grid_env='. /home/oracle/grid_env'

                            alias db_env='. /home/oracle/db_env'

                            • 11. Re: getting error of ORA-01031: insufficient privileges
                              user637405

                              [oracle@ebsnode1 dbs]$ ls

                              hc_RAC1.dat  init.ora  initRAC1.ora  orapwRAC1  snapcf_RAC1.f

                              [oracle@ebsnode1 dbs]$ mv orapwRAC1 orapwRAC1.old

                              [oracle@ebsnode1 dbs]$ orapwd file=orapwRAC1 password=abcd123 ignorecase=y

                              [oracle@ebsnode1 dbs]$ ls

                              hc_RAC1.dat  init.ora  initRAC1.ora  orapwRAC1  orapwRAC1.old  snapcf_RAC1.f

                               

                               

                               

                               

                              [oracle@ebsnode1 dbs]$ ssh ebsnode2

                              Last login: Fri Nov 23 21:57:45 2018 from ebsnode1.oracledba.org

                              [oracle@ebsnode2 ~]$

                              [oracle@ebsnode2 ~]$

                              [oracle@ebsnode2 ~]$

                              [oracle@ebsnode2 ~]$ cd $ORACLE_HOME/dbs

                              [oracle@ebsnode2 dbs]$ ls

                              hc_RAC2.dat  init.ora  initRAC2.ora  orapwRAC2

                              [oracle@ebsnode2 dbs]$ mv orapwRAC2 orapwRAC2.old

                              [oracle@ebsnode2 dbs]$ orapwd file=orapwRAC2 password=abcd123 ignorecase=y

                              [oracle@ebsnode2 dbs]$ ls

                              hc_RAC2.dat  init.ora  initRAC2.ora  orapwRAC2  orapwRAC2.old

                               

                               

                              #####################################

                               

                               

                               

                               

                              after that when i conect again error :

                               

                               

                              [oracle@ebsnode1 dbs]$ sqlplus sys@RAC as sysdba

                               

                              SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 23 23:02:21 2018

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

                               

                               

                              Enter password:

                              ERROR:

                              ORA-01031: insufficient privileges

                              • 12. Re: getting error of ORA-01031: insufficient privileges
                                Shaik Ahmed Ali Bajubair

                                did you copy password file from target??

                                if not copy the password file from target into your machine in dbs location, then try .