Transparent Data Encryption Oracle 10g Release 2

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 :

Edit sqlnet.ora ,First a wallet needs to be created that can store the encryption key . To setup TDE the location for the wallet needs to be set, directory sqlnet.ora : $ORACLE_HOME/network/admin/. Create directory encryption_wallet in your database server. example directory : /u01/app/oracle/admin/diarycoding/

Create Directory in example directory

MKDIR encryption_wallet

 

Edit sqlnet.ora

ENCRYPTION_WALLET_LOCATION=
  (SOURCE=(METHOD=FILE)(METHOD_DATA=
    (DIRECTORY=/u01/app/oracle/admin/diarycoding/encryption_wallet/)))

Create and open the wallet.

ALTER SYSTEM SET ENCRYPTION KEY AUTHENTICATED BY "passwordku";
ALTER SYSTEM SET ENCRYPTION WALLET OPEN AUTHENTICATED BY "passwordku";

 

Check Encryption

SELECT * FROM v$encryption_wallet;

 

Encrypt Column on Table

ALTER TABLE table_name MODIFY ( column_name column_type ENCRYPT,...etc);
ALTER TABLE CUSTOMER MODIFY (ALAMAT VARCHAR2(4000) ENCRYPT);

 

Check your table Encryption

SELECT * FROM dba_encrypted_columns where table_name='TableName’;

 

www.diarycoding.com

Leave a Comment.