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)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.