Checking user RMAN privileges getting ora-01031 insufficient privileges

Configured the window user for RMAN on Window platform. We created an Oracle User for RMAN backup in Oracle Database. We scheduled the script but it will generate the following errors:

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ora-01031 insufficient privileges

Solution:

  1. Provide the sysdba privilege to the Oracle User. ( we are using Oracle 10g thats why we provide SYSDBA but from Oracle 12c we can use SYSBACKUP as privilege.
---Provide sysdba to user
Grant sysdba to username;

--Provide sysbackup to user
Grant sysbackup to username;

2. If first step will not fixed the issue, then our Operating system user from which we are running the RMAN commands/Scripts have member of group: ORA_DBA(windows) or OSBACKUPDBA( unix or linux)

Unix/Linux at /etc/passwd|grep -i dba

Windows as: Check User is member of following ORA_DBA group:

3. Check the SQLNET.ora file for following parameter is set to NTS value.

SQLNET.AUTHENTICATION_SERVICES = (NTS)

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply