I got a data pump dump file from a customer. It is exported from Oracle cloud and by default it is encrypted. The customer also provided the wallet and password. I need to import it into an on-premise database server. I copied the wallet to the on-premise database server (folder /tmp/wallet) and unzipped it. I updated sqlnet.ora with the wallet location.
WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY=/tmp/wallet)))
SSL_SERVER_DN_MATCH=yes
I then tried to open the wallet but it failed.
SQL> administer key management set keystore open identified by xxxxxx;
ERROR at line 1:
ORA-28353: failed to open wallet
Being unable to open the wallet, data pump import also failed with this error:
ORA-39002: invalid operation
ORA-39189: unable to decrypt dump file set
ORA-28365: wallet is not open
Any idea how I can import such dump file with the provided wallet? Thanks.