Oracle Database Discussions

Dear Experts,

This is 12c Multitenant database and running on ASM.

I am trying to enable TDE for a entire tablespace which should be part of the pdb.

but getting an error.

column STATUS for a12
column WALLET_TYPE for a12
column WRL_PARAMETER for a40
select * from v$encryption_wallet;

WRL_TYPE   WRL_PARAMETER                            STATUS   WALLET_TYPE  WALLET_OR FULLY_BAC CON_ID
------------ -------------------------------------- -------- ------------ --------- --------- ------
FILE      /u01/app/oracle/admin/asmdbprd/wallet     OPEN      PASSWORD      SINGLE     NO      1


SQL> show con_name;
CON_NAME
------------------------------
CDB$ROOT

SQL> show pdbs
   CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
        2 PDB$SEED                       READ ONLY  NO
        3 ASMPRD1                        READ WRITE NO
        4 ASMPRD2                        READ WRITE NO


SQL> show pdbs   >>> PDB connected ...

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         3 ASMPRD1                        READ WRITE NO

CREATE TABLESPACE PDB_APPS_ENCRYPTION datafile '/u02/oradata/asmdbprd/asmprd1/PDB_apps_encryption_01.dbf' size 500m 
ENCRYPTION USING 'AES256'  DEFAULT STORAGE(ENCRYPT);

CREATE TABLESPACE PDB_APPS_ENCRYPTION datafile '/u02/oradata/asmdbprd/asmprd1/PDB_apps_encryption_01.dbf' size 500m
*
ERROR at line 1:
ORA-28365: wallet is not open

SQL> ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "wallet$123";
ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY "wallet$123"
*
ERROR at line 1:
ORA-65040: operation not allowed from within a pluggable database

Thanks