My Oracle Support Banner

ATP : Import to ATP From Object Store Fails with 'ORA-17500: ODM Err:ODM HTTP Unauthorized' (Doc ID 2446550.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Autonomous Transaction Processing - Version NA and later
Information in this document applies to any platform.

Symptoms

Importing to ATP DB from (.dmp) file present in object storage fails with following error.

$impdp admin/password@atp_low directory=data_pump_dir
dumpfile="default_credential:https://objectstorage.eu-frankfurt-1.oraclecloud.com/v1/<TENANCY>/<BUCKET>/dump.dmp"

Import: Release 12.2.0.1.0 - Production on Mon Sep 3 12:56:54 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://objectstorage.eu-frankfurt-1.oraclecloud.com/v1/<TENANCY>/<BUCKET>/dump.dmp" for read
ORA-17503: ksfdopn:4 Failed to open file
https://objectstorage.eu-frankfurt-1.oraclecloud.com/v1/<TENANCY>/<BUCKET>/dump.dmp
ORA-17500: ODM err:File does not exist

 

 

 

Changes

 

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.