Creating Credentials for Database Host and Database

A credential is an Oracle Scheduler object that has a user name and password pair stored in a dedicated database object.

You must create two credentials for:

• Host credential: A SQLPlus script job uses a host credential to authenticate itself with a database instance or the operating system so that the SQLPlus executable can run.

• Connection credential: This credential contains a database credential, which connects SQLPlus to the database before running the script.

To create the credentials:

1. In the Connections tab, expand the connection in which your user account is created.

2. Expand Scheduler under that connection.

3. Under Scheduler, right-click Credentials and click New Credentials. The Create Credentials dialog box opens.

4. First, create the host credential to log in to the host on which the job is running. Provide the following information:

   1. Name

   2. Select Enabled.

   3. Description

   4. User Name

   5. Password

5. Click Apply.

6. Next, create the connection credential for the Database connection. Repeat the same procedure as described in step 1 through step 5.

This completes the task of creating credentials for the database host and connection.