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 navigation pane, go to Protect > Databases.

   The Instances page appears.

2. In the upper-right area of the page, click Add instance.

   The Add instance dialog box appears.

3. Click SAP for Oracle.

   The Add SAP for Oracle instance dialog box appears.

4. From the Server name list, select the SAP for Oracle 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 server 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. To use the Oracle connect string, in the Connect String boxes, enter the database user name, password, and the service name. For example, "sys/pwd12@orcl4".

9. If you have a SAP Secure Store environment, move the Use SAP secure store toggle key to the right.

10. 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

11. 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

12. On Windows servers, to modify the operating system user credentials, under Advanced, complete the following steps:

    • To modify the operating system user name, in the OS user name box, enter the user name.

      The user must have permissions to run the brbackup, brarchive, and brrestore commands.

    • To modify the operating system user password, in the OS user password box, enter the password.

13. Click Add.