Prerequisites

• •Copy the ojdbc8.jar file to the following directory and restart the Secure Agent:
<Secure Agent installation directory>/apps/process-engine/ext
You can download the ojdbc8.jar file from the Oracle website.
• •Add the IP address of the Secure Agent machine to the ACL filtering exception list on the Oracle Cloud Server.
• •CREATE_CREDENTIAL procedure in the DBMS_CLOUD package.
DBMS_CLOUD.CREATE_CREDENTIAL (
credential_name IN VARCHAR2,
user_ocid IN VARCHAR2,
tenancy_ocid IN VARCHAR2,
private_key IN VARCHAR2,
fingerprint IN VARCHAR2);

The following table describes the parameters used for the create credential procedure:

Parameter	Description
credential_name	Specifies the name of the credential to be stored.
user_ocid	Specifies the user's Oracle client ID (OCID).
tenancy_ocid	Specifies the tenancy's OCID.
private_key	Specifies the generated private key. Private keys generated with a passphrase are not supported. You need to generate a private key without a passphrase.
fingerprint	Specifies a fingerprint. After a generated public key is uploaded to the user's account, the fingerprint is displayed in the console. Use the displayed fingerprint for this parameter.

For information about creating the credential procedure, see the Oracle DBMS Cloud documentation.
• •CREATE_PROFILE procedure in the DBMS_CLOUD_AI package.
DBMS_CLOUD_AI.CREATE_PROFILE
profile_name IN VARCHAR2,
attributes IN CLOB DEFAULT NULL,
status IN VARCHAR2 DEFAULT NULL,
description IN CLOB DEFAULT NULL
);

The following table describes the parameters used for the create profile procedure:

Parameter	Description
profile_name	Name of the AI profile. The profile name must follow the naming rules of the Oracle SQL identifier. The profile name can't exceed 125 characters. This is a required parameter.
attributes	Profile attributes in the JSON format. The default value is NULL.
status	Status of the profile. The default value is enable.
description	Description for the AI profile. The default value is NULL.

When you create a profile, you can associate the profile with the database tables. When the user prompts a query, Oracle runs that prompt in context with these tables to respond.
For more information about creating the profile procedure, see the Oracle DBMS Cloud AI package documentation.