For creating an encrypted tablespace in a PLUGGABLE DATABASE ( PDB) for multitenant oracle 12c setup, we need to do a few additional steps.

DEMO:

In the below DEMO, we will create a encrypted tablespace under a pluggable database SDCP1

1. Update sqlnet.ora file with ENCRYPTION_WALLET_LOCATION

cat sqlnet.ora

# sqlnet.ora Network Configuration File: /export/home/oracle/product/12c/product/12.2.0/dbhome_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ENCRYPTION_WALLET_LOCATION =
  (source =
    (method = file)
    (method_data =
      (directory = /export/home/oracle/product/12c/product/12.2.0/dbhome_1/network/admin)))


2. Set encryption key at container DB:

SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> alter system set encryption key identified by "password123";

System altered.

3. Take the backup of the created keystore.

Always create a backup of the keystore , before doing any changes.

SQL> administer key management backup keystore identified by "password123";

keystore altered.

4. Now set the keystore in the pluggable database(PDB).

In our case, SDC1 is a pluggable db.

SQL> alter session set container=SDCP1;

Session altered.


SQL> administer key management set keystore open identified by "password123";

keystore altered.

SQL> administer key management set key identified by "password123";

keystore altered.


SQL> select con_id,STATUS from V$ENCRYPTION_WALLET;

    CON_ID STATUS
---------- ------------------------------
         3 OPEN

5. Create the encrypted tablespace:

SQL> create tablespace ENCRYPT_TS datafile '/export/home/oracle/product/12c/oradata/ORA12CR2/SDCP1/encryp_ts1.dbf' size 1G encryption default storage(encrypt);

Tablespace created.

  
  SQL> select TABLESPACE_NAME,ENCRYPTED from dba_tablespaces where tablespace_name='ENCRYPT_TS';

TABLESPACE_NAME                ENC
------------------------------ ---
ENCRYPT_TS                     YES

We have successfully created an encrypted tablespace in the PDB.

ENCRYPTIONmultitenantPDB ORACLE 12C


Related Topics

How to create encrypted tablespace in PDB( oracle 12c)
Rollback database patch in oracle 12c
ENABLE_PARALLEL_DML hint in oracle 12c
How to run expdp in pluggable database(PDB)
Apply patch on oracle 12.2 database ( Release update)
Perform Flashback in pluggable database(PDB) in oracle 12.2
TRUST_EXISTING_TABLE_PARTITIONS in oracle 12.2 datapump
How to flashback a Pluggable database ( PDB) in oracle 12.2
OUTBOUND_DBLINK_PROTOCOLS in oracle 12.2

You May Also Like

How to rename Columns in R
Blackout targets in OEM 12c cloud control
WHAT IS SQL PROFILE IN ORACLE
Steps for upgrading weblogic 12.1.2 to 12.1.3
Shared Pool Advisory in oracle
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID
ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
Script to get cpu usage and wait event information in oracle database
ORA-16855: transport lag has exceeded specified threshold
Query clause in oracle datapump expdp

From This Website

How to drop a database in postgres
ORA-16855: transport lag has exceeded specified threshold
SQLCL UTILITY IN ORACLE
Hive Installation with derby
Setting up Table replication in oracle goldengate
Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh
Important views in For Oracle DBA in daily usage
How to flashback a Pluggable database ( PDB) in oracle 12.2
Steps To Set Up Master Slave Replication in MySQL
Oswatcher tool for collecting server diagnostic information