Windows Oracle backup fails with "ORA-01031: Insufficient privileges" when a user has only a SYSBACKUP role.

Summary: Avamar: Windows Oracle backup fails with "ORA-01031: Insufficient privileges" when only SYSBACKUP privilege is granted to a user.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

Windows Oracle backup fails with the error "ORA-01031: Insufficient privileges" when only SYSBACKUP privilege is granted to a user.

 

The avoracle log indicates that the user test is used to connect to a database:

++++++++++++++++++++++++++++++++++++
avoracle Info : RMAN is connecting to the Oracle DB as the DB user 'test'
avoracle Info : RMAN=c:\work\windows.x64_193000_db_home\bin/rman
avoracle Info : RMAN=c:\work\windows.x64_193000_db_home\bin/rman
avoracle Error : Snapup of ORCL aborted due to rman terminated abnormally - check the logs
++++++++++++++++++++++++++++++++++++

Recovery Manager (RMAN) log indicates that the user does not have sufficient privileges and is not able to establish the connection:

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

Recovery Manager complete.
++++++++++++++++++++++++++++++++++++

 

Cause

This occurs due to a software glitch in the Avamar Windows avoracle plug-in.

 

Resolution

Upgrade the Avamar Server to version 19.8.100-83 or later. The fix is incorporated in Avamar 19.8 and later software releases.

 

Article Properties
Article Number: 000202697
Article Type: Solution
Last Modified: 11 Jun 2024
Version:  7
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.