WALLET_ROOT

How to Resolve ORA-46669: the target keystore does not exist

by Ed Chen
March 25, 2022February 21, 2023

ORA-46669 Tried to merge the target keystore with the source one, but it failed with ORA-46669. SQL> administer key management merge keystore '/u01/app/oracle/product/19.0.0/db_1/admin/ORCLCDB/wallet/tde' identified by… Read More »

How to Move Wallet_Root out of ASM

by Ed Chen
March 24, 2022February 22, 2023

Move Wallet out of ASM In case that you found it's difficult to manage the wallet in ASM, I provide a way to move it… Read More »

How to Move Wallet_Root into ASM

by Ed Chen
March 23, 2022December 27, 2022
2 Comments

WALLET_ROOT In How to enable Oracle TDE 19c in RAC DB, we put the wallet in every server of a RAC database. Since the wallet… Read More »

How to Resolve ORA-46638: merging of the two keystores failed

by Ed Chen
March 22, 2022March 25, 2022

ORA-46638 There're two error patterns of ORA-46638 in this post. 1. Incorrect Source Location Let's see the source of wallet location. SQL> show parameter wallet_root… Read More »

How to Resolve OPEN_NO_MASTER_KEY after Cloning PDB

by Ed Chen
March 2, 2022August 11, 2022

OPEN_NO_MASTER_KEY of AUTOLOGIN After cloning a PDB with TDE into a RAC database, we saw OPEN_NO_MASTER_KEY in the second instance of the new PDB. In… Read More »

How to Disable Auto-Login Keystore

by Ed Chen
August 29, 2021June 8, 2022

Disable Auto-Login Sometimes, you may want to perform some operations directly using an open password-protected keystore without auto-login keystore. To close AUTOLOGIN temporarily, we can… Read More »

How to Enable Oracle TDE 19c Step by Step

by Ed Chen
August 9, 2021February 12, 2023
8 Comments

Oracle TDE 19c I have talked about how to extract plain text from a normal, non-encrypted data file before. If you're considering a more secure… Read More »

Where is xdb_wallet

by Ed Chen
November 5, 2020January 31, 2023

There're two possible locations for xdb_wallet. Single-instance Databases The root entry of xdb_wallet is $ORACLE_BASE for single-instance databases. $ORACLE_BASE/admin/$ORACLE_SID/xdb_wallet/ RAC Databases The root entry of… Read More »