TDE configuration on Physical Standby
Oracle database 19c
Oracle Linux 8
Primary wallet location is ASM
Standby wallet location is Linux OS file system
From the Standby alert log
KZTDE:kztsmptc: Missing Key ID: AbzCw64OLE+EvxqHmPV5kywAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
ORA-28374: typed master key not found in wallet
Primary database
Display the key id inside the primary database.
select name,
utl_raw.cast_to_varchar2( utl_encode.base64_encode('01'||substr(mkeyid,1,4))) || utl_raw.cast_to_varchar2( utl_encode.base64_encode(substr(mkeyid,5,length(mkeyid)))) masterkeyid_base64FROM (select t.name, RAWTOHEX(x.mkid) mkeyid from v$tablespace t, x$kcbtek x where t.ts#=x.ts#);