Configuring User Account to Access the Oracle Database

You can configure the user account privileges to access the Oracle database.

Procedure

1. From the CommCell Browser, expand Client Computers > client > Oracle.

2. Right-click the instance and then click Properties.

   The Instance Properties dialog box is displayed.

3. On the Details tab, enter the Oracle connection information:

   • To use the Oracle Wallet feature (Secure External Password Store), select the Oracle Wallet Auto Login check box and just provide the TNS service name in the third Connect String box.

     Note

     If you provide the user name and password, the software ignores the Oracle Wallet feature.

   • To use the Oracle Connect String, select the Use Connect String check box and in the Connect String box provide the user name, the user password and the TNS service name.

     Note

     If you want to use an account that is other than 'sys', you must grant the SYSDBA or SYSBACKUP (in Oracle version 12 or higher) privilege to the user account.

     Enter the Connect String to connect to the Oracle database as follows:

     1. In the first box enter the database user ID.

     2. In the second box enter the Password.

     3. In the Confirm Password dialog box, re-enter the password, and click OK.

     4. In the third box enter the Oracle Service name.

     For example, in the following:

     sysdba/<password>@orcl

     sysdba is the Database User ID

     <password> is the Database User ID password

     orcl is the Oracle service name

4. Click OK to close the Instance Properties dialog box.