Using TDE in a multitenant environment

In this recipe, you will perform different operations using Transparent Data Encryption in a multitenant environment.

Getting ready

It is assumed that:

  • You have two container databases (the multitenant architecture), version 12.1.0.2 in the same host.
  • You have at least one pluggable database in each container database
  • You have sample schemes installed.

How to do it...

  1. Enter the following text into your sqlnet.ora file located in a network/admin directory of your oracle home (for example, /u01/app/oracle/product/12.1.0/dbhome_1)
    ENCRYPTION_WALLET_LOCATION=
  (SOURCE=
    (METHOD=FILE)
         (METHOD_DATA=
        (DIRECTORY=/u01/app/oracle/admin/$ORACLE_SID/wallet)))
  2. Change your environment to the first container database (for example, ...

Get Oracle Database 12c Security Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial