Oracle 12.2 pdb create tablespace ORA-28365

在pbd中创建表空间报错ORA-28365
[code]SQL> create pluggable database pdb4 admin user pdbadmin identified by oracle;

Pluggable database created.

SQL> create tablespace pdb4_test datafile '/u05/pdb4_test.dbf' size 10m;
create tablespace pdb4_test datafile '/u05/pdb4_test.dbf' size 10m
*
ERROR at line 1:
ORA-28365: wallet is not open

SQL> select status, wallet_type, con_id from v$encryption_wallet;

STATUS WALLET_TYPE CON_ID
---------- -------------------- ----------
CLOSED UNKNOWN 6[/code]
由于oracle 12.2 cloud database开启了TDE，创建pdb后未自动创建秘钥，

创建并打开keystore
[code]SQL> alter session set container=pdb4;

Session altered.

SQL> administer key management set keystore open identified by Oracle_123 ;

keystore altered.

SQL> select status, wallet_type, con_id from v$encryption_wallet;

STATUS WALLET_TYPE CON_ID
-------------------- -------------------- ----------
OPEN_NO_MASTER_KEY PASSWORD 6[/code]
创建master key
[code]SQL> administer key management set key identified by Oracle_123 with backup ;

keystore altered.

SQL> select status, wallet_type, con_id from v$encryption_wallet;

STATUS WALLET_TYPE CON_ID
-------------------- -------------------- ----------
OPEN PASSWORD 6[/code]
再次创建
[code]SQL> create tablespace pdb4_test datafile '/u05/pdb4_test.dbf' size 10m;

Tablespace created.[/code]
打开auto login
[code]conn / as sysdba
administer key management create auto_login keystore from keystore '/u01/app/oracle/admin/orasql/tde_wallet/' identified by Oracle_123;[/code]
同时可以直接对所以容器进行操作：
[code]SQL> administer key management set keystore open identified by Oracle_123 container=all;

keystore altered.

SQL> administer key management set key identified by Oracle_123 with backup container=all;

keystore altered.

SQL> administer key management create auto_login keystore from keystore '/u01/app/oracle/admin/orasql/tde_wallet/' identified by Oracle_123;

keystore altered.[/code]