Loading...

Creating a SAP Oracle Instance

Manually add a SAP for Oracle instance in the CommCell Console when you need to manage a database.

Note: Use the DDB for the instance for a RAC configuration.

For more information on SAP on Oracle users and their roles, go to the SAP website, Users and Roles.

About This Task

By default, when you discover or create a SAP for Oracle instance, the Commvault software automatically creates an archive log subclient. You can disable this feature by setting an additional setting. For more information, see Disabling Automatic Archive Log Subclient Creation.

If you run SAP Kernel 7.20, Patch 100 or later, you can use the SAP Secure Store feature. The SAP Store feature uses encryption to store user authentication credentials (for example, user name and password) on a Secure Storage File System (SSFS). For additional information, go to the SAP website, Secure Store.

Refer to the following SAP Notes that provide upgrade and installation information.

Note

Description

1764043

BR*Tools SSFS Support

1622837

SAP Kernel and SFFS Patches

1639578

SFFS Setup

1764043

See the section titled "Storage of BR*Tools user/password in secure storage"

Procedure

  1. From the CommCell Browser, expand Client Computers > client.
  2. Right-click SAP for Oracle, point to All Tasks and then click New Instance (ORACLE SID).
  3. On the General tab of the Creating New Instance dialog box:
    1. In the Instance (ORACLE SID) box, enter the instance name.

      You can use the following commands to obtain the SAP on Oracle instance name.

      UNIX

      Windows

    2. In the User Account box, enter the login credentials to access the SAP for Oracle client.

      For UNIX configurations, use ora<SID> for this value, substituting the SID parameter with the Oracle SID of your database.

      For Windows configurations, use <domain_name>\ora<SID> for this value, substituting the domain_name parameter with your database domain name and the SID parameter with the Oracle SID of your database.

    3. In the ORACLE HOME box, enter the Oracle application install path.

      You can use the following commands to obtain the Oracle home path.

      Windows

    4. In the SAP DATA PATH box, enter the SAP on Oracle $SAPDATA_HOME environment path. This is the path that contains the SAP on Oracle data and log files.

      The SAP server environment variables contain this information.

      You can use the following commands to obtain the SAP data path.

      UNIX

      Windows

    5. In the SAP EXE PATH box, enter the path to the SAP EXE path. This is the path that contains the executable files.

      You can use the following commands to obtain the SAP EXE path.

      UNIX

      Windows

    6. In the Storage Policy used for the data of default subclient list, select a storage policy name.
  4. If you have a SAP Secure Store environment, on the Details tab, select the Use Sap Secure Store check box.
  5. On the Details tab, In the Connect String box, enter the credentials to connect to the Oracle database. For example "sys/pwd12@orcl4".
  6. In the Block Size box, type the size of the block for backup and restore operations.
  7. On the Storage Device tab, enter storage policy information:
    1. In the Storage Policy used for user command backup of data list, select a storage policy.
    2. In the Storage Policy used for all Archive Log backups list, select a storage policy name.
  8. Click OK to close the Creating New Instance dialog box.

Last modified: 10/15/2018 1:01:08 PM