Oracle database backup fails with the error: 0xe000fe29 - Authentication failed on connection to the server. Make sure that the user account has the appropriate permissions and that the password was typed correctly

book

Article ID: 100053919

calendar_today

Updated On:

Description

Error Message

0xe000fe29 - Authentication failed on connection to the server. Make sure that the user account has the appropriate permissions and that the password was typed correctly.
Final error category: Security Errors
For additional information regarding this error refer to link V-79-57344-65065


SGMON Debug report from the BE Server:

BENGINE:  [08/31/22 17:15:01] [9668]     [ndmp]               | ndmpcGetUsernamePassword() returning SUCCESS username 'sys' parentUsername 'domain name\Administrator'
BENGINE:  [08/31/22 17:15:04] [9668]     [ndmp\ndmpcomm]      - ERROR: 69 Error: Windows LogonUser API failed.
BENGINE:  [08/31/22 17:15:04] [9668]     [ndmp]               + ndmp_client_connect.cpp (219):
BENGINE:  [08/31/22 17:15:04] [9668]     [ndmp]               | connectClientAuth: auth_type=190; auth_id='sys'; auth_password=''
BENGINE:  [08/31/22 17:15:09] [9668]     [ndmp\ndmpcomm]      - ERROR: 69 Error: Windows LogonUser API failed.
BENGINE:  [08/31/22 17:15:09] [9668]     [ndmp\ndmpclient]    - *** getLastNDMPError Calling to get last NDMP Error.
BENGINE:  [08/31/22 17:15:09] [9668]     [ndmp\ndmpcomm]      - ERROR: 4 Error: Connection has not been authorized

 

Cause

This error can have different root causes:

1. Logon Account password used for connecting to the Oracle database in the Remote Agent Utility has not been updated.

2. System Logon Account (SLA) password for the Backup Exec server is not up to date.

3. The Windows Logon Account used for connecting to the Oracle database is not a part of the ORA_DBA group.

4. The Logon Accounts are not configured in the same format

 

Resolution


SOLUTION 1:

For Windows Servers Database Access Configuration:

1. Navigate to Start-> Veritas Backup Exec-> Backup Exec Agent Utility.

2. Select Database Access tab in the Remote Agent Utility, select Change password for the Windows Logon Account used and update the password.

3. Update the same password for the Windows Logon Account in the Backup Exec Logon Accounts Wizard.

 

For LINUX Servers Database Access Configuration:

1. Login as root and run AgentConfig from command prompt   /opt/VRTSralus/bin/AgentConfig

2. Type 1 to Configure database access

3. Type 1 to Add system credentials for Oracle operations

4. Enter oracle for Enter a user name that has local system credentials.

5. Type the password for oracle twice

6. Type Y for Commit Oracle operation settings to the configuration file?

7.Type 5 to quit and return to the main menu.

8. Update the password for the oracle user in the Backup Exec Logon Accounts Wizard.

 

SOLUTION 2:

If the System Logon Account password is not getting updated, the account can be recreated as per the article:
How to change the System Logon Account credentials in Backup Exec if the password to the account is unknown. (veritas.com)

 

SOLUTION 3:

Add the Windows Logon Account  in the ORA_DBA Group on the Server where the Oracle DB is configured.

 

 

SOLUTION 4:

Ensure that the Logon account is configured in the same format (example: domain name\account) in the following two locations:

1. On the Backup Exec Media Server, under Tools | Options | Job defaults | Oracle | Modify list | Authentication Credentials for Oracle and DB2 Servers.

2. On the Remote Server, in the Remote Agent utility | under Database Access tab | Enable media server authentication for Oracle and DB2 operations.




NOTE: Additional Error messages that might be received if the Windows Logon Account used for accessing Oracle databases is not updated correctly.

0xe0001404 - The server name or logon account could not be authenticated.  Contact your backup operator. Ensure that the Backup Exec server and agent are compatible versions.
Final error category: Resource Errors

For additional information regarding this error refer to link V-79-57344-5124

 

Issue/Introduction

Oracle database backup fails with the error: 0xe000fe29 - Authentication failed on connection to the server. Make sure that the user account has the appropriate permissions and that the password was typed correctly