From the course: Oracle Database 12c: Security

Unlock the full course today

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

Open the wallet after DB restart

Open the wallet after DB restart - Oracle Database Tutorial

From the course: Oracle Database 12c: Security

Start my 1-month free trial

Open the wallet after DB restart

“

- [Instructor] Throughout this chapter we saw how we can configure a keystore, set a master encryption key, encrypt data in our tables, and create encrypted backups all using Oracle Transparent Data Encryption. While Transparent Data Encryption is transparent to your application, that is, you don't have to make any changes to your applications or SQL queries when using TDE, there is a little bit of extra operational administration overhead that is required from the database administrator. For example, you will need to manually open your encryption wallet when specifying the password after a restart of your database instance. Let's see this in action. We'll start by connecting to our root container as the sysdba user. So I'll type sqlplus sys/oracle as sysdba. Let's restart our database. So I'll type shutdown immediate and startup to bring our Oracle Database back online. Once the database has successfully restarted let's see what will happen if we'll attempt to select data from a…

Contents