NetWorker: NMDA Oracle backups: Authentication is denied (11g DBs).

Summary: NMDA Oracle backups do not correctly run pre-command scripts against Oracle 11g databases.

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

Oracle backup fails with error:

Thu Oct 17 14:57:37 2024
Thu Oct 17 14:57:37 2024
Executing command: /usr/bin/nsr_pre_testSIST.sh
Set the signal's handler.
Cannot su to "oracle" : Authentication is denied.
Cannot su to "oracle" : Authentication is denied.
The command executed successfully: /usr/bin/nsr_pre_testSIST.sh
Reset the signal's handler.
Pre-processing command succeeded.

Cause

During NMDA Oracle backups, nsrdasv uses Oracle's APIs to connect with DB for OS auth.
During this process, nsrdasv connects as the oracle user specified, using SYSBACKUP, followed by SYSDBA (if the first does not succeed).
When nsrdasv completes connecting to the database it reverts back to UID 0 (root), and runs the pre-command script. 

The issue is with Oracle DB 11g which does not have a SYSBACKUP role; nsrdasv does not revert the uid/gid to 'root' after unsuccessful SYSBACKUP attempt.
This causes nsrdasv to save the incorrect OS uid/gid (oracle's) while attempting the SYSDBA role; when reverting the uid it reverts to the incorrect uid/gid.

Resolution

Code fix for this issue is in the 19.12, 19.10.0.7, and 19.11.0.3 releases.

Affected Products

NetWorker Module for Databases and Applications

Products

NetWorker Family, NetWorker Module
Article Properties
Article Number: 000312013
Article Type: Solution
Last Modified: 07 Aug 2025
Version:  1
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.