OCI : Create Create Tablespace in-PDB Fails with 'ORA-28374: Typed Master Key Not Found In Wallet' (Doc ID 2496205.1)

Last updated on JANUARY 01, 2024

Applies to:

Symptoms

Create new pdb using create pluggable database and then create tablespace in newly created pdb fails with error 'ORA-28374: typed master key not found in wallet'

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO

O Create PDB

SQL> create pluggable database "BTEST" admin user "PDBADMIN" identified by UsaB123##;
   Pluggable database created.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 BTEST MOUNTED  <<<<<<<

O Switch to newly created PDB

SQL> alter pluggable database BTEST open read write;

Pluggable database altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB1 READ WRITE NO
4 BTEST READ WRITE NO

SQL> alter session set container=BTEST;

Session altered.

O Create tablespace  using create tablespace command

CREATE TABLESPACE BAPEX DATAFILE
SIZE 5M AUTOEXTEND ON NEXT 1M MAXSIZE 15M
LOGGING
ENCRYPTION USING 'AES128'
DEFAULT
NO INMEMORY STORAGE (ENCRYPT)
ONLINE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

ERROR at line 1:
ORA-28374: typed master key not found in wallet

O Verify the wallet status for PDB : OPEN_NO_MASTER_KEY

SQL> SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;

WRL_PARAMETER STATUS WALLET_TYPE
------------------------------ --------------------
OPEN_NO_MASTER_KEY AUTOLOGIN

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.