Oracle Autonomous Database – ORA-20400: Request Failed with status HTTP 400 when connecting to Gen AI

Yesterday I added a new AI profile to an Oracle Autonomous Database using the Database Actions UI, when testing this new profile I received the following error:

This appears to be caused by Database Actions not creaing the profile correctly, the fix was to manually create the profile using the following SQL statement:

BEGIN
  DBMS_CLOUD_AI.CREATE_PROFILE(
      profile_name => 'TestProfile',
      attributes   => '{"provider": "oci",
                        "credential_name": "TESTCREDS",
                        "object_list": [{"owner": "ADMIN"}],
                        "model": "cohere.command-r-plus-08-2024",
                        "region": "uk-london-1"
                       }');
END;
/

This created a profile named TestProfile that uses the existing saved credentials named TESTCREDS to connect to the cohere.command-r-plus-08-2024 model in the uk-london-1 region – for some reason the Database Actions UI hardcodes the region to Chicago (which is another reason to create the profile manually!)

In addition to this, it gives the profile access to all objects owned by the account named ADMIN.

Obvouisly, you’ll need to update these with the relevant values for your environment.

After doing this, it was able to successfull connect: