{暗号化}マスター暗号化鍵を設定

演習

 

https://docs.oracle.com/cd/F19136_01/asoag/configuring-transparent-data-encryption.html#GUID-AFC2AF54-3C53-46EB-B867-01DA523F7870


show parameter wallet
show parameter tde

ALTER SYSTEM SET WALLET_ROOT = '/oradata' SCOPE = spfile SID = '*';

shutdown immediate
startup


ALTER SYSTEM SET TDE_CONFIGURATION="KEYSTORE_CONFIGURATION=FILE" SCOPE = BOTH SID = '*';

show parameter wallet
show parameter tde

select * from v$encryption_wallet;

ADMINISTER KEY MANAGEMENT CREATE KEYSTORE IDENTIFIED BY oracle;


ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY oracle ;

ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY oracle WITH BACKUP USING 'backup_identifier';

ADMINISTER KEY MANAGEMENT SET KEYSTORE close IDENTIFIED BY oracle ;

 


ADMINISTER KEY MANAGEMENT CREATE LOCAL AUTO_LOGIN KEYSTORE 
FROM KEYSTORE IDENTIFIED BY oracle;