From the course: Oracle Database 12c: Security

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create encryption key

Create encryption key - Oracle Database Tutorial

From the course: Oracle Database 12c: Security

Start my 1-month free trial

Create encryption key

“

- [Instructor] Before we can go ahead and start using Oracle's transparent data encryption capabilities and encrypt the data in our database tables, we need to first open the keystore using the set keystore open command as well as set a master encryption key. So, in order to accomplish that, let's open a SYSDBA connection to our root container. I'll type sqlplus sys/oracle as sysdba verifying that my connection is indeed to the root container by typing show con_name. We will now use the set keystore open command while supplying the keystore password to open our keystore. You can find the command included in your exercise file. So, let's copy this command and paste it to our SQL*Plus window. The CONTAINER = ALL clause of the command is used to set the keystore in all of the pluggable databases in our container database. There we go. The keystore should now be open. Now, that the keystore is open and ready, we can set our TDE master encryption key. The TDE master encryption key is…

Contents