Transparent Data Encryption is an excellent and very useful Oracle database feature. In this blog post I will show and highlight Database Upgrade and TDE – Things to Know.
Enabling Tablespace Encryption with TDE
For a simple example I use our Hands-On Lab and the UPGR database (Oracle 126.96.36.199) and the listener declarations in the 12.2 $ORACLE_HOME.
At first I add the following string to the sqlnet.ora file:
# sqlnet.ora # ENCRYPTION_WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = /u01/app/oracle/admin/UPGR/wallet)) )
Note 2018, Feb 4:
My previous example had
$ORACLE_BASE instead of
/u01/app/oracle, the real path, …