Oracle User Accounts

The Oracle Agent requires an operating system account and an Oracle user account. Configure both accounts to allow access to the Oracle application and the Oracle target database.

  • An operating system account with administrator privileges for the Oracle application.

    The following table defines the user account requirements for each operating system:

Operating System

User Account

Windows

  • The Local Administrator of the computer on which the Oracle database resides.

  • The user must be part of the ora_dba group with read and write permissions on the Commvault folder.

Note

when using Oracle 12c, grant full control permission for the Oracle home user for the Commvault folder.

UNIX

Member of the user group assigned during the Agent installation. The operating system user account can also be used.

  • An Oracle user account with the SYSDBA or SYSBACKUP (in Oracle version 12 or higher) privilege can access the Oracle target database. Provide the account information as a connect string with the following connection details:

    • The database user ID and password

    • The Oracle Service Name (as defined in the tnsnames.ora file)

    Use separate accounts to access the target database and the recovery catalog database. The recovery catalog database user account must have RECOVERY_CATALOG_OWNER privileges, which are not required for the target database user.

    By default, the user account for the target database has administration privileges and must be established so the Oracle database administrator can configure additional accounts (except Impersonate User).

Initially, the user account credentials are provided during the instance configuration after the installation of the Agent. You can subsequently change the user account information to access the Oracle database and application at the Instance level whenever the credentials are updated.

Loading...