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

getting error of ORA-01031: insufficient privileges

user637405 Nov 21, 2018 8:46 PM

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

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 Nov 21, 2018 9:22 PM (in response to user637405)

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!
Like Show 0 Likes(0)

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

user637405 Nov 21, 2018 9:47 PM (in response to 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
Like Show 0 Likes(0)

Actions
3. Re: getting error of ORA-01031: insufficient privileges

Dude! Nov 22, 2018 2:19 AM (in response to user637405)

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

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

user637405 Nov 22, 2018 11:08 AM (in response to Dude!)

im executing with oracle user .
Like Show 0 Likes(0)

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

WadhahDaouehi Nov 22, 2018 11:45 AM (in response to user637405)

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
Like Show 0 Likes(0)

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

user637405 Nov 23, 2018 11:11 AM (in response to WadhahDaouehi)

yes oracle is owner of grid infrastructure .

i gave oracle:oinstall permissions every where.
Like Show 0 Likes(0)

Actions
7. Re: getting error of ORA-01031: insufficient privileges

Dude! Nov 23, 2018 2:30 PM (in response to user637405)

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?
Like Show 0 Likes(0)

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

user637405 Nov 23, 2018 4:49 PM (in response to Dude!)

sqlplus "sys/abcd123@RAC as sysdba"

this is also giving

ORA-01031: insufficient privileges
Like Show 0 Likes(0)

Actions
9. Re: getting error of ORA-01031: insufficient privileges

Dude! Nov 23, 2018 10:04 PM (in response to user637405)

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?
Like Show 0 Likes(0)

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

user637405 Nov 23, 2018 10:30 PM (in response to 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'
Like Show 0 Likes(0)

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

user637405 Nov 23, 2018 11:08 PM (in response to 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
Like Show 0 Likes(0)

Actions
12. Re: getting error of ORA-01031: insufficient privileges

Shaik Ahmed Ali Bajubair Dec 2, 2018 7:59 AM (in response to user637405)

did you copy password file from target??
if not copy the password file from target into your machine in dbs location, then try .
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.