Database Administration (MOSC)

MOSC Banner

Data pump import to ATP failing with ORA-17500: ODM err:ODM HTTP Unauthorized

edited Jun 4, 2020 9:03AM in Database Administration (MOSC) 4 commentsAnswered

Hello,

I'm trying to import data from on premise database 12.2.0.1 to ATP database 18 Free tier

expdp and impdp are version 12.2.0.1

export file named DEMOSOT12.DMP is uploaded to Oracle Cloud infrastructure Object Storage

Firstly I created Auth Token

Then I created credential:

begin

DBMS_CLOUD.CREATE_CREDENTIAL(

credential_name=> 'DEF_CRED_NAME',

username => '<my_username>',

password => '<MY_TOKEN>'

);

end;

/

dbms_cloud.enable_credential(credential_name => 'DEF_CRED_NAME');

alter database property set default_credential='ADMIN.DEF_CRED_NAME';

and then I tried import using native URI format

impdp admin/pass@database directory=data_pump_dir  dumpfile=DEF_CRED_NAME:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center