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

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

You May Also Like

LOG_CHECKPOINTS_TO_ALERT parameter in oracle
How to find execution history of an sql_id
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID
How to multiplex control file in standalone database
how to change archivelog destination in oracle
ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only
_use_adaptive_log_file_sync parameter in oracle
REUSE_DUMPFILES parameter in EXPDP
Clone a database using dbca command in oracle 19c -New feature
How to find cpu and memory information of oracle database server

From This Website

ENABLE_PARALLEL_DML hint in oracle 12c
Script to get cpu usage and wait event information in oracle database
Important views in For Oracle DBA in daily usage
How to create encrypted tablespace in PDB( oracle 12c)
orapwd tool for password file in oracle
Apply database proactive bundle patch in RAC using manual process
How to start MySQL on Linux and Windows
Standby redologs in oracle dataguard
How to enable flash recovery area in oracle database
Unified audit trail in Oracle 12c