My Oracle Support Banner

IMPDP/EXPDP Doesn't work wih OS authentication or External Password Store (Doc ID 2560960.1)

Last updated on DECEMBER 06, 2020

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


As of Oracle 19.3, the EXPDP/IMPDP scripts are hanging due to request for password for specified user.

If password is specified explicitly in command line "impdp user/password ..." it always connect without asking for password, but this is security issue, since password is revealed in command.
If I configure secure external password store as per (Doc ID 340559.1), I'm successfully able to connect "sqlplus /@tnsconnstring" without asking for password.

It seems, that IMPDP and EXPDP ignores secure external password :

$ sqlplus /@IMPORTDP

SQL> exit;

$ impdp /@IMPORTDP

Import: Release - Production on Sat Jun 15 15:59:27 2019

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


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

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