# Add an SAP for Oracle Database Instance

Add an SAP for Oracle database instance.

## Before You Begin

You need the following information:

- The Oracle application installation path

- The credentials that you use to access the Oracle client

## Procedure

1. From the Command Center navigation pane, go to Protect > Databases.

   The database Overview page appears.

2. From the Add instance list, select Database Server.

   The Configure database instance page appears.

3. Select SAP for Oracle, and click Next.

   The Add SAP for Oracle instance dialog box appears.

4. From the Server name list, select the database server that contains the instance.

5. In the Oracle SID box, enter a name for the instance.

6. From the Plan list, select the backup plan to use for the instance.

7. In the Oracle home box, enter the Oracle application install path.

   Note

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

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

   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

8. Select the following Authentication method:

   - OS authentication

   - Credential

9. If you select OS authentication, then ops$user is used for running backups and restores.

10. If you select Credential, from the Connect String boxes, select an existing database user credential or add a new credential. To add a new credential, do the following:

    Steps to add a credential

    1. Click the + icon beside the Credentials list.

       The Add Credential dialog box appears.

    2. In the Credential vault box, select a credential vault to store, share, and update account credentials with shared resources in your environment.

    3. In the Credential name box, enter the credential name of the database user.

    4. In the Connect string box, enter user name, password and TNS service name.

    5. In the Description box, enter the credential description.

    6. Click Save.

    Note

    - In case of Windows OS, you need to provide the user account used for backups and restores, and then save.

    - For SAP Oracle, credentials are used to run backups and restores only if brbackup and brrestore can be triggered using the connect string natively. For eg. brbackup -u sys -p password.

    - The Connect string support is available only for Unix platforms.

    - The client must have bUseConnectStringForBRTools configured to ensure connect string is used correctly.

11. Move the Use SAP secure store toggle key to the right if you have a SAP Secure Store environment, .

12. In the SAPDATA home 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 value with the customer or the administrator.

    If you specify this value, then an online_cons command line backup job that uses 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

    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

13. In the SAPEXE 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

    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

14. Click Add.

×

Loading...