Question:
I am getting the ORA-01031
error in 11g r2 when trying to connect to RMAN:
RMAN> connect target rmanuser/rmanuser@stdby
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-01031: insufficient privileges
How do I fix this RMAN ORA-01031 error?
Answer:
Yu need a user with the SYSDBA privilege to avoid the ORA-01031 error.
Your user does not have the proper RMAN privileges (SYSDBA privilege):
To find a list of user who have SYSDBA privilege, issue this SQL:
select *
from
v$pwfile_users;
Starting in Oracle 11g, all RMAN sessions must be configured for remote
login or you will get the ORA-01031: insufficient privileges error.
To connect to the target database using RMAN as SYSDBA, you must do one of
the following procedures:
Here are the steps to prevent the ORA-01031 error when connecting as sysdba
in 11g:
1 - Create the password file.
This is done by executing the following command:
$ orapwd file=filename password=password entries=max_users
The max_users is the number of database users that can be granted
SYSDBA or SYSOPER. This parameter should be set to a higher value than
the number of anticipated users to prevent having to delete and recreate the
password file.
2 - Edit the init.ora parameter remote_login_passwordfile.
This parameter must be set to either SHARED or EXCLUSIVE.
When set to SHARED, the password file can be used by multiple
databases, yet only the SYS user is recognized. When set to EXCLUSIVE,
the file can be used by only one database, yet multiple users can exist in
the file.
SQL> show parameter password
NAME
TYPE VALUE
----------------------------- ----------- ----------remote_login_passwordfile string
EXCLUSIVE
3 - Grant SYSDBA or SYSOPER to users.
When SYSDBA or SYSOPER privileges are granted to a user, that user's name
and privilege information are added to the password file.
SQL> grant sysdba to scott;
Grant succeeded.
