db19c How to merge keystore

To merge a wallet from a source database, into a target database, proceed as below:

#1 On the source, create a temporary directory

mkdir /tmp/TDEwallet

#2 Copy the source wallet into the temp directory

cp <wallet_root/tde>/cwallet.p12 /tmp/TDEwallet

If the wallet is stored on ASM, use the following command to

administer key management create keystore '/tmp/TDEwallet' identified by welcome;
administer key management merge keystore '+DATA/EMDEVU/tde' into existing keystore '/tmp/TDEwallet' identified by welcome with backup;

#3 On the target system, create the same temporary directory

mkdir /tmp/TDEwallet

#4 Transfer the wallet file /tmp/TDEwallet/ewallet.p12 in the target system, in the same directory

#5 On the target database, marge the two wallets

ADMINISTER KEY MANAGEMENT MERGE KEYSTORE '/tmp/TDEwallet' IDENTIFIED BY welcome INTO EXISTING KEYSTORE '+DATA/EMTSTP/tde' IDENTIFIED BY welcome WITH BACKUP;

#6 Remove the autologin cwallet.sso

#7 Create the autologin

administer key management create auto_login keystore from keystore identified by "welcome";

#8 Check the wallet status:

select inst_id, con_id, wallet_type, status from gv$encryption_wallet;