-
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!
-
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
-
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?
-
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 .
-
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
-
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.
-
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?
-
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
-
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?
-
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'
-
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
-
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 .