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 126.96.36.199.0 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
$ impdp /@IMPORTDP
Import: Release 188.8.131.52.0 - 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