Database Security Products (MOSC)

MOSC Banner

TDE configuration on Physical Standby

edited May 23, 2026 5:21PM in Database Security Products (MOSC) 3 commentsQuestion

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#);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center