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

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

Cet article concerne Cet article ne concerne pas Cet article n’est associé à aucun produit spécifique. Toutes les versions du produit ne sont pas identifiées dans cet article.

Symptômes

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.

 

Résolution

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

 

Propriétés de l’article
Numéro d’article: 000202697
Type d’article: Solution
Dernière modification: 11 juin 2024
Version:  7
Trouvez des réponses à vos questions auprès d’autres utilisateurs Dell
Services de support
Vérifiez si votre appareil est couvert par les services de support.