{"id":48495,"date":"2026-11-20T14:57:02","date_gmt":"2026-11-20T13:57:02","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=48495"},"modified":"2026-11-20T14:57:04","modified_gmt":"2026-11-20T13:57:04","slug":"using-oracle-transparent-data-encryption-with-multitenant-databases","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/","title":{"rendered":"Using Oracle Transparent Data Encryption with Multitenant Databases"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\" id=\"h-with-the-increased-risk-of-a-cyberattacks-protection-of-one-of-your-most-valuable-asset-s-your-data-is-vital-data-within-the-oracle-database-is-generally-the-most-vital-and-or-sensitive-data-within-the-company-the-best-way-to-start-protecting-that-data-is-with-transparent-data-encryption-tde\">With the increased risk of a cyberattacks, the protection of one of your most valuable asset\u2019s, your data, is vital. Data within the Oracle database is generally the most vital and\/or sensitive data within the company. The best way to start protecting that data is with Transparent Data Encryption (TDE).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Some of the benefits of using TDE are:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Helps address security and compliance needs<\/li>\n\n\n\n<li>There is no need to change the applications that are accessing the database<\/li>\n\n\n\n<li>Users and applications are not aware the data is encrypted<\/li>\n\n\n\n<li>There is little downtime involved<\/li>\n\n\n\n<li>Your data is safe, even if the media is stolen<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">TDE encrypts sensitive data stored in data files. To prevent unauthorized decryption, TDE stores the encryption keys in a keystore. <\/p>\n\n\n\n<h1 id=\"h-secure-pdb-using-transparent-database-encryption-tde\" class=\"wp-block-heading\">Secure PDB Using Transparent Database Encryption (TDE)<\/h1>\n\n\n\n<h2 id=\"h-introduction\" class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In this blog we will focus on how to encrypt the database when working with Pluggable databases (PDB) , containers (CDB) and wallets as the keystore.<\/p>\n\n\n\n<h2 id=\"h-technical-details\" class=\"wp-block-heading\">Technical details<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">For this blog, we have the following setting:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OS : Oracle Linux 9.7<\/li>\n\n\n\n<li>Oracle Database 26ai<\/li>\n\n\n\n<li>Oracle Container Database : CDB26<\/li>\n\n\n\n<li>Oracle Pluggable Database : PDB26<\/li>\n<\/ul>\n\n\n\n<h2 id=\"h-task-1-validate-the-starting-state\" class=\"wp-block-heading\">Task 1: Validate the starting state<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">We start off with an unencrypted database and will be validating that state in this session.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Run the sql :<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>set linesize 170;\ncolumn wrl_parameter format a50\ncolumn wrl_type heading 'Type' format a10\ncolumn status heading 'Status' format a30\ncolumn fully_backed_up heading 'Backed Up' format a10\ncolumn pdb_name heading 'PDB Name' format a10\n\n select b.name pdb_name,wrl_type,\nwrl_parameter,\nstatus,wallet_type,\nkeystore_mode,\nfully_backed_up\nfrom v$encryption_wallet a,v$containers b\nwhere a.con_id = b.con_id(+);\nexit;<\/code><\/pre>\n\n\n\n<details class=\"nv-cv-m wp-block-details is-layout-flow wp-block-details-is-layout-flow\"><summary>Columns description<\/summary>\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-8f761849 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:100%\">\n<pre class=\"wp-block-code\"><code>WRL_PARAMETER                  ---&gt; Location of the wallet file\nStatus                         ---&gt; Wallet status\n                          NOT_AVAILABLE  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--&gt; No wallet created yet\n                          OPEN_NO_MASTER_KEY&nbsp;&nbsp;&nbsp;&nbsp;--&gt; keystore has been been created and is open, but no master key set\n                          OPEN          &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;--&gt; Wallet open, and master key set<\/code><\/pre>\n<\/div>\n<\/div>\n<\/details>\n\n\n\n<p class=\"wp-block-paragraph\">The output should be :<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>PDB Name   Type       WRL_PARAMETER                                      Status                         WALLET_TYPE          KEYSTORE Backed Up\n---------- ---------- -------------------------------------------------- ------------------------------ -------------------- -------- ----------\nCDB$ROOT   FILE       \/u01\/app\/oracle\/admin\/CDB26\/wallet                 NOT_AVAILABLE                  UNKNOWN              NONE     UNDEFINED\nPDB$SEED   FILE                                                          NOT_AVAILABLE                  UNKNOWN              UNITED   UNDEFINED\nPDB26      FILE                                                          NOT_AVAILABLE                  UNKNOWN              UNITED   UNDEFINED<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You can see the default location of the wallet file. There is no wallet yet. At this point CDB26 does not know about a wallet or encryption<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Look about encryption keys :<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>set feedback off\nset linesize 150\nset pagesize 50\nset heading on\ncolumn pdb_name heading \"PDB Name\" format a15\ncolumn tablespace_name heading \"Tablespace Name\" format a30\ncolumn masterkeyid_base64 heading \"Master Key ID\" format a60\ncolumn encrypted heading \"Encrypted\" format a10\ncolumn status heading \"Status\" format a10\ncolumn encryptionalg heading \"Encryption Alg\" format a15\n\nbreak on pdb_name skip 1\n\nselect pdb_name, \n       tablespace_name,encrypted,\n       utl_raw.cast_to_varchar2( utl_encode.base64_encode('01'||substr(mkeyid,1,4)))\n       || utl_raw.cast_to_varchar2( utl_encode.base64_encode(substr(mkeyid,5,length(mkeyid)))) masterkeyid_base64,\n       status,\n       encryptionalg\n FROM (select t.name tablespace_name,\n              z.name pdb_name,\n              t.con_id, encrypted,\n              RAWTOHEX(x.mkid) mkeyid ,\n              r.status status,\n              r.encryptionalg encryptionalg \n        from v$tablespace t, \n             x$kcbtek x,\n             v$containers z,\n             cdb_tablespaces q,\n             v$encrypted_tablespaces r \n        where t.ts#=x.ts# \n          and t.con_id=x.con_id \n          and t.con_id=z.con_id\n          and t.con_id = q.con_id\n          and t.con_id = r.con_id(+)\n          and t.ts# = r.ts#(+)\n          and t.name = q.tablespace_name)\norder by pdb_name,tablespace_name;\n\nexit;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The output should be :<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>PDB Name        Tablespace Name                Encrypted  Master Key ID                                                Status     Encryption Alg\n--------------- ------------------------------ ---------- ------------------------------------------------------------ ---------- ---------------\nCDB$ROOT        SYSAUX                         NO         ATThZEiYWUwngfMcKC8YYZI=\n                SYSTEM                         NO         ATThZEiYWUwngfMcKC8YYZI=\n                TEMP                           NO         ATThZEiYWUwngfMcKC8YYZI=\n                UNDOTBS1                       NO         ATThZEiYWUwngfMcKC8YYZI=\n                USERS                          NO         AQAAAAAAAAAAAAAAAAAAAAA=\n\nPDB26           SYSAUX                         NO         AWun6yDayU+kn1iwkckN4DE=\n                SYSTEM                         NO         AWun6yDayU+kn1iwkckN4DE=\n                TEMP                           NO         AWun6yDayU+kn1iwkckN4DE=\n                UNDOTBS1                       NO         AWun6yDayU+kn1iwkckN4DE=\n                USERS                          NO         AQAAAAAAAAAAAAAAAAAAAAA=<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Shows tablespaces associated with the database whether they are encrypted or not. If they are encrypted, the output show what is the master key use for encryption.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So actually, nothing is configured for Transparent Data Encryption in the CDB CDB26<\/p>\n\n\n\n<h2 id=\"h-task-2-backup\" class=\"wp-block-heading\">Task 2: Backup<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">This backup operation takes about 5 minutes to complete, is optional, and may be skipped. The main reason for performing this task is simply so that you can re-run this lab multiple times if you so choose, or restart midway if you make a mistake.<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>rman target \/\nRMAN&gt; backup database plus archivelog  delete input tag 'BEFORETDE';<\/code><\/pre>\n\n\n\n<h2 id=\"h-task-3-create-a-wallet\" class=\"wp-block-heading\">Task 3: Create A Wallet<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In this section we will create a wallet for the CDB CDB26.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">First, we create the wallet directory:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code> <span style=\"font-size: 0.85rem;text-align: initial\">mkdir -p \/u01\/app\/oracle\/wallets\/CDB26\/tde<\/span><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We need to perform the following:<\/p>\n\n\n\n<ul class=\"nv-cv-m wp-block-list\">\n<li>Changes the wallet root parameter. Recommendation for 19c and above is to use the spfile parameter <code>WALLET_ROOT<\/code><\/li>\n\n\n\n<li>Bounce the database<\/li>\n\n\n\n<li>Tells to the database to use a keystore file<\/li>\n\n\n\n<li>Create it and open it<\/li>\n\n\n\n<li>Create an autologin wallet (optional)<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>set verify off\nprompt\nprompt\nprompt #####################################################################################\nprompt #### set the WALLET_ROOT in the database to \/u01\/app\/oracle\/wallets\/CDB26\/wallet #### \nprompt #####################################################################################\nalter system set WALLET_ROOT='\/u01\/app\/oracle\/wallets\/CDB26' scope=spfile;\nprompt\nprompt ##############################################################################\nprompt ####  bounce the database - WALLET_ROOT changes require a DB bounce       #### \nprompt ##############################################################################\nstartup force;\nprompt ##############################################################################\nprompt ####  set tde_configuration to use a file (vs OKV)                       #### \nprompt ##############################################################################\nalter system set tde_configuration='KEYSTORE_CONFIGURATION=FILE' scope=both;\nprompt \nprompt ##########################################################################\nprompt ####   Create the united Keystore and open the keystore for the CDB ######\nprompt ##########################################################################\nprompt \nADMINISTER KEY MANAGEMENT CREATE KEYSTORE '\/u01\/app\/oracle\/wallets\/CDB26\/tde' IDENTIFIED BY \"Oracle4TDE!\";\nADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY \"Oracle4TDE!\";\nprompt \nprompt ###################################################\nprompt ####   Open the Keystore  for PDB26 ###############\nprompt ###################################################\nprompt \nprompt \nalter session set container=PDB26;\nADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY \"Oracle4TDE!\";\nalter session set container=CDB$ROOT;\nprompt \nprompt ##########################################################################\nprompt ####   Convert the united keystore to autologin ##########################\nprompt ##########################################################################\nprompt \nADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM KEYSTORE '\/u01\/app\/oracle\/wallets\/CDB26\/tde' IDENTIFIED BY \"Oracle4TDE!\";<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The output should be like:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>SQL&gt; prompt alter system set WALLET='\/u01\/app\/oracle\/wallets\/CDB26' scope=spfile;\nalter system set WALLET='\/u01\/app\/oracle\/wallets\/CDB26' scope=spfile\nSQL&gt; prompt\nSQL&gt; alter system set WALLET_ROOT='\/u01\/app\/oracle\/wallets\/CDB26' scope=spfile;\n\nSystem altered.\n\nSQL&gt; startup force;\n\nORACLE instance started.\n\nTotal System Global Area 1607700512 bytes\nFixed Size                  5009440 bytes\nVariable Size             503316480 bytes\nDatabase Buffers         1090519040 bytes\nRedo Buffers                8855552 bytes\nDatabase mounted.\nDatabase opened.\nSQL&gt;\nSQL&gt; ##############################################################################\nSQL&gt; ####  set tde_configuration to use a file (vs OKV)                  ####\nSQL&gt; ##############################################################################\nSQL&gt;\nSQL&gt; alter system set tde_configuration='KEYSTORE_CONFIGURATION=FILE' scope=both\nSQL&gt;\nSQL&gt;\nSystem altered.\n\nSQL&gt;\nSQL&gt; ##########################################################################\nSQL&gt; ####   Create the united Keystore and open the keystore for the CDB ######\nSQL&gt; ##########################################################################\nSQL&gt;\nSQL&gt; ADMINISTER KEY MANAGEMENT CREATE KEYSTORE '\/u01\/app\/oracle\/wallets\/CDB26\/tde' IDENTIFIED BY \"Oracle4TDE!\"\nSQL&gt; ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY \"Oracle4TDE!\"\nSQL&gt;\nSQL&gt;\nkeystore altered.\n\nSQL&gt;\nkeystore altered.\n\nSQL&gt;\nSQL&gt;\nSQL&gt; ###################################################\nSQL&gt; ####   Open the Keystore  for PDB26 ###############\nSQL&gt; ###################################################\nSQL&gt;\nSQL&gt; ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY \"Oracle4TDE!\"\nSQL&gt; alter session set container=PDB26\nSQL&gt;\nSQL&gt;\nSession altered.\n\nSQL&gt;\nkeystore altered.\n\nSQL&gt;\nSession altered.\n\nSQL&gt; ##########################################################################\nSQL&gt; ####   Convert the united keystore to autologin ##########################\nSQL&gt; ##########################################################################\nSQL&gt;\nSQL&gt; ADMINISTER KEY MANAGEMENT CREATE AUTO_LOGIN KEYSTORE FROM KEYSTORE '\/u01\/app\/oracle\/wallets\/CDB26\/tde' IDENTIFIED BY \"Oracle4TDE!\"\n\nkeystore altered.<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Keep the following in mind:<\/strong><\/p>\n\n\n\n<div class=\"nv-cv-d nv-cv-m wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<ul class=\"wp-block-list\">\n<li>Changing the spfile parameter requires a database bounce.<\/li>\n\n\n\n<li>Set the wallet root location when you have a maintenance window and set the key.<\/li>\n\n\n\n<li>This allows you to go down the encryption path later.<\/li>\n\n\n\n<li>They don\u2019t have to be done together.<\/li>\n\n\n\n<li>Plan for a bounce before you start the encryption process.<\/li>\n\n\n\n<li>After the database comes back up from the bounce the following tasks are performed by the script:\n<ul class=\"wp-block-list\">\n<li>Set tde configuration parameter. In this case it is set to file (other choice is Oracle Key Vault aka OKV). What we are telling the database is : in wallet root location, under the tde directory, I\u2019m going to be using a wallet file<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">For the keystore the following tasks are performed in this step:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Give it a wallet file<\/li>\n\n\n\n<li>Give it a password<\/li>\n\n\n\n<li>Open it<\/li>\n\n\n\n<li>Changing to PDB26<\/li>\n\n\n\n<li>Using a autologin wallet<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Note the 2 files in the directory<\/p>\n\n\n\n<ul class=\"nv-cv-d nv-cv-m wp-block-list\">\n<li>.p12 is the password file &nbsp;&nbsp;&nbsp;&nbsp;\n<ul class=\"wp-block-list\">\n<li>Cannot access the file without the password &nbsp;&nbsp;&nbsp;&nbsp;<\/li>\n\n\n\n<li>Need to back this up when you backup the database &nbsp;&nbsp;&nbsp;&nbsp;<\/li>\n\n\n\n<li>It should not be with the database directories Use to add keys and make changes to the wallet<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>.sso is the auto login wallet \n<ul class=\"wp-block-list\">\n<li>You do not want to backup this file <\/li>\n\n\n\n<li>Anybody who has this will be able open the database and read the keys<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Even if somebody got the database without the wallets, they can\u2019t get the key that is protecting that database.<\/p>\n\n\n\n<h3 id=\"h-notes\" class=\"wp-block-heading\"><strong>Notes<\/strong>:<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">We decide to using a unified wallet (default feature). This means the wallet that is used for the CDB contains the keys for the CDB and the PDBs. When you have Multi-Tenant the CDB and the PDB\u2018s all have independent keys. In this case :<\/p>\n\n\n\n<ul class=\"nv-cv-d nv-cv-m wp-block-list\">\n<li>The CDB has it\u2019s own Master Encryption Key<\/li>\n\n\n\n<li>The PDB has it\u2019s own Master Encryption Key If there were a second PDB it would also have it\u2019s own unique Master Encryption Key<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The script also creates a second wallet, the autologin wallet. No password needed to read it. Database able to connect to it at startup. When restarted, it will auto read the wallet and pull any keys that are set in that wallet to do the encryption.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you do not create an autologin wallet when you start the database, you need to manually open up the wallet using the password in order to access the keys.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Not as secure a method, but less effort when you bounce the database. Most customers use an auto login wallet, especially with RAC.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check the wallet status:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>set linesize 170;\ncolumn wrl_parameter format a50\ncolumn wrl_type heading 'Type' format a10\ncolumn status heading 'Status' format a30\ncolumn fully_backed_up heading 'Backed Up' format a10\ncolumn pdb_name heading 'PDB Name' format a10\n\n select b.name pdb_name,wrl_type,\nwrl_parameter,\nstatus,wallet_type,\nkeystore_mode,\nfully_backed_up\nfrom v$encryption_wallet a,v$containers b\nwhere a.con_id = b.con_id(+);\nexit;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The output should be:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>PDB Name   Type       WRL_PARAMETER                                      Status                         WALLET_TYPE          KEYSTORE Backed Up\n---------- ---------- -------------------------------------------------- ------------------------------ -------------------- -------- ----------\nCDB$ROOT   FILE       \/u01\/app\/oracle\/wallets\/CDB26\/tde\/                 OPEN_NO_MASTER_KEY             PASSWORD             NONE     UNDEFINED\nPDB$SEED   FILE                                                          CLOSED                         UNKNOWN              UNITED   UNDEFINED\nPDB26      FILE                                                          OPEN_NO_MASTER_KEY             PASSWORD             UNITED   UNDEFINED<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The last time we ran this status check the value was <code>NOT AVAILABLE<\/code>. It has now evolved to <code>OPEN_NO_MASTER_KEY<\/code> since we are yet to set the key. As a result, while CDB26 and PDB26 both have the wallet open, there is no master key.<\/p>\n\n\n\n<h2 id=\"h-task-4-set-the-master-key\" class=\"wp-block-heading\">Task 4: Set The master Key<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">We will set the encryption key for the CDB and PDB, and will rely on the tag feature.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Tags are important to identify keys, especially when using OKV where keys are stored in a centralized vault and managed for multiple databases. In such instances, the tag allows to uniquely identify the encryption key.<\/p>\n\n\n\n<h3 id=\"h-notes-0\" class=\"wp-block-heading\"><strong>Notes<\/strong>: <\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This is <strong>the point of no return<\/strong>: once you create a key for the database you can&#8217;t rollback it (without RMAN restore).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">From this point forward, the database expects the wallet and encryption key to be there when the database starts up. The database knows there is a wallet and master encryption key associated with it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you don\u2019t have the database access the wallet, you will get messages that it can\u2019t access the key.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Be sure of the steps before you do this to a database that you use normally.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Each PDB also has its own unique key.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now we can set encryption key for the CDB and PDBs:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>set verify off\nprompt\nprompt\nprompt ##############################################################################\nprompt #### set the encryption key for the CDB    ####\nprompt ##############################################################################\nprompt\nADMINISTER KEY MANAGEMENT SET KEY FORCE KEYSTORE IDENTIFIED BY \"Oracle4TDE!\"  with backup  USING 'CDB26: MASTERKEY_FIRST';\nprompt\nprompt\nprompt ##############################################################################\nprompt #### set the encryption key for the PDB    ####\nprompt ##############################################################################\nprompt\nalter session set container=PDB26;\nADMINISTER KEY MANAGEMENT SET KEY FORCE KEYSTORE IDENTIFIED BY \"Oracle4TDE!\"  with backup  USING 'PDB26: MASTERKEY_FIRST';\nexit;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The output should be:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>SQL&gt;  ADMINISTER KEY MANAGEMENT SET KEY FORCE KEYSTORE IDENTIFIED BY \"Oracle4TDE!\"  with backup  USING 'CDB26: MASTERKEY_FIRST';\n\nkeystore altered.\n\nSQL&gt; alter session set container=PDB26;\n\nSession altered.\n\nSQL&gt; ADMINISTER KEY MANAGEMENT SET KEY FORCE KEYSTORE IDENTIFIED BY \"Oracle4TDE!\"  with backup  USING 'PDB26: MASTERKEY_FIRST';\n\nkeystore altered.<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We use the keyword <code>FORCE <\/code>because we use an autologin wallet. If we don&#8217;t use it we throw an error :<code> ORA-46658: keystore not open in the container.<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check the new status of our wallets :<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>set linesize 170;\ncolumn wrl_parameter format a50\ncolumn wrl_type heading 'Type' format a10\ncolumn status heading 'Status' format a30\ncolumn fully_backed_up heading 'Backed Up' format a10\ncolumn pdb_name heading 'PDB Name' format a10\n\n select b.name pdb_name,wrl_type,\nwrl_parameter,\nstatus,wallet_type,\nkeystore_mode,\nfully_backed_up\nfrom v$encryption_wallet a,v$containers b\nwhere a.con_id = b.con_id(+);\nexit;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The output should be:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>PDB Name   Type       WRL_PARAMETER                                      Status                         WALLET_TYPE          KEYSTORE Backed Up\n---------- ---------- -------------------------------------------------- ------------------------------ -------------------- -------- ----------\nCDB$ROOT   FILE       \/u01\/app\/oracle\/wallets\/CDB26\/tde\/                 OPEN                           AUTOLOGIN            NONE     NO\nPDB$SEED   FILE                                                          OPEN                           AUTOLOGIN            UNITED   NO\nPDB26      FILE                                                          OPEN                           AUTOLOGIN            UNITED   NO<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">We can see that the status come to OPEN for all container.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check now the status of tablespaces and keys:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>set feedback off\nset linesize 150\nset pagesize 50\nset heading on\ncolumn pdb_name heading \"PDB Name\" format a15\ncolumn tablespace_name heading \"Tablespace Name\" format a30\ncolumn masterkeyid_base64 heading \"Master Key ID\" format a60\ncolumn encrypted heading \"Encrypted\" format a10\ncolumn status heading \"Status\" format a10\ncolumn encryptionalg heading \"Encryption Alg\" format a15\n\nbreak on pdb_name skip 1\n\nselect pdb_name,\n       tablespace_name,encrypted,\n       utl_raw.cast_to_varchar2( utl_encode.base64_encode('01'||substr(mkeyid,1,4)))\n       || utl_raw.cast_to_varchar2( utl_encode.base64_encode(substr(mkeyid,5,length(mkeyid)))) masterkeyid_base64,\n       status,\n       encryptionalg\n FROM (select t.name tablespace_name,\n              z.name pdb_name,\n              t.con_id, encrypted,\n              RAWTOHEX(x.mkid) mkeyid ,\n              r.status status,\n              r.encryptionalg encryptionalg\n        from v$tablespace t,\n             x$kcbtek x,\n             v$containers z,\n             cdb_tablespaces q,\n             v$encrypted_tablespaces r\n        where t.ts#=x.ts#\n          and t.con_id=x.con_id\n          and t.con_id=z.con_id\n          and t.con_id = q.con_id\n          and t.con_id = r.con_id(+)\n          and t.ts# = r.ts#(+)\n          and t.name = q.tablespace_name)\norder by pdb_name,tablespace_name;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The output should be:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>PDB Name        Tablespace Name                Encrypted  Master Key ID                                                Status     Encryption Alg\n--------------- ------------------------------ ---------- ------------------------------------------------------------ ---------- ---------------\nCDB$ROOT        SYSAUX                         NO         AR\/omWDjKUCwvLr9YksXp5A=\n                SYSTEM                         NO         AR\/omWDjKUCwvLr9YksXp5A=\n                TEMP                           NO         AR\/omWDjKUCwvLr9YksXp5A=\n                UNDOTBS1                       NO         AR\/omWDjKUCwvLr9YksXp5A=\n                USERS                          NO         AQAAAAAAAAAAAAAAAAAAAAA=\n\nPDB26           SYSAUX                         NO         AZWgNOvpkktOoa8PVYU0iIg=\n                SYSTEM                         NO         AZWgNOvpkktOoa8PVYU0iIg=\n                TEMP                           NO         AZWgNOvpkktOoa8PVYU0iIg=\n                UNDOTBS1                       NO         AZWgNOvpkktOoa8PVYU0iIg=\n                USERS                          NO         AQAAAAAAAAAAAAAAAAAAAAA=<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">No tablespaces are encrypt yet.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">And for the keys?<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code><code>set linesize 170;\ncolumn activation_time heading 'Activation Time' format a22\ncolumn pdb_name heading 'PDB Name' format a15\ncolumn key_id heading 'Key ID' format a60\n\n\nselect  b.name pdb_name,\n        to_char(a.activation_time,'dd-mon-yyyy hh:mi:ssam') activation_time,\n        a.key_id\nfrom v$encryption_keys a,v$containers b\nwhere a.con_id = b.con_id(+);<\/code><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The output should be:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>PDB Name        Activation Time        Key ID\n--------------- ---------------------- ------------------------------------------------------------\nCDB$ROOT        10-nov-2026 03:04:08pm AR\/omWDjKUCwvLr9YksXp5AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA\nPDB26           10-nov-2026 03:05:47pm AZWgNOvpkktOoa8PVYU0iIgAAAAAAAAAAAAAAAAAAAAAAAAAAAAA<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You can see the Key ID relation between the two queries.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The master key id <code>AQAAAAAAAAA <\/code>is the default master key for user created tablespaces.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We are ready to encrypt the database!<\/p>\n\n\n\n<h2 id=\"h-task-5-encrypt-the-tablespaces\" class=\"wp-block-heading\">Task 5: Encrypt The Tablespaces<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In this section we will encrypt tablespaces. However before proceeding we need to set an encryption algorithm on the CDB.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">By default the algorithm is :<\/p>\n\n\n\n<ul class=\"nv-cv-d nv-cv-m wp-block-list\">\n<li>AES128 for Oracle Database 19c<\/li>\n\n\n\n<li>AES256 for Oracle Database 26ai<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">It is more secure to use AES256 by default, even in 19c. For this, you can set the hidden parameter <code>\"_TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM\"<\/code> like this:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>alter system set \"_TABLESPACE_ENCRYPTION_DEFAULT_ALGORITHM\"='AES256' scope=both;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">In Oracle 26ai this parameter is unhidden.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Execute the following settings:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>set verify off\nprompt\nprompt\nprompt ##############################################################################\nprompt #### set the default encryption algorithm to AES256                       ####\nprompt #### set the default to always encrypt new tablespaces                    ####\nprompt ##############################################################################\nprompt\nalter system set \"tablespace_encryption_default_algorithm\" = 'AES256' scope = both;\nalter system set encrypt_new_tablespaces = always scope = both;\nprompt\nexit;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The output should be:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>##############################################################################\n#### set the default encryption algorithm to AES256                       ####\n#### set the default to always encrypt new tablespaces                    ####\n##############################################################################\n\nalter system set \"tablespace_encryption_default_algorithm\"='AES256' scope=both;\nSystem altered.\nalter system set encrypt_new_tablespaces=always scope=both;\nSystem altered.\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">With this setup, any new tablespaces will be encrypted with AES256.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We are now ready to encrypt<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is an on-line encryption and will perform the following:<\/p>\n\n\n\n<ul class=\"nv-cv-d nv-cv-m wp-block-list\">\n<li>Sequentially going through all the data files associated with the tablespace and creating a new encrypted copy.<\/li>\n\n\n\n<li>Keeping track of any changes to each data file during the process and applying them after the encryption is completed<\/li>\n\n\n\n<li>Under the covers it replaces the current data file with the new data file while the database is up and running<\/li>\n\n\n\n<li>When finished the space is reclaimed<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>alter tablespace USERS ENCRYPTION ONLINE USING 'AES256' ENCRYPT;\nalter tablespace SYSAUX ENCRYPTION ONLINE USING 'AES256' ENCRYPT;\nalter tablespace SYSTEM ENCRYPTION ONLINE USING 'AES128' ENCRYPT;\nalter tablespace SYSTEM ENCRYPTION  USING 'AES256' rekey;\nalter session set container=PDB26;\nalter tablespace SYSAUX ENCRYPTION ONLINE USING 'AES256' ENCRYPT;\nalter tablespace USERS ENCRYPTION ONLINE USING 'AES256' ENCRYPT;\nalter tablespace SYSTEM ENCRYPTION ONLINE USING 'AES128' ENCRYPT;\nalter tablespace SYSTEM ENCRYPTION  USING 'AES256' rekey;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">It will take some times&#8230;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this example, you can see that we encrypt SYSTEM tablespace with AES128 algorithm, and rekey it with AES256.<\/p>\n\n\n\n<h3 id=\"h-notes-1\" class=\"wp-block-heading\"><strong>Notes:<\/strong><\/h3>\n\n\n\n<ul class=\"nv-cv-d nv-cv-m wp-block-list\">\n<li>You need to have enough additional space for the largest data file that is going to be encrypted because a second file will be created<\/li>\n\n\n\n<li>This can be done in parallel, but more data files are created in parallel so keep your free space in mind<\/li>\n\n\n\n<li>This can be at a later point in time<\/li>\n\n\n\n<li>You don\u2019t have to do all the tablespaces at once<\/li>\n\n\n\n<li>When you are finished you need to do a full backup as an incremental will not see the tablespace as encrypted<\/li>\n\n\n\n<li>The backup should be done as-soon-as it is done encrypting<\/li>\n\n\n\n<li>If you do a restore to the data file before doing the full backup and applied the archive logs to bring it forward the restore would be unencrypted<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Looking for the tablespace status;<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>set feedback off\nset linesize 150\nset pagesize 50\nset heading on\ncolumn pdb_name heading \"PDB Name\" format a15\ncolumn tablespace_name heading \"Tablespace Name\" format a30\ncolumn masterkeyid_base64 heading \"Master Key ID\" format a60\ncolumn encrypted heading \"Encrypted\" format a10\ncolumn status heading \"Status\" format a10\ncolumn encryptionalg heading \"Encryption Alg\" format a15\n\nbreak on pdb_name skip 1\n\nselect pdb_name,\n       tablespace_name,encrypted,\n       utl_raw.cast_to_varchar2( utl_encode.base64_encode('01'||substr(mkeyid,1,4)))\n       || utl_raw.cast_to_varchar2( utl_encode.base64_encode(substr(mkeyid,5,length(mkeyid)))) masterkeyid_base64,\n       status,\n       encryptionalg\n FROM (select t.name tablespace_name,\n              z.name pdb_name,\n              t.con_id, encrypted,\n              RAWTOHEX(x.mkid) mkeyid ,\n              r.status status,\n              r.encryptionalg encryptionalg\n        from v$tablespace t,\n             x$kcbtek x,\n             v$containers z,\n             cdb_tablespaces q,\n             v$encrypted_tablespaces r\n        where t.ts#=x.ts#\n          and t.con_id=x.con_id\n          and t.con_id=z.con_id\n          and t.con_id = q.con_id\n          and t.con_id = r.con_id(+)\n          and t.ts# = r.ts#(+)\n          and t.name = q.tablespace_name)\norder by pdb_name,tablespace_name;\n\nselect  b.name pdb_name,\n        to_char(a.activation_time,'dd-mon-yyyy hh:mi:ssam') activation_time,\n         a.key_id\nfrom v$encryption_keys a,v$containers b\nwhere a.con_id = b.con_id(+);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">The output should be:<\/p>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>PDB Name        Tablespace Name                Encrypted  Master Key ID                                                Status     Encryption Alg\n--------------- ------------------------------ ---------- ------------------------------------------------------------ ---------- ---------------\nCDB$ROOT        SYSAUX                         YES        AR\/omWDjKUCwvLr9YksXp5A=                                     NORMAL     AES256\n                SYSTEM                         YES        AR\/omWDjKUCwvLr9YksXp5A=                                     NORMAL     AES256\n                TEMP                           NO         AR\/omWDjKUCwvLr9YksXp5A=\n                UNDOTBS1                       NO         AR\/omWDjKUCwvLr9YksXp5A=\n                USERS                          YES        AR\/omWDjKUCwvLr9YksXp5A=                                     NORMAL     AES256\n\nPDB26           SYSAUX                         YES        AZWgNOvpkktOoa8PVYU0iIg=                                     NORMAL     AES256\n                SYSTEM                         YES        AZWgNOvpkktOoa8PVYU0iIg=                                     NORMAL     AES256\n                TEMP                           NO         AZWgNOvpkktOoa8PVYU0iIg=\n                UNDOTBS1                       NO         AZWgNOvpkktOoa8PVYU0iIg=\n                USERS                          YES        AZWgNOvpkktOoa8PVYU0iIg=                                     NORMAL     AES256<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code alignwide\"><code>PDB Name        Activation Time        Key ID\n--------------- ---------------------- ------------------------------------------------------------\nCDB$ROOT        10-nov-2026 03:04:08pm AR\/omWDjKUCwvLr9YksXp5AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA\n\nPDB26           10-nov-2026 03:05:47pm AZWgNOvpkktOoa8PVYU0iIgAAAAAAAAAAAAAAAAAAAAAAAAAAAAA<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Note:<\/strong><\/p>\n\n\n\n<ul class=\"nv-cv-d nv-cv-m wp-block-list\">\n<li>You can see the Master Encryption Key is set for SYSAUX and SYSTEM<\/li>\n\n\n\n<li>It now shows as encrypted<\/li>\n\n\n\n<li>It shows as encrypted with AES256<\/li>\n\n\n\n<li>The keys starts with AR\/om, which matches the key for the CDB<\/li>\n\n\n\n<li>If you look at the PDB the Master Encryption Key begins with AZWgN0 and it matches the Key Id at the bottom<\/li>\n\n\n\n<li>NOTICE: TEMP and UNDO were not encrypted\n<ul class=\"wp-block-list\">\n<li>No reason to encrypt temp again because anything that gets encrypted will stay encrypted<\/li>\n\n\n\n<li>The same thing happens with UNDO as it would inherit the starting point of encrypted data, so there is no reason to encrypt this as well<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<div class=\"nv-cv-d nv-cv-m wp-block-yoast-seo-ai-summarize yoast-ai-summarize\"><h2>Key Takeaways<\/h2>\n<ul class=\"wp-block-list yoast-ai-summarize-list\">\n<li>Protecting your data with Transparent Data Encryption (TDE) is essential to secure sensitive information in Oracle databases.<\/li>\n\n\n\n<li>TDE does not require application changes, keeps data encrypted from users, and operates with minimal downtime.<\/li>\n\n\n\n<li>The article guides you through tasks such as creating a wallet, setting a master key, and encrypting tablespaces.<\/li>\n\n\n\n<li>It highlights the importance of managing encryption keys properly, especially when moving Pluggable Databases (PDBs).<\/li>\n\n\n\n<li>Finally, it stresses that encrypting tablespaces ensures any data processed will remain secure throughout operations.<\/li>\n<\/ul>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>With the increased risk of a cyberattacks, the protection of one of your most valuable asset\u2019s, your data, is vital. Data within the Oracle database is generally the most vital and\/or sensitive data within the company. The best way to start protecting that data is with Transparent Data Encryption (TDE). Some of the benefits of&hellip;&nbsp;<\/p>\n","protected":false},"author":146,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[59],"tags":[],"class_list":["post-48495","post","type-post","status-publish","format-standard","category-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Using Oracle Transparent Data Encryption with Multitenant Databases - dbi services Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Oracle Transparent Data Encryption with Multitenant Databases\" \/>\n<meta property=\"og:description\" content=\"With the increased risk of a cyberattacks, the protection of one of your most valuable asset\u2019s, your data, is vital. Data within the Oracle database is generally the most vital and\/or sensitive data within the company. The best way to start protecting that data is with Transparent Data Encryption (TDE). Some of the benefits of&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-20T13:57:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-11-20T13:57:04+00:00\" \/>\n<meta name=\"author\" content=\"Xavier Franck Godard\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Xavier Franck Godard\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/using-oracle-transparent-data-encryption-with-multitenant-databases\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/using-oracle-transparent-data-encryption-with-multitenant-databases\\\/\"},\"author\":{\"name\":\"Xavier Franck Godard\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8e3967941ef4e053c1e59df8bb2d058f\"},\"headline\":\"Using Oracle Transparent Data Encryption with Multitenant Databases\",\"datePublished\":\"2026-11-20T13:57:02+00:00\",\"dateModified\":\"2026-11-20T13:57:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/using-oracle-transparent-data-encryption-with-multitenant-databases\\\/\"},\"wordCount\":1683,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/using-oracle-transparent-data-encryption-with-multitenant-databases\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/using-oracle-transparent-data-encryption-with-multitenant-databases\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/using-oracle-transparent-data-encryption-with-multitenant-databases\\\/\",\"name\":\"Using Oracle Transparent Data Encryption with Multitenant Databases - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2026-11-20T13:57:02+00:00\",\"dateModified\":\"2026-11-20T13:57:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/using-oracle-transparent-data-encryption-with-multitenant-databases\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/using-oracle-transparent-data-encryption-with-multitenant-databases\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/using-oracle-transparent-data-encryption-with-multitenant-databases\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Oracle Transparent Data Encryption with Multitenant Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/8e3967941ef4e053c1e59df8bb2d058f\",\"name\":\"Xavier Franck Godard\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/XFG-web.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/XFG-web.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/02\\\/XFG-web.jpg\",\"caption\":\"Xavier Franck Godard\"},\"description\":\"Xavier-Franck Godard has more than 25 years of experience in Information Technology. His expertise covers database architecture, disaster recovery (Data Guard), backup and recoverability configuration (RMAN, Flashback), performance analysis and tuning (AWR\\\/ADDM, Statspack), and migration\\\/upgrade projects on-premises and on Oracle Database Appliance. Prior to dbi services, he was a senior DBA at DIGORA for seven years, a database consultant at A2F Services for seven years, and a DBA at Soci\u00e9t\u00e9 des Autoroutes Paris-Normandie (SAPN) for eight years. He holds a Master's degree in Pure Mathematics. His industry experience covers retail, public sector, insurance, banking, health, and e-commerce.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/xavier-franck-godard\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Using Oracle Transparent Data Encryption with Multitenant Databases - dbi services Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/","og_locale":"en_US","og_type":"article","og_title":"Using Oracle Transparent Data Encryption with Multitenant Databases","og_description":"With the increased risk of a cyberattacks, the protection of one of your most valuable asset\u2019s, your data, is vital. Data within the Oracle database is generally the most vital and\/or sensitive data within the company. The best way to start protecting that data is with Transparent Data Encryption (TDE). Some of the benefits of&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2026-11-20T13:57:02+00:00","article_modified_time":"2026-11-20T13:57:04+00:00","author":"Xavier Franck Godard","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Xavier Franck Godard","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/"},"author":{"name":"Xavier Franck Godard","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8e3967941ef4e053c1e59df8bb2d058f"},"headline":"Using Oracle Transparent Data Encryption with Multitenant Databases","datePublished":"2026-11-20T13:57:02+00:00","dateModified":"2026-11-20T13:57:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/"},"wordCount":1683,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/","url":"https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/","name":"Using Oracle Transparent Data Encryption with Multitenant Databases - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2026-11-20T13:57:02+00:00","dateModified":"2026-11-20T13:57:04+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/using-oracle-transparent-data-encryption-with-multitenant-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Using Oracle Transparent Data Encryption with Multitenant Databases"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8e3967941ef4e053c1e59df8bb2d058f","name":"Xavier Franck Godard","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/02\/XFG-web.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/02\/XFG-web.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2024\/02\/XFG-web.jpg","caption":"Xavier Franck Godard"},"description":"Xavier-Franck Godard has more than 25 years of experience in Information Technology. His expertise covers database architecture, disaster recovery (Data Guard), backup and recoverability configuration (RMAN, Flashback), performance analysis and tuning (AWR\/ADDM, Statspack), and migration\/upgrade projects on-premises and on Oracle Database Appliance. Prior to dbi services, he was a senior DBA at DIGORA for seven years, a database consultant at A2F Services for seven years, and a DBA at Soci\u00e9t\u00e9 des Autoroutes Paris-Normandie (SAPN) for eight years. He holds a Master's degree in Pure Mathematics. His industry experience covers retail, public sector, insurance, banking, health, and e-commerce.","url":"https:\/\/www.dbi-services.com\/blog\/author\/xavier-franck-godard\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48495","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/146"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=48495"}],"version-history":[{"count":35,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48495\/revisions"}],"predecessor-version":[{"id":48853,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48495\/revisions\/48853"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=48495"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=48495"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=48495"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}