Loading...

Adding a SAP for 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.

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"

Connect String Considerations

The software uses the Connect String that you specify for the instance for browse operations and to view the instance status. Depending on your configuration, the SAP for Oracle agent uses “/” or “//” for data protection and recovery operations. If you want to use “//”, then you must configure the SAP secure store on Commvault and on SAP. For more information on SSFS, go to the SAP support site and see SAP Note 1611877 Support for ABAP SSFS during database connect.

To use “system” as the user, the password must be "manager" and you need to set the following additional setting. To the SAP Oracle client, add the additional setting as shown in the following table.

For instructions on how to add additional settings from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.

Property

Value

Name

sCVSAPNOSLASH

Category

OracleSapAgent

Type

String

Value

Y

Note: If you have disabled OS authentication, and the system user password is not "manager" and you do not have the SSFS feature enabled, then SAP support site and see SAP Note 408000 , Starting BR* tools and SAPDBA without Specifying a Password.

When you have this configuration, you need to run the third-party backup and restore operations by specifying –u <username/password>

Brbackup –d <devicetype> -t <datatype> –m all –c force –u <username/password>

Example

brbackup –d util_file -t online –m all –c force –<username/password>
brarchive –d util_file -s –c force –u <username/password>
brrestore –d util_file –b last –m all –c force –u <username/password>

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.

      Note: For a RAC configuration, this is the DDB SID.

      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.

      Note: For a RAC configuration, use <ora<SID> as the account.

      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.

      Note: For a RAC configuration, verify this with the customer, or the administrator.

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

      UNIX

      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.

      Note: For a RAC configuration, verify this with the customer, or the administrator.

      If you do specify this value, then an online_cons command line backup job that uses a a rman or util backup device is split into a data command line job and a log command line job.

      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: 9/14/2018 7:33:08 PM