Hello Community,
We currently moving our datapump process on the DBMS Function and we face an issue. Below the output :
Job name = IMPORT_3432
Job Handle = 44
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4951
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5202
ORA-06512: at "ADMIN.IMPORT_DATA", line 38
errormsg : ORA-39001: invalid argument value | ORA-39000: bad dump file specification | ORA-31640: unable to open dump file "https://objectstorage.eu-frankfurt-1.oraclecloud.com/n/xxxxxx/b/xxxxxx/o/exp_prod_XX_20220622_1340_01.dmp" for read
ORA-17503: ksfdopn:11 Failed to open file https://swiftobjectstorage.eu-frankfurt-1.oraclecloud.com/v1/xxxxxx/xxxxxx/exp_prod_XX_20220622_1340_01.dmp
ORA-17500: ODM err:ODM Credential Not Found
We've check all the documentation and we correctly setup the Credentials with priv key with DBMS_CREATE_CREDENTIALS, we setup the DEFAULT_CREDENTIAL also. When we use the DBMS_LIST_OBJECTS, we correctly list all the files of the buckets. I've check the policy in OCI and it's set like this :
Allow group XXXXto inspect object-family in compartment XXXX
Allow group XXXX to read object-family in compartment XXXXX
Allow group XXXX to use object-family in compartment XXXXX
Allow groupXXXXX to manage object-family in compartment XXXXX
The only way for the moment to bypass this read error is to setup a Pre Auth request in the bucket but we want to use our service account setup on OCI.
We currently have an SR ongoing but to be honest, support is completely lost If someone already encounter this error and succeed to have credentials working with DBMS_DATAPUMP we really appreciate the help.