Import Wallet on CDB in 19c Oracle Database

Before import, we need to open the wallet.

Open the wallet

 SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "<password>";

 Import the wallet

SQL> administer key management import encryption keys with secret "<password>" from '/d01/wallet/tde/testpdb.key' identified by "<password>" with backup;

Verify Wallet Status

SQL> select STATUS from V$ENCRYPTION_WALLET;

           STATUS
    OPEN