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 disabled OS authentication, and the system user password is not "manager" and you do not have the SSFS feature enabled, you can use the Oracle connect string specified in the SAP Oracle instance properties to run the brbackup, brarchive, brrestore, and rerecover commands.

To use the connect string, set the bUseConnectStringForBRTools 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	bUseConnectStringForBRTools
Category	OracleSapAgent
Type	Boolean
Value	True

Procedure

From the CommCell Browser, expand Client Computers > client.
Right-click SAP for Oracle, point to All Tasks and then click New Instance (ORACLE SID).
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
  
  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.
  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.
  
  If you do 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
```
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
  
  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.
If you have a SAP Secure Store environment, on the Details tab, select the Use Sap Secure Store check box.
On the Details tab, in the Connect String box, enter the credentials to connect to the Oracle database. For example "sys/pwd12@orcl4".
In the Block Size box, type the size of the block for backup and restore operations.
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.
Click OK to close the Creating New Instance dialog box.