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.

About This Task

By default, when you discover or create a SAP for Oracle instance, the SnapProtect 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.

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

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

      Expand All

      UNIX

      Log on to the SAP on Oracle server with the ora<SID> user.

      On the command line, type the following command:

      su - ora<SID>
      echo $ORACLE_SID

      Example

      su - ora<CER>
      echo $ORACLE_SID
      CER

      Windows

      Log on to the SAP on Oracle server with the <domain_name>\ora<SID> user.

      On the command line, type the following command:

      echo %ORACLE_SID%

      Example

      echo %ORACLE_SID%
      TRD

    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.

      Expand All

      UNIX

      Log on to the SAP on Oracle server with the ora<SID> user and retrieve the $ORACLE_HOME environment variable.

      On the command line, type the following command, substituting the SID parameter with the Oracle SID of your database:

      echo $ORACLE_HOME

      Example

      su - ora<TRD>
      echo $ORACLE_HOME
      /oracle/TRD/112_64

      Windows

      Log on to the SAP on Oracle server with the <domain_name>\ora<SID> user, substituting the domain_name parameter with your database domain name and the SID parameter with the Oracle SID of your database.

      On the command line, type the following command:

      echo %ORACLE_HOME%

      Example

      echo %ORACLE_HOME%
      I:\oracle\product\10.2.0\dbhome_1

    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.

      The SAP server environment variables contain this information.

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

      Expand All

      UNIX

      Log on to the SAP on Oracle server with the ora<SID> user, substituting the SID parameter with the Oracle SID of your database.

      On the command line, type the following command:

      echo $SAPDATA_HOME

      Example

      su - ora<TRD>
      echo $SAPDATA_HOME
      /oracle/TRD

      Windows

      Log on to the SAP on Oracle server with the <domain_name>\ora<SID> user, substituting the domain_name parameter with your database domain name and the SID parameter with the Oracle SID of your database.

      On the command line, type the following command:

      echo %SAPDATA_HOME%

      Example

      echo %SAPDATA_HOME%
      I:\oracle\TRD

    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.

      Expand All

      UNIX

      Log on to the SAP on Oracle server with the ora<SID> user, substituting the SID parameter with the Oracle SID of your database.

      On the command line, type the following command, substituting the domain_name parameter with your database domain name and the SID parameter with the Oracle SID of your database:

      echo $SAPEXE

      Example

      su - ora<DCT>
      echo $SAPEXE
      /usr/sap/DCT/SYS/exe/run

      Windows

      Log on to the SAP on Oracle server with the <domain_name>\ora<SID> user.

      On the command line, type the following command, substituting the domain_name parameter with your database domain name and the SID parameter with the Oracle SID of your database:

      echo %SAPEXE%

      Example

      echo %SAPEXE%
      I:\usr\sap\TRD\SYS\exe\uc\NTAMD64

    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.