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

You May Also Like

How to use expdp to export data from physical standby database
How to find cpu and memory information of oracle database server
How to enable active dataguard in physical standby database
Change dbsnmp password for target db in oem 12c
How to get the execution plan for a SQL between two AWR snapshots
Oswatcher tool for collecting server diagnostic information
REUSE_DUMPFILES parameter in EXPDP
How to rename Columns in R
Find user commits per minute in oracle database
How to change spfile in Oracle RAC.

From This Website

Schema replication using oracle goldengate
How to install trace file analyzer( TFACTL)
ORA-32773: operation not supported for smallfile tablespace
Find sessions consuming lot of CPU
how to Print execution time of tasks in ansible
How to use oratop tool for oracle database monitoring
How to get the execution plan for a SQL between two AWR snapshots
_use_adaptive_log_file_sync parameter in oracle
Find pending distributed pending transactions in oracle
How to multiplex control file in standalone database