Setting Preferred Credentials

When you set preferred credentials, Database Control automatically fills in host computer and database login credentials for you at times when it usually prompts for these credentials. Database Control also fills in these credentials when it is about to run a job that requires credentials.

To set preferred credentials for the database:

1. From any Database Control page, at the top of the page, click Preferences.

   The Preferences page appears.

2. Click Preferred Credentials in the left-hand pane.

   The Preferred Credentials page appears, showing a table of targets.

3. In the table row for the Database Instance, click the icon under Set Credentials.

   The Database Preferred Credentials page appears.

4. Enter the following credentials:

   • Database credentials for Username/Password and SYSDBA Username/SYSDBA Password

   • Host credentials for Host Username/Host Password

   For example, you might typically connect as the user SYSTEM, use the SYS account for SYSDBA access, and use oracle for the host user name.

   Note: The host user may require certain host privileges to run background jobs such as database backups. For example, on UNIX and Linux, the host user must belong to the OSDBA group (typically dba). On Windows, the host user must be a member of the Administrators group and must be granted the Log on as batch job logon right. See your platform documentation for more information.

5. Click Test to test your credentials.

   A confirmation message is displayed if your credentials can be verified.

6. Click Apply to apply the changes.