Tag: ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY

This post demonstrate how to configure TDE in 11.2.

For how to configure Transparent Data Encryption ( TDE ) in 12c or above, please click here:

• Configure sqlnet.ora file with Encrypted Wallet Location
• Create a Directory for Encrypted Wallet
• Set the Master Encryption Key
• Open the Wallet
• Set up Auto-Login wallet
• Create an Encrypted Tablespace
• Create a Table with Encrypted Column

Configure sqlnet.ora File Including Encrypted Wallet Location

...
..
.
ENCRYPTION_WALLET_LOCATION=
    (SOURCE=
      (METHOD=FILE)
      (METHOD_DATA=(DIRECTORY=/var/opt/oracle/dbaas_acfs/TESTDB/tde_wallet)))
...
..
.

Create a Directory for Encrypted Wallet

$mkdir -p /var/opt/oracle/dbaas_acfs/TESTDB/tde_wallet