Oracle Database 12c Standard Edition
ERROR ORA-28374: typed master key not found in wallet ao criar tablespace
|
1 2 3 4 |
CREATE TABLESPACE TESTE DATAFILE '/u02/app/oracle/oradata/TESTE/ERP/teste.dbf' size 1024M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED; * ERROR at line 1: ORA-28374: typed master key not found in wallet |
Analisando o status da wallet do CDB$ROOT
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
SQL> show con_name; CON_NAME ------------------------------ CDB$ROOT column WRL_PARAMETER format a40; column STATUS format a10; column WALLET_TYPE format a10; SQL> SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet; WRL_PARAMETER STATUS WALLET_TYP ---------------------------------------- ---------- ---------- /u01/app/oracle/admin/EXM/tde_wallet/ OPEN AUTOLOGIN |
Close
|
1 2 3 |
SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE close; keystore altered. |
SET KEYSTORE
|
1 2 3 |
SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE open IDENTIFIED BY "j-sIc2#dPKFzoLI6PZ-4" CONTAINER=ALL; keystore altered. |
Acessando o PDB01
|
1 2 3 |
SQL> ALTER SESSION SET CONTAINER = PDB01; Session altered. |
SET KEY
|
1 2 3 |
SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY "j-sIc2#dPKFzoLI6PZ-4" with backup; keystore altered. |
Create Tablespace
|
1 2 3 |
SQL> CREATE TABLESPACE TESTE DATAFILE '/u02/app/oracle/oradata/EXM/SANKHYA/teste.dbf' size 10M AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED; Tablespace created. |
Resolvido!