How to Getting Started With Transparent Data Encryption in Oracle 12c (Case Upgrade DB 10g))

This encryption process works so that users who take data by way of database backup. This encryption works when the user restore the database on another server it will fail because it does not have a wallet that has been created. For more details follow these steps :

Set Master Key

alter system set "_db_discard_lost_masterkey" = true;

 

Create Key Management

administer key management create keystore '/u01/app/oracle/product/12.1.0/db_1/owm/wallets/oracle' identified by "passw0rd";

Create Auto Login Wallet

administer key management create auto_login keystore from keystore '/u01/app/oracle/product/12.1.0/db_1/owm/wallets/oracle' identified by "passw0rd";

Other Action :

administer key management set keystore close identified by "passw0rd";
administer key management merge keystore '/u01/app/oracle/admin/DiaryCoding/encryption_wallet/' identified by "passw0rd" into existing keystore '/u01/app/oracle/product/12.1.0/db_1/owm/wallets/oracle' identified by "passw0rd" with backup;
ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY "passw0rd";
alter system set "_db_discard_lost_masterkey" = false;

www.diarycoding.com

Leave a Comment.