Database Upgrade and TDE – Things to Know

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 11.2.0.4) 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, in…

Full Transportable Export/Import – Things to Know

This blog post is an addition to: Full Transportable Export/Import – Migrating an 11.2.0.4 database to Oracle Database 12c- into the Oracle Cloud Seth Miller commented the pitfall of having a serious issue during the Data Pump run, Data Pump exiting and not finishing, and you’ll have to do the entire backup/restore/incremental-roll-foward thing again. Without any doubt, this is no fun at all. So let me point out a few things to take into consideration – and some of them are not obvious I guess. Do you need to backup/restore/incremental-roll-forward again? When you let do Data Pump all the manual…

TDE is wonderful – Journey to the Cloud V

What happened so far on my Journey to the Cloud? Part I – Push a Button (Dec 3, 2015) Part II – Switch On/Off and Remove (Dec 4, 2015) Part III – Patch, patch, patch (Dec 22, 2015) Part IV – Clean Up APEX (Jan 19, 2016) You are here! ==> Part V – TDE is wonderful (Jan 28, 2016) Part VI – Patching does not work (Apr 18, 2016) Part VII – APEX is in CDB$ROOT again (Dec 21, 2016) Today’s journey: Learn about TDE (Transparent Data Encryption) and other secrets What I really really love about my job: Every day…