ADW: Doing an import fails with "ORA-17500: ODM err:ODM HTTP Unauthorized" message

(Doc ID 2383194.1)

Last updated on JUNE 28, 2018

Applies to:

Autonomous Data Warehouse Cloud - Version N/A to N/A
Information in this document applies to any platform.

Symptoms

Doing data pump import to Autonomous Datawarehouse instance using impdp is failing.

Steps in following document is used:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/load-data.html#GUID-9F6B551A-9DB7-44BE-A8ED-08E300C56DB1

impdp admin/password@adwc_high directory=DATA_PUMP_DIR FULL=Y dumpfile=DEFAULT_CREDENTIAL:https://swiftobjectstorage.us-dummyloc.oraclecloud.com/v1/tenancy/bucketname/sample_expdp_sh_sales.dmp remap_schema=SH:tenancy TRANSFORM=SEGMENT_ATTRIBUTES:n PARTITION_OPTIONS=MERGE TRANSFORM=dwcs_cvt_iots:y TRANSFORM=dwcs_cvt_constraints:y exclude=index, cluster, indextype, materialized_view, materialized_view_log, materialized_zonemap, db_link

Above command fails with following message:

Import: Release 12.2.0.1.0 - Production on Thu Apr 5 14:27:18 2018

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 18c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "https://swiftobjectstorage.us-dummyloc.oraclecloud.com/v1/tenancy/bucketname/test.dmp" for read
ORA-17503: ksfdopn:11 Failed to open file https://swiftobjectstorage.us-dummyloc.oraclecloud.com/v1/tenancy/bucketname/test.dmp
ORA-17500: ODM err:ODM HTTP Unauthorized

The default credentials are already set for the admin user, based on following command output:

From sqlplus session connect as admin user and issue:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms