impdp user/pass DIRECTORY=dp_dir DUMPFILE=encrypted.dmp \ DECRYPTION_PASSWORD=correct_password Problem: Wallet not open or missing.
ADMINISTER KEY MANAGEMENT SHOW ENCRYPTION KEYS; ora-39189 unable to decrypt dump file set
1. Overview Error Code: ORA-39189 Message: unable to decrypt dump file set Component: Oracle Data Pump (expdp, impdp) Typical Impact: Import operation fails immediately upon reading the dump file header. impdp user/pass DIRECTORY=dp_dir DUMPFILE=encrypted
ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "wallet_password"; Requires both the password and an open wallet with the correct key. ora-39189 unable to decrypt dump file set
Encryption mode: Password Encryption algorithm: AES128 impdp directory=DATA_PUMP_DIR dumpfile=encrypted.dmp decrypt_password=wrong_pass If password is wrong, ORA-39189 appears immediately. 5. Solutions 5.1 Password-based encryption (most common) Problem: Missing or wrong DECRYPTION_PASSWORD .