Modifying the Oracle Connect String

The Oracle connect string is a user account that has database administrator privileges that you use to access the standard and recovery catalog databases.

Note: If you want to use a user account other than ‘sys’, you must grant the SYSDBA or SYSBACKUP (in Oracle version 12 or more recent versions) privilege to the user account.

The account information is provided as a connect string with the following information:

  • The Oracle database user ID

  • The password for the user ID

  • The Oracle service name

You can use separate accounts to access the standard database and the recovery catalog database. The recovery catalog database user account must have recovery catalog owner privileges.

By default, the user account for the standard database has administration privileges. If you want to use a different account, use the following table for the user account requirements to access the database:

Account type

The user account must have:

Administrator

  • Oracle database administration privileges

  • SYSDBA or SYSBACKUP (in Oracle version 12 or more recent versions), ALTER SYSTEM, and SELECT ANY TABLE system privileges.

Non-administrator

Access to specific objects (as opposed to the admin account with the SELECT ANY TABLE privilege)

For example:

  • SELECT ON "SYS"."V_$DATABASE"

  • SELECT ON "SYS"."V_$DATAFILE"

  • SELECT ON "SYS"."V_$SESSION"

  • SELECT ON "SYS"."DBA_TABLESPACES"

  • GRANT SELECT ON "SYS"."V_$ARCHIVE_DEST" TO "USER_NAME

The Oracle database administrator can establish all other accounts except an Impersonate User account.

By default, when you discover or create an Oracle instance, the Commvault software automatically creates a default data subclient and a default archive log subclient.

Best Practice: Do not modify the default archive log subclient properties.

If you don't want the software to create the default archive log subclient, you can disable this feature by setting an additional setting. For more information, see Disabling Automatic Archive Log Subclient Creation.You can configure the data and log storage policies for the agent when you manually discover or automatically discover instances. The Commvault software assigns these storage policies to all the instances and default subclients that you discover.

The Commvault software assigns the storage policy to the discovered instance and default subclients by analyzing the following configuration information:

  • The storage policies configured for the discovered instances in the Oracle agent properties.

    The data storage policy is assigned to the discovered instance for command line data backup and to the Default subclient for data backups. The log storage policy is assigned to the discovered instance and to the Default archive log subclient for log backups.

  • The storage policies that are configured for a previously discovered Oracle instance.

  • The storage policy for the Default subclient of the DefaultBackupSet on the File System Agent agent.

  • If the client computer is associated with a Plan from the Command Center, the Plan is assigned as the storage policy for data and log backups on the discovered instance and the default subclients.

  • If there is no assigned storage policy in any of the above configuration information, you must add the storage policy to the Default subclient manually.

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, determine how to connect to the Oracle database.

    • 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 then in the Connect String box provide the user name, the user password and the TNS service name.

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

Loading...