ADW: Doing an import fails with "ORA-17500: ODM err:ODM HTTP Unauthorized" message
(Doc ID 2383194.1)
Last updated on OCTOBER 23, 2023
Applies to:
Autonomous Database Serverless - Version N/A to N/AInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |