Adding an Oracle application server

When an Oracle application server is added, an inventory of the instances and databases that are associated with the application server is captured and added to IBM Spectrum® Protect Plus. This process enables you to complete backup and restore jobs, as well as run reports.

Procedure

To register an Oracle application server, complete the following steps.

  1. In the navigation pane, click Manage Protection > Databases > Oracle.
  2. Click Manage Application Servers.
  3. Click Add Application Server to add the host machine.
  4. In the Application Properties pane, enter the host address.
    The host address is a resolvable IP address, or a resolvable path and machine name.
  5. Select User or SSH key.
    Option Description
    User Click this option to specify an existing user or enter a user ID and password. The user must have sudo privileges set up. Populate the fields as follows:
    Use existing user
    Select this check box to use a previously entered user name and password for the application server. Select a user name from the Select user list.
    UserID
    Enter your user name for the application server. If the virtual machine is attached to a domain, the user identity follows the default domain\name format. If the user is a local administrator, use the local_administrator format.

    For Kerberos-based authentication only, the user identity must be specified in the username@FQDN format. The user name must be able to authenticate using the registered password to obtain a ticket-granting ticket (TGT) from the key distribution center (KDC) on the domain that is specified by the fully qualified domain name.

    Password
    Enter your password for the application server.
    SSH Key Click this option to use an SSH key. Select a key from the Select a SSH key list.
  6. To protect multithreaded databases in Oracle 12c and later versions, provide credentials for the databases:
    1. Click Get databases to detect and list the Oracle databases on the host server that you are adding.
      Each Oracle database is listed with its name, status, and an indication of whether credentials were previously specified for the database.
    2. For each multithreaded database that you want to protect, click Set Credential and specify the user ID and password. Alternatively, you can select an existing user from the Select user list.
      You must specify the credentials of an Oracle database user who has SYSDBA privileges.
  7. In Maximum concurrent databases, set the maximum number of databases to back up concurrently on the server.
    Server performance is impacted when many databases are backed up concurrently, as each database utilizes multiple threads and consumes bandwidth when copying data. Use this option to control the impact on server resources and minimize the impact on production operations.
  8. Click Save. IBM Spectrum Protect Plus confirms a network connection, adds the application server to the IBM Spectrum Protect Plus database, and then catalogs the instance.
    If a message appears indicating that the connection is unsuccessful, review your entries. If your entries are correct and the connection is unsuccessful, contact a system administrator to review the connections.

What to do next

After you add the Oracle application server, complete the following action:
Action How to
Assign user permissions to the application server. See Creating a role.