Creating a SAP 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 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"

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.
  
  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.
  
  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.
  You can use the following commands to obtain the Oracle home path.
  
  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.
  
  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.