Hi,
During some tests with object storage and SQL*Loader, I came across an issue.
As usual, I created the credentials in the database:
However, when I attempted to list the files from my bucket, I received the following error:
After checking MOS, I found a relevant note discussing the use of an API Key:
‘ORA-20401: Authorization failed’ error during listing contents of OCI Object storage using PL/SQL in ADB (Doc ID 2680364.1)
I created a credential using the API Key, and it worked successfully.
After some research, I came across this helpful thread discussing the usage of the appropriate OracleIdentityCloudService:
Following the instructions, I created credentials using the right Identity Domain for my account:
And everything worked as expected:
I’m using “Oracle-SSO” because this is the “domain” I’m using to log into my account.
For most of the customers, it will be OracleIdentityCloudService/(your OCI login username):
BEGIN
DBMS_CLOUD.CREATE_CREDENTIAL(
credential_name => 'MY_CREDENTIAL',
username => 'OracleIdentityCloudService/(Your OCI login username)',
password => '(Your auth token)'
);
END;
/I hope this helps!