Configuring database access on the media server for Oracle operations in Backup Exec

Problem

Oracle backup and restore jobs fail if the oracle server's FQDN (Fully Qualified Domain Name) is not in the media server's authentication list
 

Error Message

0xe0001402 : This server name is not in media server's authentication list. Enter the server's fully qualified domain name and logon account into the media server's authentication list. Server names in the authentication list are case-sensitive.
 

Cause

You must add the Oracle server name and the logon account name to the media servers list of Oracle servers and authentication credentials. The media server has database access for operations on Oracle instances that are included in the authentication list. Before you start any backup or restore operations, on the computer on which the Oracle instances are installed, make sure that you use the Remote Agent Utility to configure instance information and database access.

Solution

To configure database access on the media server for Oracle operations :

1. Click on the Configuration tab for Backup Exec.

2. Select Configurations and settings  | Backup Exec Settings. (Fig.1)
    

3. Add the oracle server name (FQDN) and click on Add. (Fig. 2)
    

4. Once the server is added, you can add, edit, or delete a server name and provide the logon account.

5. For Oracle RAC nodes, enter the virtual node name and all of the physical node names for the logon account name.

Use the same logon account format that you use when you enter the logon account name on the Database Access tab in the Remote Agent Utility. For example, if you entered Domainname\Username on the Remote Agent Utility, use that same format on the list of authentication credentials.

Note: If the oracle tab under Backup Exec Settings does not reflect the image above ensure that the Oracle license (Agent for Applications and Databases) is properly installed.