My Oracle Support Banner

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

Last updated on JULY 02, 2019

Applies to:

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

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

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


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