Symptoms

NetWorker is configured to perform Oracle Backups using database authentication, and backups fail with the following error message. ORA-01017: invalid username/password; logon denied

Cause

NetWorker Module for Database and Applications (NMDA) integrate with Oracle RMAN to perform backups of the Oracle database. NMDA can connect to the Oracle using Oracle OS authentication, or Oracle database authentication.During the configuration of the NetWorker client resource using the NetWorker Management Console (NMC) client wizard, the following error could occur while specifying Oracle database authentication. ORA-01017: invalid username/password; logon denied This error can occur for several reasons, including:- Incorrect username or password specified- Oracle user specified is locked at the database.- Oracle user password has expired.- Oracle user specified does not have sysdba, or sysbackup privileges.

Resolution

Ensure that a connection using the RMAN command-line interface can be successfully performed using Oracle database authentication, with the same credentials specified in NMC. oracle@nmda19-2 RMAN]$ rman target sys@orcl Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 23 23:18:56 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. target database Password: connected to target database: ORCL (DBID=1554615331) RMAN> If RMAN command line authentication is unsuccessful, engage the Oracle/DBA team to address the underlying database issue before continuing.

Support Cases