Question: I am trying to invoke RMAN and I'm
getting the message "error: insufficient privileges".
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges
How to I get sufficient privileges to stop the ORA-01031 error and run
the RMAN utility?
Answer: See these notes on the
ORA-01031 insufficient privileges error This "insufficient privileges" RMAN error
is not uncommon because most RMAN user ID's have the DBA role,
which grants all privileges need to execute RMAN. You should make
sure to grant the Oracle ID with the proper privileges:
grant dba to rmanuser;First, check that
your OS user is part of the DBA group (thereby granting SYSDBA
privileges). For the DBA, the ORA-01031 can happen if the target
OS executables do not have read and execute permissions (e.g. (770) in
UNIX/Linux), and ensure that the oracle user is a member of the dba
group (e.g. /etc/group). There are similar permission in the Windows
registry.
cat /etc/passwd|grep -i dba
Next, create a password file using orapwd command and
enable the remote_login_passwordfile parameter.
$ orapwd file=$ORACLE_HOME/dbs/orapwTESTDB
password=xxxxx
SQL> alter system set
REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE scope=spfile;
Next, check you have the following line (not commented) in
your sqlnet.ora file.
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Next, check if TNS_ADMIN environment variable is set properly.
This should stop the ORA-01031 error with RMAN.
