Loading...

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, navigate to Client Computers | <Client> | Oracle.
  2. Right-click the <Instance>, and then click Properties.
  3. On the Details tab, enter the Oracle connection information:
    • To use the Oracle Wallet feature, select the Oracle Wallet Auto Login check box.
    • To use the Oracle Connect String, select the Use Connect String check box and in the Connect String box enter the Oracle connect string credentials.

      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.

Last modified: 8/29/2018 12:45:35 PM