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

Last updated on APRIL 17, 2023

Applies to:

Symptoms

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

connected
SQL> exit;

$ impdp /@IMPORTDP

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

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

Cause

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