Welcome to Dell Technologies.
How to NetWorker Module for Databases and Applications.
NetWorker Oracle Backups fail with ORA-01017:
invalid username/password; logon denied.
In reference to Dell Knowledge Article number 196697.
This video was created to assist IT professionals responsible for
administrating NetWorker datazones,
to troubleshoot the Oracle RMAN error
ORA-01017: invalid username/password; logon denied errors
during NetWorker operations.
Before you begin:
Ensure that you have a terminal connection
to the Oracle server generating the error
and you are logged in as the Oracle OS user.
Have the Oracle database username, password,
and instance name credentials available.
During NetWorker Module for Database and Application operations,
such as backup, restore, or config,
it is possible to get the Oracle error code
ORA-01017: invalid username/password; logon denied.
We will illustrate this error while creating an Oracle client resource
using the NetWorker Management Console Wizard.
Here we are selecting to connect to the Oracle database
we wish to configure for backups
using the Oracle database authentication method.
After specifying the username, password, and Service name information,
we receive the error ORA-01017: invalid username/password; logon denied.
A good strategy in troubleshooting this error is to ensure
that a similar connection attempt
from the RMAN command line interface can succeed.
Open a remote terminal to the Oracle server and log in to the system
as the operating user which owns the Oracle installation.
Launch the RMAN executable and specify the same Oracle username
and target database as previously used
during the NetWorker Configuration Wizard.
Be sure to specify the Oracle instance name in the connect string
to ensure that database authentication is used for the connection type.
Type in the password for the specified Oracle user.
Here we see that while using RMAN command line interface
Oracle fails to connect with a similar error
as we've previously seen in the NetWorker Wizard.
In this example, the cause of the failure to connect
stems from an invalid password being used.
There could be other Oracle-specific causes for this error,
such as account being locked
or insufficient privileges granted to the specified user,
such as the SYSDBA or SYSBACKUP roles.
In this example, the cause of the failure to connect
stems from an invalid password being specified.
After providing the correct password,
the RMAN command line is now able to connect
and by making the same password change in NMC,
the connection also now works from NetWorker.
After successfully connecting to the Oracle database
using the illustrated method from the RMAN command line,
NetWorker backup, restore, and config operations should be able to proceed.
If you are continuing to receive
the ORA-01017: invalid username/password; logon denied
while using the RMAN command line,
consult with your local DBA for further assistance.
Thank you for watching.